public int GetComplexTypeModelCount()
{
ICraneAccess dataAccess = new SqlServerAccess(ConnectionString);
return(dataAccess
.Query()
.ExecuteScalar <int>("dbo.GetComplexModelCount"));
}
public List <ReservedColumnNameTest> GetReservedColumnNameTests()
{
ICraneAccess dataAccess = new SqlServerAccess(ConnectionString);
return(dataAccess
.Query()
.ExecuteReader <ReservedColumnNameTest>("dbo.GetReservedColumnNameTests")
.ToList());
}
public List <SchemaTest2> GetSchemaTest2List()
{
ICraneAccess dataAccess = new SqlServerAccess(ConnectionString);
return(dataAccess
.Query()
.AddSqlParameter("@Schema", "AnotherSchema")
.ExecuteReader <SchemaTest2>("dbo.GetSchemaTest")
.ToList());
}
public List <Book> GetBookList(string isbn = null)
{
ICraneAccess dataAccess = new SqlServerAccess(ConnectionString);
return(dataAccess
.Query()
.AddSqlParameter("@Isbn", isbn)
.ExecuteReader <Book>("dbo.GetBooks")
.ToList());
}
public List <CustomIdentityColumnNameTest> GetCustomIdentityColumnNameTestList()
{
ICraneAccess dataAccess = new SqlServerAccess(ConnectionString);
return(dataAccess
.Query()
.CustomColumnMapping <CustomIdentityColumnNameTest>(x => x.Id, "ID_COMPANY")
.ExecuteReader <CustomIdentityColumnNameTest>("dbo.GetCustomIdentityColumnNameTestList")
.ToList());
}
public List <CustomColumnMappingTest> GetCustomColumnMappingTests()
{
ICraneAccess dataAccess = new SqlServerAccess(ConnectionString);
return(dataAccess
.Query()
.CustomColumnMapping <CustomColumnMappingTest>(x => x.NaturalIdTest, "NaturalId")
.CustomColumnMapping <CustomColumnMappingTest>(x => x.ColumnXIsDifferent, "ColumnX")
.CustomColumnMapping <CustomColumnMappingTest>(x => x.ColumnYIsDifferentInDatabase, "ColumnY")
.ExecuteReader <CustomColumnMappingTest>("dbo.GetCustomColumnMappingTests")
.ToList());
}