How to have multiple projects accessing same Entity Framework project?

Question

Ok, this question has been asked many times. Just googling with the error message:

The specified named connection is either not found in the configuration,
not intended to be used with the EntityClient provider, or not valid.

I have tried all suggestions on forums, help sites et blogs... nothing works!

Situation recap

I'm splitting solution into three different projects: one for my model with EF4, one of WinForm and one ASP.NET MVC web application. I have a problem with connections string and configuration.

Is there a updated solution using VS2010/EF4/.NET Framework 4.0?

See this question.

TGnat
– TGnat

2010-04-27 20:33:10 +00:00
Commented Apr 27, 2010 at 20:33 — TGnat
– TGnat, Commented Apr 27, 2010 at 20:33

Kevin Pang · Accepted Answer · 2010-04-27 20:29:13Z

5

Not sure, but you may have to move the Entity Framework configuration sections in your EF4 project's app.config file to both your WinForm app.config and ASP.NET MVC web.config files.

answered Apr 27, 2010 at 20:29

Kevin Pang

41.5k38 gold badges123 silver badges173 bronze badges

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

Comments

sgy · Accepted Answer · 2010-04-27 21:53:48Z

Really, the answer is copying the <connectionStrings> section in the other project's config files like mentionned above.

<connectionStrings>
    <add name="DataEntities" connectionString="metadata=res://*/DataModel.csdl|res://*/DataModel.ssdl|res://*/DataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=xxx;Initial Catalog=xxx;User Id=xxx;Password=xxx;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

So, it's the same answer as I saw before on many sites. In fact, it was working from the beginning, but I had another error ("Configuration system failed to initialize"), so I thought it was a wrong value of the connection string in the app.config. In fact, the app.config was valid, but just moving the section on bottom solved this... Bizarre?

Collectives™ on Stack Overflow

How to have multiple projects accessing same Entity Framework project?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related