.Net Core与存储过程(一)
例子1 C# 调用存储过程
CREATE PROCEDURE [dbo].[spFunc]
@id BIGINT, @isTrue BIT, @str NVARCHAR (60), @strZh NVARCHAR (60)
AS
BEGINSELECT *FROM tableAWHERE id = @idAND isTrue = @isTrueAND str = @strAND strZh = @strZh;
END
long idLong = 18;
bool isBoolean = true;
string str= "str";
string strZh = "中文";
var tables = _db.TblA.FromSql($"exec spFunc {idLong},{isBoolean},{firstName},{lastNameZh}").ToList();