private void CreateEmptyQuery(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var bobas = new UltimateQueryable <Boba>(provider);
Assert.AreEqual(bobas.ToString(), "select * from Boba");
}
private void CreateGetAllTable(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.AsEnumerable();
Assert.AreEqual(paynes.Count(), 4);
}
private void CreateSimpleSelect(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable<MajorPayne>(provider)
.Select(payne => payne.Height)
.AsEnumerable();
Assert.AreEqual(paynes.Count(), 4);
}
private void CreateWhereWithSimplePredicate(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Where(payne => payne.Height > 170)
.AsEnumerable();
Assert.AreEqual(paynes.Count(), 2);
}
private void CreateDummySelect(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Select(payne => payne);
Assert.AreEqual(
paynes.ToString(),
"select * from (select * from MajorPayne) as T ");
}
private void CreateComplexWhereRequest(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Where(payne => payne.Height >= 170 && payne.Song == "AAAA");
Assert.AreEqual(
paynes.ToString(),
"select * from (select * from MajorPayne) as T where ((Height >= 170) and (Song = 'AAAA'))");
}
private void CreateSimpleWhereEqualsQuery(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var bobas = new UltimateQueryable <Boba>(provider)
.Where(boba => boba.Feet == false);
Assert.AreEqual(
bobas.ToString(),
"select * from (select * from Boba) as T where (Feet = 0)");
}
private void CreateWhereWithCapturedVariable(SqlConnection sqlConnection)
{
var provider = new DbQueryProvider(sqlConnection);
var song = "BBBB";
var paynes = new UltimateQueryable <MajorPayne>(provider)
.Where(payne => payne.Song == song);
Assert.AreEqual(
paynes.ToString(),
"select * from (select * from MajorPayne) as T where (Song = 'BBBB')");
}
