NHibernate Update query

Most of the time Update(object) method is enough 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;
}
}
, , , ,

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Share to Facebook Share to Twitter Stumble It Share on Tumblr Digg More...