Represents a collection of values, each of which is itself represented by an Expression.
Inheritance: Remotion.Linq.Clauses.Expressions.ExtensionExpression
SqlCollectionExpression Class Documentation
Beispiel #1
0
    public void SetUp ()
    {
      var item1 = new SqlLiteralExpression (13);
      var item2 = Expression.Constant (12);
      _items = new Expression[] { item1, item2 };

      _collectionExpression = new SqlCollectionExpression (typeof (List<int>), _items);
    }
Beispiel #2
0
    public void VisitSqlCollectionExpression_Empty ()
     {
       var items = new Expression[0];
       var sqlCollectionExpression = new SqlCollectionExpression (typeof (List<object>), items);

       SqlGeneratingExpressionVisitor.GenerateSql (sqlCollectionExpression, _commandBuilder, _stageMock);

       Assert.That (_commandBuilder.GetCommandText(), Is.EqualTo ("(SELECT NULL WHERE 1 = 0)"));
    }
Beispiel #3
0
    public void VisitSqlCollectionExpression ()
    {
      var items = new Expression[] { Expression.Constant (7), new SqlLiteralExpression ("Hello"), new SqlLiteralExpression (12) };
      var sqlCollectionExpression = new SqlCollectionExpression (typeof (List<object>), items);

      SqlGeneratingExpressionVisitor.GenerateSql (sqlCollectionExpression, _commandBuilder, _stageMock);

      Assert.That (_commandBuilder.GetCommandText(), Is.EqualTo ("(@1, 'Hello', 12)"));
      Assert.That (_commandBuilder.GetCommandParameters(), Is.EqualTo (new[] { new CommandParameter ("@1", 7) }));
    }