How can I bind my MVC Model to a different table

Question

This seems like an easy question but I can't seem to find the answer.

I have a Model that looks like this ...

public class Application
{

    public int Id { get; set; }
    public string Title { get; set; }
    public string LeadProgrammer { get; set; }
    public string ConnectionStringCode { get; set; }
}

public class ApplicationDBContext : DbContext
{
    public DbSet<Application> Applications { get; set; }
}

My actual table name is DBA_APPLICATIONS ... the model is, of course, just looking for dbo.Applications. How can I change this routing to the actual table?

Answer 1

Add this in your ApplcationDBContext class.

public class ApplicationDBContext : DbContext
{
    public DbSet<Application> Applications { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Application>().ToTable("DBA_APPLICATIONS");
        // otherwise EF assumes the table is called "Applications"
    }
}