.Net平臺下相容.NET Standard 2.0，一個實現以Lambda表達式轉轉換標準SQL語句，使用強類型操作數據的輕量級ORM工具，在減少魔法字串同時，通過靈活的Lambda表達式組合，實現業務數據查詢的多樣性 ...
.Net平臺下相容.NET Standard 2.0，一個實現以Lambda表達式轉轉換標準SQL語句，使用強類型操作數據的輕量級ORM工具，在減少魔法字串同時，通過靈活的Lambda表達式組合，實現業務數據查詢的多樣性。
一、存儲過程數據獲取
1、存儲過程
Create PROCEDURE [dbo].[CustOrderHist] @CustomerID nchar(5)
AS
SELECT ProductName, Total=SUM(Quantity)
FROM Products P, [Order Details] OD, Orders O, Customers C
WHERE C.CustomerID = @CustomerID
AND C.CustomerID = O.CustomerID AND O.OrderID = OD.OrderID AND OD.ProductID = P.ProductID
GROUP BY ProductName
2、實例一個執行器
string cnstr = "Data Source=(local);Initial Catalog=Northwind;User ID=test;Password=test";
ConnectionStringConnectionProvider connectionProvider = new ConnectionStringConnectionProvider(cnstr);
IStatementExecutor target = new StatementExecutor(new SqlLogger(new List<ISqlLogWriter>() { new NoOpSqlLogger() }), connectionProvider);
3、參數定義
var paramDef = new ParameterDefinition[]
{
new ParameterDefinition
{
Name = "CustomerID",
Value = "ALFKI"
}
};
4、調用ExecuteStoredProcedure獲取一個IDataReader
IDataReader dataReader = target.ExecuteStoredProcedure("CustOrderHist", paramDef);
while (dataReader.Read())
{
Console.WriteLine($"ProductName: {dataReader["ProductName"]},Total: {dataReader["Total"]}");
}
二、InputOutput、OutPut參數
1、存儲過程
ALTER PROCEDURE [dbo].[MyTestOutParam]
( @testint int output,@teststr nvarchar(50) output )
AS
BEGIN
SELECT @testint=100+@testint, @teststr='test out put 測試'
END
2、參數定義
var paramDef2 = new ParameterDefinition[]
{ new ParameterDefinition
{ Name = "@testint",
DbType=DbType.Int32,
Direction=ParameterDirection.InputOutput,
Value=99, },
new ParameterDefinition
{ Name = "@teststr",
DbType=DbType.String,
Direction=ParameterDirection.Output,
Size=100 }
};
3、調用ExecuteStoredProcedure
var dataReader2 = target.ExecuteStoredProcedure("MyTestOutParam", paramDef2);
4、調用GetParameterCollection方法獲取返回值
dataReader2.GetParameterCollection(paramDef2);
