How to provide database configuration settings in code-first Entity Framework?

Question

I am not using localdb or ./sqlexpress I have to use server name

MSOLDEV03\SQL2012

Here is my code for generating database; when I run I get a 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 but does not generate database on my SQL Server instance MSOLDEV03\SQL2012

Then I tried to run this 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 any key to exit...");
  Console.ReadKey();

Still not generate database but gives error connection to SQL Server not found.

Here is my 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>

shrekDeep · Accepted Answer · 2015-06-19 07:47:18Z

1

In your context class constructor, you can give the key like:

public BloggingContext() : base("name=BloggingContextKey")
        {

        }

and then give this key a value in your configuration file:

<connectionStrings>
    <add name="BloggingContextKey" connectionString="Data Source=<Your server>; Initial Catalog=<Database>;user=<user>;pwd=<password>;" providerName="System.Data.SqlClient" />
  </connectionStrings>

answered Jun 19, 2015 at 7:47

shrekDeep

2,3037 gold badges28 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

ODeak Team Over a year ago

but Initial Catalog=<Database> i have to create database there is no existing database

ODeak Team Over a year ago

Enable-Migrations -ContextTypeName BloggingContextKey -EnableAutomaticMigrations -ConnectionStringName BloggingContextKey but gives error context BloggingContextKey not found

ODeak Team Over a year ago

how to give server name in passing parameters in package manager console along with enable migrations\

shrekDeep Over a year ago

In code first, first you define classes i.e. your business model. Database will be created automatically when you first time use BloggingContext.

ODeak Team Over a year ago

ANSWERS: Initial Catalog=<Database NAME TO CREATE>

|

Collectives™ on Stack Overflow

How to provide database configuration settings in code-first Entity Framework?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related