using nhibernate sessionfactories in multiple threads

Question

I want to uses Isessions from nhibernate over multiple Threads. I read here how to instanciate a factory and it should be threadsafe. I know ISession is not threadsafe, but I am intending of using only one ISession per thread.

Doing this doesnt work:

[Test]
public void TestMultipleThreads(){
  object id;
  using(var session = NHibernateHelper.OpenSession()){
   id = session.Save(new SomeThing("SomeText"));
  };
  Parallel.For(0,2,() =>{
    using (var session =NHibernateHelper.OpenSession()){
       using (var tx=session.BeginTransaction()){
        var something = session.Load<SomeThing>(id);
        Console.WriteLine(something.Text);
      };
    };
  });
}

I cant get that test to running, so that it will print out 2 Names. I am using SQLite and a memory database. What do I miss?

If this is not working, how Should I tell different Threads to use their own session?

EDIT

I get the message from the First Thread and the second throws an exception with Table not Found.

EDIT 2

I think the Prolem lies with the creation of the database. When I create the new Table with a new created session, my other session doesnt know about the other session. But I'll try with an other database.

new SchemaExport(config).Execute(true,true,false,session.Connection,null);

Your code is legimate. It should be related to sqlite. Try with another DB — Onur Gumus
– Onur Gumus, Commented Jul 25, 2014 at 8:32

Low Flying Pelican · Accepted Answer · 2014-07-25 01:14:47Z

1

This is most likely because you are using SQLite in memory database, usually it cease to exist when you close the connection,

in this example, it seems like your database is destroyed when you dispose the first session, along with the data you have persisted.

answered Jul 25, 2014 at 1:14

Low Flying Pelican

6,0621 gold badge36 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

using nhibernate sessionfactories in multiple threads

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related