//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;

namespace Libing.App.Models.Entities

{

    public class Role

    {

        public int RoleID { get; set; }

        public string RoleName { get; set; }

    }

}

Role.cs

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'管理员'