Entity Framework 连接字符串

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity;

namespace CodeFirstNewDatabaseSample
{

    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 string Content { get; set; }

        public int BlogId { get; set; }
        public virtual Blog Blog { get; set; }
    }

    public class BloggingContext : DbContext
    {
        public BloggingContext()
            : base("name=BlogContext") { } 

        public DbSet<Blog> Blogs { get; set; }
        public DbSet<Post> Posts { get; set; }
    }


  class Program
   {
       static void Main(string[] args)
        {
            using (var db = new BloggingContext())
            {
                // Create and save a new Blog 
                Console.Write("Enter a name for a new Blog: ");
                var name = Console.ReadLine();

                var blog = new Blog { Name = name };
                db.Blogs.Add(blog);
                db.SaveChanges();

                // Display all Blogs from the database 
                var query = from b in db.Blogs
                            orderby b.Name
                            select b;

                Console.WriteLine("All blogs in the database:");
                foreach (var item in query)
                {
                    Console.WriteLine(item.Name);
                }

                Console.WriteLine("Press any key to exit...");
                Console.ReadKey();
            }
     }
 }
}

添加基于服务的数据库 

 

 public BloggingContext()
            : base("name=BlogContext") { }  // 连上字符串

或者

 public BloggingContext()
            : base("BlogContext") { }  // 连上字符串

或者等等

App.config 添加内容

 

  <connectionStrings>
    <add name="BlogContext" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\SchoolWork\软件\数据库连接\CodeFirstNewDatabaseSample\CodeFirstNewDatabaseSample\BlogDatamdf.mdf;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

字符串来源

 

 

另外 要在每个项目里面都要添加connectionStrings

 

转载于:https://www.cnblogs.com/luoxu/p/4593125.html