MVC Crud Ado Model EF

Blumonde

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Accepted answer
Hi Blumonde,
No need to create many connection string,you 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
Blumonde10y ago
Hello,
Can someone please help me solve this issue? Many thanks in advance.
Blumonde10y ago
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.