public void TestDeleteSentenceBuilder1()
{
var dsb = new DeleteStatementBuilder("UserTable");
const string s = "DELETE FROM [UserTable];";
TesterHelper.AssertSqlSentenceEqual(dsb.ToSqlStatement(dd, null).SqlCommandText, s);
}
public void TestDeleteSentenceBuilder2()
{
var dsb = new DeleteStatementBuilder("UserTable");
dsb.Where.Conditions = new OrClause("ID", 3, 1);
const string Exp = "DELETE FROM [UserTable] WHERE ([ID] = @ID_0) OR ([ID] = @ID_1);\n<Text><30>(@ID_0=3:Int32,@ID_1=1:Int32)";
TesterHelper.AssertSqlSentenceEqual(Exp, dsb.ToSqlStatement(dd, null).ToString());
}
public void TestSelectSentenceBuilder2()
{
var ssb = new SelectStatementBuilder("UserTable", null, new Range(1, 10));
ssb.Keys.Add(new KeyValuePair <string, string>("a", null));
ssb.Where.Conditions = new OrClause("ID", 5, 3, 2);
const string s = "SELECT TOP 10 [a] FROM [UserTable] WHERE ([ID] = @ID_0) OR ([ID] = @ID_1) OR ([ID] = @ID_2);\n<Text><60>(@ID_0=5:Int32,@ID_1=3:Int32,@ID_2=2:Int32)";
TesterHelper.AssertSqlSentenceEqual(s, ssb.ToSqlStatement(dd, null).ToString());
}
public void TestSelectSentenceBuilder3()
{
var ssb = new SelectStatementBuilder("UserTable", null, new Range(1, 10));
ssb.Keys.Add(new KeyValuePair <string, string>("a", null));
ssb.Where.Conditions = new OrClause("ID", 5, 3, 2);
ssb.Where.Conditions = new AndClause(ssb.Where.Conditions, new KeyValueClause("UserName", "l'lf", CompareOpration.Equal, ColumnFunction.None));
const string s = "SELECT TOP 10 [a] FROM [UserTable] WHERE (([ID] = @ID_0) OR ([ID] = @ID_1) OR ([ID] = @ID_2)) AND ([UserName] = @UserName_3);\n<Text><60>(@ID_0=5:Int32,@ID_1=3:Int32,@ID_2=2:Int32,@UserName_3=l'lf:String)";
TesterHelper.AssertSqlSentenceEqual(s, ssb.ToSqlStatement(dd, null).ToString());
}