Beispiel #1
0
        public void Acc_Delete_SimpleSqlCheck()
        {
            SubSonic.SqlQuery q   = new Delete().From(Region.Schema).Where("regiondescription").IsEqualTo("Test");
            string            sql = q.BuildSqlStatement();

            Assert.IsTrue(sql == "DELETE FROM [Region] WHERE [Region].[RegionDescription] = [PARM__RegionDescription0]\r\n");
        }
Beispiel #2
0
 public void Delete_SimpleSqlCheck()
 {
     SubSonic.SqlQuery q = new Delete().From(Region.Schema).Where("regiondescription").IsEqualTo("Test");
     string sql = q.BuildSqlStatement();
     //Assert.Fail("sql = " + sql);
     Assert.IsTrue(sql == "DELETE FROM `main`.`Region` WHERE `main`.`Region`.`RegionDescription` = @RegionDescription0\r\n");
 }
Beispiel #3
0
 public void Acc_Delete_SimpleSqlCheck()
 {
     SubSonic.SqlQuery q = new Delete().From(Region.Schema).Where("regiondescription").IsEqualTo("Test");
     string sql = q.BuildSqlStatement();
     Assert.IsTrue(sql == "DELETE FROM [Region] WHERE [Region].[RegionDescription] = [PARM__RegionDescription0]\r\n");
 }