title: Creating a Controller for DevOps in .Net Core
body: <p>I have a database schema known as BigDataOverview. Most of my Application is already connected to a different schema known as AdminDb.</p>
  
  <p>I also have a .Net Core Application that is well integrated with my AdminDb schema.</p>
  
  <p>My secondary schema has 13 different tables, that are named with numbers as names and a single table that is named "SimpleDataOverview".</p>
  
  <p>I now want to add this secondary schema to my application so that I can <code>{ get; }</code> the data to display it in my application.</p>
  
  <p>I have set up my ConnectionString in my <strong>appsettings.json</strong>:</p>
  
  <pre><code>"ConnectionStrings": {
      "DefaultConnection":"server=&lt;placeholder&gt;;database=AdminDB;sslmode=none;",
      "OverviewDataConnection": "server=&lt;placeholder&gt;;database=BigDataOverview;sslmode=none;"
  }
  </code></pre>
  
  <p>All of the 13 tables that have numbers as names are identical to each other in terms of fields (columns). Therefore I have created a model to match all of them: <strong>NumberTableModel.cs</strong></p>
  
  <pre><code>public class NumberTableModel
  {
      [Key]
      public int RowID { get; }
  
      public int SensorID { get; }
      public DateTime ReadingDate { get; }
      public int ReadingCount { get; }
      public float ApproxDataSize { get; }
      public Time ReadingTime { get; }
      public string JsonData { get; }
      public long LastUpdate { get; }
      public string Source { get; }
  }
  </code></pre>
  
  <p>I've also created a DbContext: <strong>DevOpsDbContext</strong></p>
  
  <pre><code>public class DevOpsDbContext : DbContext
  {
      public DevOpsDbContext(DbContextOptions&lt;DevOpsDbContext&gt; options) : base(options)
      {
      }
  
      public DbSet&lt;NumberTableModel&gt; _353224061929963 { get; set; }
      public DbSet&lt;NumberTableModel&gt; _353224061929964 { get; set; }
      public DbSet&lt;NumberTableModel&gt; _353224061929965 { get; set; }
  
      protected override void OnModelCreating(ModelBuilder modelBuilder)
      {
          modelBuilder.Entity&lt;NumberTableModel&gt;().ToTable("353224061929963");
          modelBuilder.Entity&lt;NumberTableModel&gt;().ToTable("353224061929964");
          modelBuilder.Entity&lt;NumberTableModel&gt;().ToTable("353224061929965");
      }
  }
  </code></pre>
  
  <p>And I have set it up in my <strong>Startup.cs</strong>:</p>
  
  <pre><code>services.AddDbContext&lt;DevOpsDbContext&gt;(options =&gt;
     options.UseMySql(Configuration.GetConnectionString("OverviewDataConnection")));
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/6EvKk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6EvKk.png" alt="enter image description here"></a></p>
  
  <p>However when I try to create a <code>Controller</code> with views, using Entity Framework, Visual Studio will complain with the following Error Message: </p>
  
  <p><a href="https://i.stack.imgur.com/vWkjJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vWkjJ.png" alt="enter image description here"></a></p>
  
  <p>And I believe I do.... I'd be very grateful for any assistance.</p>