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