Entity Framework database-first - dynamically adding table to model

Question

I have tables with the same structure but with a letter prefix of every table.

For example:

A_Company, B_Company, C_Company

There is combo box from which the user can select A, B or C, and then the code saves data into the appropriate table.

How can I do this using EF database-first?

Answer 1

I solved this problem adding a column for code prefix and triggers on my base table company for insert update and delete.