例子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();