MVC Crud Ado Model EF

Question

Hello Everytime I build a new crud on a table from the SAME database via the Model folder MVC Ado Model EF wants to create a new connectionstring in web.config. Scaffolding via the Controller folder will not work if I force Ado Model EF to use the existing connectionstring in web.config. Scaffolding will only work if I allow Ado Model EF to create a new connectionstring in web.config. Can someone please explain to me why does MVC do this? And what should I do in this case? I have like a hundred tables in the same database. Does it mean I have to have 100 connectionstrings in web.config? This is ridiculous if this is how Microsoft built MVC. Thanks in advance.

Bikesh Srivastava · Answer

Hi Blumonde No need to create many connection stringyou can use multiple table using single connection string but which table have not primary key you can not use.in EF. Follow this msdn link. https://msdn.microsoft.com/en-in/data/jj206878.aspx

Blumonde · Answer

Hello Can someone please help me solve this issue? Many thanks in advance.

Blumonde · Answer

Thank you Bikesh but unfortunately I tried to follow the example of the link by using the database updating method and received the error Cannot continue without connnectionstring for it when scaffolding the new table. The scaffolding will not work if there is no connection string created for the new table.