CODEWITHSUNDEEP
c#asp.netasp.net-mvcentity-framework
cavillac
cavillac

Reputation: 1311

How can I bind my MVC Model to a different table

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?

Upvotes: 3

Views: 3562

Answers (1)

Tomislav Markovski
Tomislav Markovski

Reputation: 12346

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"
    }
}

Upvotes: 4

Related Questions