I have noticed that if I create an ObjectContext or a decendant of ObjectContext (like pubsEntities from Building an EF 4 Model Assembly for Pubs DB), LINQPad can’t get the connection string correctly.
<?xml version="1.0" encoding="utf-8"?> <configuration> <connectionStrings> <add name="pubsEntities" connectionString="metadata=res://*/PubsModel.csdl| res://*/PubsModel.ssdl|res://*/PubsModel.msl; provider=System.Data.SqlClient; provider connection string='data source=.\SQLEXPRESS; attachdbfilename="C:\MDF\pubs.mdf"; integrated security=True;connect timeout=30; user instance=True;multipleactiveresultsets=True;App=EntityFramework'" providerName="System.Data.EntityClient" /> </connectionStrings> </configuration>
So I take the connection string from the app.config:
And copy it to a LINQPad C# Program .linq file as a constant on the top of the file (I am calling the constant EF_CONNECTION_STRING):
const string EF_CONNECTION_STRING = @"metadata=res://*/PubsModel.csdl|res://*/PubsModel.ssdl|res://*/PubsModel.msl;" + @"provider=System.Data.SqlClient;" + @"provider connection string='data source=.\SQLEXPRESS;attachdbfilename=" + "\"" + @"C:\MDF\pubs.mdf" + "\"" + @";;integrated security=True;connect timeout=30;user instance=True;" + @"multipleactiveresultsets=True;App=EntityFramework'"; void Main() { PubsModel.pubsEntities context = new PubsModel.pubsEntities(EF_CONNECTION_STRING); // Use Context Here }
No comments:
Post a Comment