Can I use multiple ADO.Net Entity Models in a single ASP.NET MVC project

Question

I am developing an ASP.NET MVC web application & using ADO.NET Entity Data Model (Entity Framework) as A model. In one view, I want to autocomplete the table column values from other database which is located in another server as B model.

Here one thing, the tables for controller which I am using have the same name in both the models A & B as Employee table. So, I have created a new folder and added Entity Framework as model B in that folder.

In local host it is working fine. But where as coming to the production, I get an error

Login failed for user xxxxx**

I have cross checked all the solutions like changes in web.config file and all. No solution found to resolve my error.

So, here's my question: can I use multiple ADO.NET entity models in a single ASP.NET MVC project?

If yes, how to do that? Please let me know.

Thanks in advance.

Absolute answer will be appreciated

Error:

.

Yes, you can have multiple models, but that error message seems unrelated. Looks like SQL Server permissions. The following may help: stackoverflow.com/questions/33255223/… — Tawab Wakil
– Tawab Wakil, Commented May 18, 2022 at 18:58

Chintan Chheda · Accepted Answer · 2022-05-21 09:41:36Z

1

Yes you can use multiple models but I think this error might have been caused by error in connection string please check your connection string

answered May 21, 2022 at 9:41

Chintan Chheda

444 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can I use multiple ADO.Net Entity Models in a single ASP.NET MVC project

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related