Using the POCO template, get the Entity Framework connection string.

.net app-config c# entity-framework

Question

I use Entity Framework and I need to get my connection string so I can construct a context.

I am using the POCO template. My context object has:

string ConnectionString = "name=MyAppConfigConnectionStringPropertyHere"

So when I try to just construct my context it says

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

I saw in this answer that indicated that there is a GetConnectionString() method. But googling has not lead me to the reference I need to add to get that method (it is not in my project by default).

So, I can't think that I am the first one who wants to get a connection string for entity framework using the POCO templates. How have others done this? I guess I can just read in the whole app.config file and parse it out. But it seems like it should not be that hard.

Any hints would be great!

1
10
5/23/2017 11:47:05 AM

Popular Answer

For entity framework 6.0, following code gives current ConnectionString.

context.Database.Connection.ConnectionString
28
5/8/2017 10:31:57 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow