public void TwoRecordsetsAreReturned()
{
var results = Connection().QueryResultsSql <ParentTestData, TestData2>(ParentTestData.Sql + TestData2.Sql);
Assert.IsNotNull(results);
ParentTestData.Verify(results.Set1, withGraph: false);
TestData2.Verify(results.Set2);
}
public void RecordsetWithDefaultGraphIsReturned()
{
var results = Connection().QueryResultsSql <ParentTestDataWithDefaultGraph, TestData2>(ParentTestData.Sql + TestData2.Sql);
Assert.IsNotNull(results);
ParentTestData.Verify(results.Set1, withGraph: true);
TestData2.Verify(results.Set2);
}
public void TestMultipleRecordsetsWithGraph()
{
Results <ParentTestData, TestData2> results = Connection().Dynamic().GetParentAndChildTestData(
returns: Query.Returns(OneToOne <ParentTestData, TestData> .Records)
.Then(Some <TestData2> .Records));
Assert.IsNotNull(results);
ParentTestData.Verify(results.Set1, withGraph: true);
TestData2.Verify(results.Set2);
}
public void EmptyListDoesNotTerminateResults()
{
// expect two recordsets, first set is empty. first set should be empty, second should be full
var results = Connection().QueryResultsSql <ParentTestData, TestData2>("SELECT 0 WHERE 0=1;" + TestData2.Sql);
Assert.IsNotNull(results);
Assert.IsNotNull(results.Set1);
Assert.AreEqual(0, results.Set1.Count);
TestData2.Verify(results.Set2);
}
public void TestMultipleRecordsets()
{
// going to infer the return type of the stored procedure rather than specifying it
Results <ParentTestData, TestData2> results = Connection().Dynamic().GetParentAndChildTestData(
returns: Query.Returns(Some <ParentTestData> .Records)
.Then(Some <TestData2> .Records));
Assert.IsNotNull(results);
ParentTestData.Verify(results.Set1, withGraph: false);
TestData2.Verify(results.Set2);
}
public void RecordsetWithGraphIsReturned()
{
var results = Connection().QueryResultsSql <ParentTestData, TestData2>(
ParentTestData.Sql + TestData2.Sql,
null,
withGraphs: new[] { typeof(Graph <ParentTestData, TestData>) });
Assert.IsNotNull(results);
ParentTestData.Verify(results.Set1, withGraph: true);
TestData2.Verify(results.Set2);
}
public void TestMultipleRecordsets()
{
using (var connection = ConnectionWithTransaction())
{
connection.ExecuteSql("CREATE PROC InsightTestProc (@Value varchar(128)) AS " + ParentTestData.Sql + TestData2.Sql);
string value = "foo";
var dc = connection.Dynamic();
// going to infer the return type of the stored procedure rather than specifying it
Results <ParentTestDataWithDefaultGraph, TestData2> results = dc.InsightTestProc(value, returnType: typeof(Results <ParentTestDataWithDefaultGraph, TestData2>));
Assert.IsNotNull(results);
ParentTestData.Verify(results.Set1, withGraph: true);
TestData2.Verify(results.Set2);
}
}
