.net - How to connect to local SQL Server? -
i trying run .net solution @ local pc, have set sql server 2008 , have imported database.
when trying run solution , connection error:
the specified named connection either not found in configuration, not intended used entityclient provider, or not valid.
the exception thrown by
/// initializes new sdementities object using connection string found in 'sdementities' section of application configuration file. /// </summary> public sdementities() : base("name=sdementities", "sdementities") { this.contextoptions.lazyloadingenabled = true; oncontextcreated(); }
i have specified entity name. entityclient
provider specified in connection string....
the connection string in web.config
file , looks this:
<add name="sdementities" connectionstring="metadata=res://*/models.sdemmodel.csdl|res://*/models.sdemmodel.ssdl|res://*/models.sdemmodel.msl;provider=system.data.sqlclient;provider connection string="data source=t2m-03-meclab-1\sqlexpress;user id=oeeuser;password=pwdadmin;initial catalog=sdem;persist security info=true;multipleactiveresultsets=true;app=entityframework"" providername="system.data.entityclient" />
can provide clue should solve problem?
the user id , password both correct. because of data source?
Comments
Post a Comment