public async Task SingleRowFromTableValuedFunction()
{
var db = new SPTestsDatabase();
// Accessing table value functions on SQL Server (different syntax from Postgres, for example)
var person = await db.SingleFromQueryWithParamsAsync("SELECT * FROM dbo.ufnGetContactInformation(@PersonID)", new { @PersonID = 35 });
Assert.AreEqual(typeof(string), person.FirstName.GetType());
}
public async Task SingleRowFromTableValuedFunction()
{
var db = new SPTestsDatabase(ProviderName);
var record = await db.SingleFromQueryWithParamsAsync("SELECT * FROM table(GET_EMP(:p_EMPNO))", new { p_EMPNO = 7782 });
Assert.AreEqual(7782, record.EMPNO);
Assert.AreEqual("CLARK", record.ENAME);
}