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_Oracle_Create_001() { var dialect = new SQLinq.OracleDialect(); var expected = "tblPerson"; var target = SQLinq.SQLinq.Create(expected, dialect); Assert.AreEqual(expected, target.TableName); }
public void DynamicSQLinq_Oracle_Test_009() { var dialect = new SQLinq.OracleDialect(); var query = new DynamicSQLinq(dialect, "Car") .Where <string>("Make", d => d != null); var sql = query.ToSQL(); var code = sql.ToQuery(); Assert.AreEqual("SELECT * FROM Car WHERE Make IS NOT NULL", code); }
public void DynamicSQLinq_Oracle_Test_001_B() { var dialect = new SQLinq.OracleDialect(); var query = new DynamicSQLinq(dialect, "Car") .Where("Make = :0", "Ford") .Where("Color = :0 OR Color = :1", 0, 1); 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_Oracle_Test_009() { var dialect = new SQLinq.OracleDialect(); var query = new DynamicSQLinq(dialect, "Car") .Where<string>("Make", d => d != null); var sql = query.ToSQL(); var code = sql.ToQuery(); Assert.AreEqual("SELECT * FROM Car WHERE Make IS NOT NULL", code); }