entity framework - Why won't my connection string work? -
could tell me why connection string isn't working.. i'm using database first, don't know why wont connect. whenever try error 'the network path not found'
connection string is: <add name="factsandfiguresentities1" connectionstring="metadata=res://*/models.model1.csdl|res://*/models.model1.ssdl|res://*/models.model1.msl;provider=system.data.sqlclient;provider connection string='data source=servername user id=****; password = **** catalog=factsandfigures;integrated security=true;multipleactiveresultsets=true;application name=entityframework'" providername="system.data.entityclient" />
the error network path not found, refer how referencing metadata files. when use "res://" ef tries load metadata assemblies in bin catalogue of application. have bin catalogue?
also notice use both integrated security=true , username/password. system use 1 or other not both.
for details on ef connection strings see: https://msdn.microsoft.com/en-us/library/vstudio/cc716756(v=vs.100).aspx
Comments
Post a Comment