While working on one of the project for fine tuning the NHibernate queries and functional flow I got to know about the error "could not execute native bulk manipulation query:"
To avoid this error one has to remember the following things:
To avoid this error one has to remember the following things:
- While executing tasks which requires bulk manipulation of data like update, delete, it is suggested to use the HQL instead of SQL.
- While using HQL be cautious to use the createQuery of NHibernate session.
- Do not forget to use the ExecuteUpdate();
