c# - How to provide database configuration settings in code-first Entity Framework? -
i not using localdb or ./sqlexpress have use server name
msoldev03\sql2012 here code generating database; when run sqlconnection error "server not found":
public class blog { public int blogid { get; set; } public string name { get; set; } public virtual list<post> posts { get; set; } } public class post { public int postid { get; set; } public string title { get; set; } public int blogid { get; set; } public virtual blog blog { get; set; } } public class bloggingcontext : dbcontext { public dbset<blog> blogs { get; set; } public dbset<post> posts { get; set; } } i used command
enable-migrations this command makes migration folder not generate database on sql server instance msoldev03\sql2012
then tried run code
using (var db = new bloggingcontext()) { db.blogs.add(new blog { name = "another blog " }); db.savechanges(); foreach (var blog in db.blogs) { console.writeline(blog.name); } } console.writeline("press key exit..."); console.readkey(); still not generate database gives error connection sql server not found.
here app.config file contains no sql connection
<entityframework> <defaultconnectionfactory type="system.data.entity.infrastructure.localdbconnectionfactory, entityframework"> <parameters> <parameter value="mssqllocaldb" /> </parameters> </defaultconnectionfactory> <providers> <provider invariantname="system.data.sqlclient" type="system.data.entity.sqlserver.sqlproviderservices, entityframework.sqlserver" /> </providers> </entityframework>
in context class constructor, can give key like:
public bloggingcontext() : base("name=bloggingcontextkey") { } and give key value in configuration file:
<connectionstrings> <add name="bloggingcontextkey" connectionstring="data source=<your server>; initial catalog=<database>;user=<user>;pwd=<password>;" providername="system.data.sqlclient" /> </connectionstrings>
Comments
Post a Comment