How can I map an entity framework model to multiple tables? How to perform insertion operation to specific table (by reference of string which stores the table name)?
Add a comment
|
2 Answers
I have not implemented this but a quick search provides many good examples of a practice known as Entity Splitting. The following should be useful:
public partial class Employee
{
// These fields come from the “Employee” table
public int EmployeeId { get; set; }
public string Code { get; set; }
public string Name { get; set; }
// These fields come from the “EmployeeDetails” table
public string PhoneNumber { get; set; }
public string EmailAddress { get; set; }
}
public partial class Model : DbContext
{
public Model() : base("name=EntityModel")
{
Database.Log = Console.WriteLine;
}
public virtual DbSet<Employee> Employees { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Employee>()
.Map(map =>
{
map.Properties(p => new
{
p.EmployeeId,
p.Name,
p.Code
});
map.ToTable("Employee");
})
// Map to the Users table
.Map(map =>
{
map.Properties(p => new
{
p.PhoneNumber,
p.EmailAddress
});
map.ToTable("EmployeeDetails");
});
}
}
All credit for the above code goes to linked post
3 Comments
Sasi
Here we are mapping one entity to two different tables. But I need to make the table mapping dynamically. For example, Database contains schools details from different states. Details from each state should go to the particular state table. Here entity properties are same, but every time we may have to map different tables.
benjamingranados
I know this has some time; but for others to know, maybe you have to use IModelCacheKeyFactory. Here's an article that uses dynamic tables: medium.com/@yanxiaodi/…
Karthic G
What is the equivalent of Map() in EF Core
In this case you can implement your own IModelCacheKeyFactory, which allow to hook into the model caching mechanism so EF is able to create different models based on some value right in runtime.
1 Comment
Artem A
A link to a paid resource? rly?