Hello guys and thanks for this great tool!

My question is regarding the ability of NHibernate to do inserts, updates and deletes through stored procedures.
Reading the documentation for the 1.2 release, I know that it is possible using ?, like <sql-insert>exec myProc ?, ?, ?</sql-insert>.

I understand that the order in which NHibernate gives the parameters is the order of items in the mapping file.

Now:
1. Is it possible to use a syntax like :Name, :Surname etc instead of "?" ?
2. If not, how can I map a parameter flag that isn't in the database table, but I need to pass it to my SP?

Cheers,
Raul

Hi Raul,

1.) Internally the insert/update/delete sql is passed to a command object w/c expects all its passed parameters as "?"
2.) the sql inserts/updates/deletes are meant to be used as a quick CRUD for your entity and also it make use of your existing CRUD sps w/c most probably uses all the fields of your table as parameters.

hth