Home NHibernate NHibernate Update query

Tips and tricks

Site statistics

Members : 19
Content : 104
Content View Hits : 18548

Who's Online

We have 12 guests online
NHibernate Update query PDF Print E-mail
User Rating: / 0
PoorBest 
Articles - NHibernate
Written by Agile   
Friday, 11 September 2009 14:41

 

Most of the time Update(object) method is enought to update record using NHibernate. Instead you can  use update query to update records, sometimes you might have special cases to write your own update query to update records on the database.  Here is the simple sample how to write update query with NHibernate.

 

using(ISession session = SessionFactory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    var query =
                        session.CreateQuery(
                            "Update User set FirstName =:firstName,LastName=:lastName,UserName=:userName where UserId=:userId");
                    query.SetParameter("firstName", user.FirstName);
                    query.SetParameter("lastName", user.LastName);
                    query.SetParameter("userName", user.UserName);
                    query.SetParameter("userId", user.UserId);
                    int res= query.ExecuteUpdate();
                    transaction.Commit();
                    return res;
                }
            }

Last Updated on Friday, 11 September 2009 14:51