sql - CreateSQLQuery() not executing -
i attempting delete specific row w/
session.createsqlquery("delete [dbo].[usertable] id = '00000000-0000-0000-0000-000000000000' ").executeupdate();
but not seem execute command, ideas?
you need use transaction , commit after executeupdate
. see nhibernate reference docs or this ayende post example usage.
if still no luck after that, try profiler see sql, if any, nhibernate executing.
note: it's recommended use transaction w/ nhibernate, if you're reading data.
Comments
Post a Comment