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

Popular posts from this blog

How to connect android app to App engine -

gcc - MinGW's ld cannot perform PE operations on non PE output file -

php - display validation error message next to the textbox in codeigniter -