We have a database with multiple tables with Same structure
Key ID ........
Key ID .......
The number of tables can be dynamic based on configuration.
I am trying to upgrade the data access Layer to Entity framework. I have created one class representing the structure of the table. My Plan is to use the same class for all the tables with same structure. Bubt I could not find enough information on how to do this. What I understood is that I can map one class to one table only.
Is there any way to achieve this using entity framework?
The easy way: have an abstract base class with all the properties, and map concrete types:
public abstract class BaseClass
{
public int Id { get; set; }
public string StringField { get; set; }
/* Other fields */
}
[Table("Table1")]
public class Table1 : BaseClass
{
}
[Table("Table2")]
public class Table2 : BaseClass
{
}
I'm not answering whether that design is good or bad (I wouldn't say I like it as you explained it), I'm just answering the question