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); }