public void DynamicSQLinq_Oracle_Test_004_B()
{
var dialect = new SQLinq.OracleDialect();
var where = new DynamicSQLinqExpressionCollection(dialect, DynamicSQLinqWhereOperator.Or);
where.Add("Make = @0", "Ford")
.Add("Color = @0 OR Color = @1", 0, 1);
var where2 = new DynamicSQLinqExpressionCollection(dialect);
where2.Add("Make = @0", "Chevrolet");
where.Add(where2);
var query = new DynamicSQLinq("Car")
.Where(where);
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT * FROM Car WHERE (Make = :sqlinq_1) OR (Color = :sqlinq_2 OR Color = :sqlinq_3) OR (Make = :sqlinq_4)", code);
Assert.AreEqual("Ford", sql.Parameters[":sqlinq_1"]);
Assert.AreEqual(0, sql.Parameters[":sqlinq_2"]);
Assert.AreEqual(1, sql.Parameters[":sqlinq_3"]);
Assert.AreEqual("Chevrolet", sql.Parameters[":sqlinq_4"]);
}
public void DynamicSQLinq_Test_006()
{
var where = new DynamicSQLinqExpressionCollection(DynamicSQLinqWhereOperator.Or);
where.Add("(Make = @0) OR (Make <> @0 AND Color = @1)", "Ford", 15)
.Add("Color = @0 OR Color = @1", 0, 1);
var where2 = new DynamicSQLinqExpressionCollection();
where2.Add("Make = @0", "Chevrolet");
where.Add(where2);
var query = new DynamicSQLinq("Car")
.Where(where);
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT * FROM Car WHERE ((Make = @sqlinq_1) OR (Make <> @sqlinq_1 AND Color = @sqlinq_2)) OR (Color = @sqlinq_3 OR Color = @sqlinq_4) OR (Make = @sqlinq_5)", code);
Assert.AreEqual("Ford", sql.Parameters["@sqlinq_1"]);
Assert.AreEqual(15, sql.Parameters["@sqlinq_2"]);
Assert.AreEqual(0, sql.Parameters["@sqlinq_3"]);
Assert.AreEqual(1, sql.Parameters["@sqlinq_4"]);
Assert.AreEqual("Chevrolet", sql.Parameters["@sqlinq_5"]);
}
public void DynamicSQLinq_Test_Count_004()
{
var where = new DynamicSQLinqExpressionCollection(DynamicSQLinqWhereOperator.Or);
where.Add("Make = @0", "Ford")
.Add("Color = @0 OR Color = @1", 0, 1);
var where2 = new DynamicSQLinqExpressionCollection();
where2.Add("Make = @0", "Chevrolet");
where.Add(where2);
var query = new DynamicSQLinq("Car")
.Where(where)
.Count();
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT COUNT(1) FROM Car WHERE (Make = @sqlinq_1) OR (Color = @sqlinq_2 OR Color = @sqlinq_3) OR (Make = @sqlinq_4)", code);
Assert.AreEqual("Ford", sql.Parameters["@sqlinq_1"]);
Assert.AreEqual(0, sql.Parameters["@sqlinq_2"]);
Assert.AreEqual(1, sql.Parameters["@sqlinq_3"]);
Assert.AreEqual("Chevrolet", sql.Parameters["@sqlinq_4"]);
}
public void DynamicSQLinq_Test_002()
{
var where = new DynamicSQLinqExpressionCollection();
where.Add("Make = @0", "Ford")
.Add("Color = @0 OR Color = @1", 0, 1);
var query = new DynamicSQLinq("Car")
.Where(where);
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT * FROM Car WHERE (Make = @sqlinq_1) AND (Color = @sqlinq_2 OR Color = @sqlinq_3)", code);
Assert.AreEqual("Ford", sql.Parameters["@sqlinq_1"]);
Assert.AreEqual(0, sql.Parameters["@sqlinq_2"]);
Assert.AreEqual(1, sql.Parameters["@sqlinq_3"]);
}
public void DynamicSQLinq_Test_002()
{
var where = new DynamicSQLinqExpressionCollection();
where.Add("Make = @0", "Ford")
.Add("Color = @0 OR Color = @1", 0, 1);
var query = new DynamicSQLinq("Car")
.Where(where);
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT * FROM Car WHERE (Make = @sqlinq_1) AND (Color = @sqlinq_2 OR Color = @sqlinq_3)", code);
Assert.AreEqual("Ford", sql.Parameters["@sqlinq_1"]);
Assert.AreEqual(0, sql.Parameters["@sqlinq_2"]);
Assert.AreEqual(1, sql.Parameters["@sqlinq_3"]);
}
public void DynamicSQLinq_Test_006()
{
var where = new DynamicSQLinqExpressionCollection(DynamicSQLinqWhereOperator.Or);
where.Add("(Make = @0) OR (Make <> @0 AND Color = @1)", "Ford", 15)
.Add("Color = @0 OR Color = @1", 0, 1);
var where2 = new DynamicSQLinqExpressionCollection();
where2.Add("Make = @0", "Chevrolet");
where.Add(where2);
var query = new DynamicSQLinq("Car")
.Where(where);
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT * FROM Car WHERE ((Make = @sqlinq_1) OR (Make <> @sqlinq_1 AND Color = @sqlinq_2)) OR (Color = @sqlinq_3 OR Color = @sqlinq_4) OR (Make = @sqlinq_5)", code);
Assert.AreEqual("Ford", sql.Parameters["@sqlinq_1"]);
Assert.AreEqual(15, sql.Parameters["@sqlinq_2"]);
Assert.AreEqual(0, sql.Parameters["@sqlinq_3"]);
Assert.AreEqual(1, sql.Parameters["@sqlinq_4"]);
Assert.AreEqual("Chevrolet", sql.Parameters["@sqlinq_5"]);
}
public void DynamicSQLinq_Oracle_Test_004_B()
{
var dialect = new SQLinq.OracleDialect();
var where = new DynamicSQLinqExpressionCollection(dialect, DynamicSQLinqWhereOperator.Or);
where.Add("Make = @0", "Ford")
.Add("Color = @0 OR Color = @1", 0, 1);
var where2 = new DynamicSQLinqExpressionCollection(dialect);
where2.Add("Make = @0", "Chevrolet");
where.Add(where2);
var query = new DynamicSQLinq("Car")
.Where(where);
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT * FROM Car WHERE (Make = :sqlinq_1) OR (Color = :sqlinq_2 OR Color = :sqlinq_3) OR (Make = :sqlinq_4)", code);
Assert.AreEqual("Ford", sql.Parameters[":sqlinq_1"]);
Assert.AreEqual(0, sql.Parameters[":sqlinq_2"]);
Assert.AreEqual(1, sql.Parameters[":sqlinq_3"]);
Assert.AreEqual("Chevrolet", sql.Parameters[":sqlinq_4"]);
}
public void DynamicSQLinq_Test_Count_004()
{
var where = new DynamicSQLinqExpressionCollection(DynamicSQLinqWhereOperator.Or);
where.Add("Make = @0", "Ford")
.Add("Color = @0 OR Color = @1", 0, 1);
var where2 = new DynamicSQLinqExpressionCollection();
where2.Add("Make = @0", "Chevrolet");
where.Add(where2);
var query = new DynamicSQLinq("Car")
.Where(where)
.Count();
var sql = query.ToSQL();
var code = sql.ToQuery();
Assert.AreEqual("SELECT COUNT(1) FROM Car WHERE (Make = @sqlinq_1) OR (Color = @sqlinq_2 OR Color = @sqlinq_3) OR (Make = @sqlinq_4)", code);
Assert.AreEqual("Ford", sql.Parameters["@sqlinq_1"]);
Assert.AreEqual(0, sql.Parameters["@sqlinq_2"]);
Assert.AreEqual(1, sql.Parameters["@sqlinq_3"]);
Assert.AreEqual("Chevrolet", sql.Parameters["@sqlinq_4"]);
}
