edmx connection string

Question

I am developing an application that uses edmx for dataaccess.
I realized that each edmx file have its own connection string in the configuration file.
Is there a way to share one connection string for all the edmx files?

RPM1984 · Accepted Answer · 2010-12-20 11:43:22Z

1

No - there isn't.

And for good reason. The connection string in Entity Framework contains much more than regular connection strings (e.g data source / database name).

It contains crucial information about the different components of the model, including the CSDL, which is unique to the model.

Perhaps you could explain if you are planning to share a connection string between different EDMX's, then why do you need seperate EDMX's in the first place?

If your looking at a way to dynamically create a connection string then look at EntityConnectionStringBuilder.

answered Dec 20, 2010 at 11:43

RPM1984

73.3k62 gold badges241 silver badges364 bronze badges

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

1 Comment

Jaxidian Over a year ago

It makes sense to use separate EDMXes if your database is large enough that you need to partition your tables up. An EDMX cannot reasonably handle over 150 tables. I couldn't even get it to respresent our entire database - we have it partitioned up into ~20 different EDMXes. That said, I totally understand the reasons for not sharing the connection strings (CSDL, SSDL, MSL). I just wanted to point out the issues with very large databases.

Collectives™ on Stack Overflow

edmx connection string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related