Flexible HQL execution method

Pierre · **Posted:** Tue Nov 29, 2005 8:03 am

Hi all,

I'm trying to code a method that could execute any (or almost) HQL query, but I'm not really advanced in C#. :(

that would give something like that:

Code:

      public void Delete(string query, object[] parameters, object[] values)
      {
         ITransaction tx = null;
         try
         {

            //query = "from table name where columnName1 = :columnValue1 , columnName2 = :columnValue2 , ..."


            //here loop through the array and produce a string formated as follow:
            //stringparameternames = "parameter1 " + "," + "parameter2 " + "," ...

            //same here for their values:
            //stringparametervalues = "value1 " + "," + "value2 " + "," ...


            tx = _session.BeginTransaction();
            _session.Delete(query, stringparameternames, stringparametervalues);
            tx.Commit();
         }
         catch (Exception ex)
         {
            if (tx!=null) tx.Rollback();
            throw;
         }         
      }

Would that work and would that be "safe"?

Other then that, is it possible to safely make that even more flexible?

Thx a lot for your attention, advices and help.

Pierre

Pierre · **Posted:** Tue Nov 29, 2005 8:12 am

If somebody could tell me what does _session.Delete (or _session.*) returns I could use that info as well :)

KPixel · **Posted:** Tue Nov 29, 2005 10:44 am

You are basically wrapping ISession.Delete(), so I don't see anything wrong here (Don't concatenate the parameters!!!)

You can find all the information about the API in NHibernate API Reference (or better: in the source code :wink: )

Pierre · **Posted:** Wed Nov 30, 2005 9:40 am

thx KPixel.

I'm still wondering how to write a HQL query with several parameters. For example in the following example how do I add the firstname?

Code:

_session.Delete("from TblEmployee where employee_lName = :Id", lname, NHibernate.NHibernateUtil.String);

KPixel · **Posted:** Thu Dec 01, 2005 9:26 am

Here, you should write:

Code:

_session.Delete("from TblEmployee where employee_lName = ?", lname, NHibernate.NHibernateUtil.String);

As you aren't using named parameters.