DbSet<TEntity>.FromSql()

DbContext.Database.ExecuteSqlCommand()

USE [Library]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_getbooks]
   @name nvarchar(50)
  AS
  BEGIN
   SET NOCOUNT ON;
   select * from books where name like @name +'%'
  END
GO

//用 FromSql 调存储过程
   var name = "C";

   var books = _context.Books
      .FromSql($"proc_getbooks {name}")
      .ToList();

   //or 使用 exec 关键字调用存储过程
   //var books = _context.Books.FromSql($"exec proc_getbooks {name}").ToList();

   //or 使用 SqlParameter 实例进行参数的插入
   //var param = new SqlParameter()
   //{
   // ParameterName = "@name",
   // SqlDbType = System.Data.SqlDbType.NVarChar,
   // Direction = System.Data.ParameterDirection.Input,
   // Size = 50,
   // Value = name
   //};

   //or 使用 @p0 代表第一个参数，则 @p1 就代表第二个参数等以此类推
   //var books = _context.Books.FromSql("proc_getbooks @p0", name).ToList();

//用 FromSql 多次调同一个存储过程
   var name = "C";

   var list1 = _context.Books.FromSql($"proc_getbooks {name}").ToList();

   var list2 = _context.Books.FromSql($"proc_getbooks {name}").ToList();

   var list3 = _context.Books.FromSql($"proc_getbooks {name}").ToList();

CREATE PROCEDURE [dbo].[proc_createbook]
 @name Varchar(50),
 @author Varchar(50),
 @cateid int
AS
BEGIN
 SET NOCOUNT ON;
 Insert into books(
   [name]
   ,[author]
   ,[createtime]
   ,[isdel]
   ,[cateid]
   )
 Values (@name, @author,GETDATE(),0,@cateid)
END
GO

   //用 ExecuteSqlCommand 调存储过程, 用parameters: new[] {}也是可以的
   var name = "C# 高级进阶";
   var author = "-";
   var cateid = 1;
   _context.Database.ExecuteSqlCommand("proc_createbook @p0,@p1,@p2", name, author, cateid);