Entity Framework 6

標籤：frame   uri   ocs   nta   write   utf-8   form   ef6   efi   

參考官方文檔中入門找到對應的執行個體建立第一個EFCodeFirst執行個體

 

 1：建立CodeFirstNewDatabaseSample控制台應用程式

 2：擷取Entity Framework，添加EF 參看

https://docs.microsoft.com/zh-cn/ef/ef6/fundamentals/install

3：添加以下代碼

 

 

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

namespace CodeFirstNewDatabaseSample
{
    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 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("BlogContext") { }

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

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

    }
}

 

這個是設定檔

 

 

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>

  <connectionStrings>
    <add name="BlogContext"
          providerName="System.Data.SqlClient"
          connectionString="Server=.;Database=Blogging;Integrated Security=True;"/>
  </connectionStrings>


 
</configuration> 

 

 

 

 代碼分享如下

 

連結：https://pan.baidu.com/s/1lEZeprJB4y3_APKrIYD1oA
提取碼：bvbo
複製這段內容後開啟百度網盤手機App，操作更方便哦 

 

Entity Framework 6