~~~
UserTab user = new UserTab();
OQL deleteQ = OQL.From(user)
.Delete()
.Where(cmp => cmp.Comparer(user.UserID, OQLCompare.CompareType.Equal, 2))
.END;
EntityQuery<UserTab>.Instance.ExecuteOql(deleteQ);
~~~
**為了安全,不帶Where條件是不會全部刪除數據的**
上面執行到數據庫的時候等同下面sql語句的執行:
`DELETE FROM [UserTab] WHERE [UserID] = 2`
以上也可以寫成下面的方式:
~~~
UserTab user = new UserTab() { UserID = 2 };
OQL deleteQ1 = OQL.From(user)
.Delete()
.Where(user.UserID) //這里等同于 UserID=@UserID
.END;
EntityQuery<UserTab>.Instance.ExecuteOql(deleteQ1);
~~~