Generating SQL for Insert

Bernardoh · **Joined:** Thu Jan 12, 2006 8:17 am **Posts:** 8

Hi all,

I need some help on generating the INSERT INTO query for a given instance.

Something like:

IList<MyNhObject> objects = GetAllOfThem();
foreach(MyNhObject obj in objects){
string sql = GetInsertSqlString(obj);
}

I need that to create a bulk inserter to Oracle.

Thanks for any help,
Bernardo Heynemann
Stormwind Project Committer
http://www.stormwindproject.org

jagid · **Joined:** Fri Jan 12, 2007 1:08 am **Posts:** 41

It is my understanding that bulk inserts are best handled outside of NHibernate (although I believe that there are some features in 2.0 that will start to close the gap). Therefore I am not sure if the obtaining the insert SQL that NHibernate will generate will help you.

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

Look into the reference, section 13.4, especially the first bullet under "Some points to note".