Hi
Again new to NHibernate and wondering if Could do the following in 1 trip to the db

1 Select from Table A
1 Update Table A etc....
1 Select or insert 0r Delete Table B


What I am asking here is without using Stored Procedures can I do 3 different statement in 01 Trip to the DB?

Thanks a lot.

You can do multiple queries if you use the trunk version at the moment using the multi query functionality Ayende implemented.

As for batching inserts and updates, they normally occur together during a flush.

Symon.

Thanks for your reply.

I knew i could do multiple queries but I was not sure I could do

A Select
Update
and Select again

the above 3 sql statement if you like in 1 db trip.
You say I can .Is that Correct?

Thanks

Not exactly. Modification of the state of persistent objects (Updates, inserts, deletes) are performed when a flush occurs. The timing of a flush depends on your settings, and could happen when you do a query or when you commit your transaction.

Unless you've changed the default flush settings normally if you execute a query any in-memory changes will be automatically flushed to the database to ensure the result set you get is accurate. As a result of this behavior you are effectively getting what you asked for.

Cheers,

Symon.

Ah, missed the 1 DB trip part.

No. You can't have it. Nyaaaa! :) But seriously, I think each of the inserts, updates, etc are executed in their own db roundtrip. Sorry.

Cheers,

Symon.

write a stored procedure and call it via nhibernate.