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