Click here to Skip to main content
15,889,034 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I read the another answer here and in the WEB but I can not found a definitive anwser about if it is possible to insert in batch mode with fluent nhibernate and ORACLE. I try this:

C#
private void InsertData(IEnumerable<CopLogNegociosDetail> coplogDetailList) 
    { 
        var session = this.Repository.Session.SessionFactory.OpenStatelessSession(); 
        session = session.SetBatchSize(150); 
        ITransaction tx = session.BeginTransaction(IsolationLevel.Serializable); 
        try 
        { 
            foreach (CopLogNegociosDetail copLogNegociosDetail in coplogDetailList) 
            { 
               session.Insert(copLogNegociosDetail); 
            } 
        } 
        catch (Exception) 
        { 
            tx.Rollback(); 
            throw; 
        } 
 
        tx.Commit(); 
        session.Close(); 
    }


But with the nhibernate profiler I can see that insert operations are individual. That work with Update Operation, but not with insert. I tryed also with normal Session, with SaveAndUpdate. Save and all other method, and also does not work.

Any Idea?

Thanks
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900