Delete Query

sleepwalker222 · **Joined:** Sat Jan 17, 2009 2:02 pm **Posts:** 1

Hi! why doesn't this query work ??
i don"t know what to do.
Help !!!

Code:

public void deleteUserFromGrupa(int groupid, int userid)
{
   ISession session = GetSession();
   session.CreateQuery("DELETE from users_groups c where c.userid='" + userid + "' AND c.groupid='" + groupid + "'");
}

Error : ...must begin with SELECT or FROM...
txh

wolli · **Posted:** Mon Jan 19, 2009 9:04 am

CreateQuery is just for selection ... if you use 2.0, there should be something like ExecuteUpdate and ExceuteDelete. If you still have 1.2, you have to create your own IDbCommand from the session:

IDbCommand cmd = session.Connection.CreateCommand();
...