public void OutputParamFromRawSql_IsMoreBetter()
{
var db = new MightyOrm(ConnectionStrings.AdventureWorksFull);
var result = db.ExecuteWithParams("SELECT @MyOutParam = @0 + 13 WHERE 42 = @0",
outParams: new { MyOutParam = (int?)null }, args: 44);
Assert.IsNull(result.MyOutParam);
}
public void OutputParamFromRawSql_IsBetter2()
{
var db = new MightyOrm(ConnectionStrings.AdventureWorksFull);
var result = db.ExecuteWithParams("SELECT @sum = @a + @a + @b",
outParams: new { sum = (int?)null },
inParams: new { a = 1, b = 3 });
Assert.AreEqual(5, result.sum);
}
public void OutputParamFromRawSql_IsBetter()
{
var db = new MightyOrm(ConnectionStrings.AdventureWorksFull);
var result = db.ExecuteWithParams("SELECT @sum = @0 + @0 + @1",
outParams: new { sum = (int?)null },
args: new object[] { 1, 3 });
Assert.AreEqual(5, result.sum);
}