public void ShouldFindExpressionsOfParticularTypeUsingPredicate()
{
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(f => f.Column("SomeColumn")).From(f => f.Table("SomeTable"));
var result = expression.Find <DbColumnExpression>(c => c.ColumnName == "SomeColumn");
Assert.IsTrue(result.Count() == 1);
}
public void ShouldReplaceExpressionsOfParticularTypeUsingPredicate()
{
var factory = new DbExpressionFactory();
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(f => f.Column("SomeColumn")).From(f => f.Table("SomeTable"));
expression.Replace <DbTableExpression>(te => true, te => factory.Alias(te, "t0"));
var result = expression.Find <DbAliasExpression>(ae => true);
Assert.IsTrue(result.Count() == 1);
}
public void ShouldReplaceExpressionsOfParticularTypeUsingPredicate()
{
var factory = new DbExpressionFactory();
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(f => f.Column("SomeColumn")).From(f => f.Table("SomeTable"));
expression.Replace<DbTableExpression>(te => true, te => factory.Alias(te, "t0"));
var result = expression.Find<DbAliasExpression>(ae => true);
Assert.IsTrue(result.Count() == 1);
}
public void ShouldFindExpressionsOfParticularTypeUsingPredicate()
{
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(f => f.Column("SomeColumn")).From(f => f.Table("SomeTable"));
var result = expression.Find<DbColumnExpression>(c => c.ColumnName == "SomeColumn");
Assert.IsTrue(result.Count() == 1);
}
public void ShouldTranslateSelectExpressionWithSkipAndTake()
{
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(e => e.Column("SomeColumn"))
.From(e => e.Table("SomeTable")).Skip(2).Take(3);
var result = QueryTranslator.Translate(expression);
Assert.AreEqual(SelectExpressionWithSkipAndTakeSyntax.Clean(), result.Sql.Clean());
}
public void ShouldTranslateSelectExpressionWithOrderBy()
{
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(e => e.Column("SomeColumn"))
.From(e => e.Table("SomeTable")).OrderBy(e => e.Column("SomeColumn"),DbOrderByExpressionType.Ascending);
var result = QueryTranslator.Translate(expression);
Assert.AreEqual(SelectExpressionWithOrderBySyntax.Clean(), result.Sql.Clean());
}
public void ShouldTranslateSelectExpressionWithGroupByHaving()
{
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(e => e.Column("SomeColumn"))
.From(e => e.Table("SomeTable")).GroupBy(e => e.Column("SomeColumn")).Having(
e => e.Column("SomeColumn") > 1);
var result = QueryTranslator.Translate(expression);
Assert.AreEqual(SelectExpressionWithGroupByHavingSyntax.Clean(), result.Sql.Clean());
}