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()); }