//Sql Server Database Provider
PM> Install-Package Microsoft.EntityFrameworkCore.SqlServer

//提供Add-Migration，Update-Database等Powershell命令
PM> Install-Package Microsoft.EntityFrameworkCore.Tools 

using System;
using System.Collections.Generic;
using System.Text;

using Microsoft.EntityFrameworkCore;

using Libing.App.Models.Entities;namespace Libing.App.Models
{
    public class LibingContext : DbContext
    {
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            // 数据库连接
            optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=Libing;Integrated Security=True;");
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
        }

        public DbSet<Role> Roles { get; set; }
    }
}

PM> Add-Migration InitialCreate

PM> Update-Database

using System;

using Libing.App.Models;
using Libing.App.Models.Entities;

namespace Libing.App
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var context = new LibingContext())
            {
                var role = new Role
                {
                    RoleName = "管理员"
                };

                context.Roles.Add(role);

                context.SaveChanges();
            }
        }
    }
}

exec sp_executesql N‘SET NOCOUNT ON;
INSERT INTO [dbo].[Role] ([RoleName])
VALUES (@p0);
SELECT [RoleID]
FROM [dbo].[Role]
WHERE @@ROWCOUNT = 1 AND [RoleID] = scope_identity();

‘,N‘@p0 nvarchar(100)‘,@p0=N‘管理员‘