CreateSqlStatement() public static méthode

public static CreateSqlStatement ( ) : SqlStatement
Résultat Remotion.Linq.SqlBackend.SqlStatementModel.SqlStatement
SqlStatementModelObjectMother Class Documentation
Exemple #1
0
        public void Equals_ObjectIsNull()
        {
            var dataInfo         = new TestStreamedValueInfo(typeof(int));
            var selectProjection = Expression.Constant(1);
            var sqlStatement     = SqlStatementModelObjectMother.CreateSqlStatement();

            Assert.That(sqlStatement.Equals(null), Is.False);
        }
Exemple #2
0
        public void CreateExpression_WithSqlTables()
        {
            var sqlStatementBuilder = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatement());
            var sqlStatement        = sqlStatementBuilder.GetSqlStatement();

            var result = sqlStatement.CreateExpression();

            Assert.That(result, Is.TypeOf(typeof(SqlSubStatementExpression)));
            Assert.That(((SqlSubStatementExpression)result).SqlStatement, Is.SameAs(sqlStatement));
        }
Exemple #3
0
        public void CreateExpression_WithNoSqlTablesAndNoDistinctQueryAndNoAggregationModifier()
        {
            var sqlStatementBuilder = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatement());

            sqlStatementBuilder.SqlTables.Clear();
            var sqlStatement = sqlStatementBuilder.GetSqlStatement();

            var result = sqlStatement.CreateExpression();

            Assert.That(result, Is.SameAs(sqlStatement.SelectProjection));
        }
Exemple #4
0
        public void CreateExpression_IsDistinctQuery()
        {
            var sqlStatementBuilder = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatement());

            sqlStatementBuilder.SqlTables.Clear();
            sqlStatementBuilder.IsDistinctQuery = true;
            var sqlStatement = sqlStatementBuilder.GetSqlStatement();

            var result = sqlStatement.CreateExpression();

            Assert.That(result, Is.TypeOf(typeof(SqlSubStatementExpression)));
            Assert.That(((SqlSubStatementExpression)result).SqlStatement, Is.SameAs(sqlStatement));
        }
Exemple #5
0
        public void CreateExpression_HasAggregationModifier()
        {
            var sqlStatementBuilder = new SqlStatementBuilder(SqlStatementModelObjectMother.CreateSqlStatement());

            sqlStatementBuilder.SqlTables.Clear();
            var selectProjection = new AggregationExpression(typeof(double), sqlStatementBuilder.SelectProjection, AggregationModifier.Max);

            sqlStatementBuilder.SelectProjection = selectProjection;
            var sqlStatement = sqlStatementBuilder.GetSqlStatement();

            var result = sqlStatement.CreateExpression();

            Assert.That(result, Is.SameAs(selectProjection));
        }
Exemple #6
0
        public void Equals_ObjectIsNotASqlStatement()
        {
            var sqlStatement = SqlStatementModelObjectMother.CreateSqlStatement();

            Assert.That(sqlStatement.Equals(new object()), Is.False);
        }
Exemple #7
0
 public void SetUp()
 {
     _sqlStatement = SqlStatementModelObjectMother.CreateSqlStatement();
     _expression   = new SqlSubStatementExpression(_sqlStatement);
 }