public void Batch_Should_Build_Batched_SQL()
{
BatchQuery qry = new BatchQuery(provider);
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(1));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(2));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(3));
string sql = qry.BuildSqlStatement();
Assert.Equal(3, sql.FindMatches("SELECT").Count);
}
public void Batch_Should_Build_Batched_SQL()
{
BatchQuery qry = new BatchQuery(provider);
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(1));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(2));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(3));
string sql = qry.BuildSqlStatement();
Assert.Equal(3, sql.FindMatches("SELECT").Count);
}
public void Batch_Should_Build_Batched_SQL_Using_Linq()
{
BatchQuery qry = new BatchQuery(provider);
var pquery = new Query <Product>(provider);
qry.Queue(from p in pquery where p.ProductID == 1 select p);
qry.Queue(from p in pquery where p.ProductID == 2 select p);
qry.Queue(from p in pquery where p.ProductID == 3 select p);
string sql = qry.BuildSqlStatement();
Assert.Equal(3, sql.FindMatches("SELECT").Count);
}
public void Batch_Should_Build_Batched_SQL_With_Replaced_SQL_Parameters()
{
BatchQuery qry = new BatchQuery(provider);
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(1));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(2));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(3));
string sql = qry.BuildSqlStatement();
Assert.True(sql.FindMatches("@0").Count == 1);
Assert.True(sql.FindMatches("@1").Count == 1);
Assert.True(sql.FindMatches("@2").Count == 1);
}
public void Batch_Should_Build_Batched_SQL_With_Replaced_SQL_Parameters()
{
BatchQuery qry = new BatchQuery(provider);
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(1));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(2));
qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(3));
string sql = qry.BuildSqlStatement();
Assert.True(sql.FindMatches("@0").Count == 1);
Assert.True(sql.FindMatches("@1").Count == 1);
Assert.True(sql.FindMatches("@2").Count == 1);
}
public void Batch_Should_Build_Batched_SQL_Using_Linq()
{
BatchQuery qry = new BatchQuery(provider);
var pquery = new Query<Product>(provider);
qry.Queue(from p in pquery where p.ProductID == 1 select p);
qry.Queue(from p in pquery where p.ProductID == 2 select p);
qry.Queue(from p in pquery where p.ProductID == 3 select p);
string sql = qry.BuildSqlStatement();
Assert.Equal(3, sql.FindMatches("SELECT").Count);
}