NHibernate Linq queries not returning data saved in the same transaction

Posted by Andrew on Stack Overflow See other posts from Stack Overflow or by Andrew
Published on 2010-05-11T05:24:20Z Indexed on 2010/05/11 7:24 UTC
Read the original article Hit count: 298

Filed under:

nhibernate

|

transaction

|

wcf

|

LINQ

Hi,

I have a situation where I am using NHibernate in a WCF service and using a TransactionScope for the transaction management. NHibernate enlists in the ambient transaction fine, but, any changes I make and save inside the transaction, are not visible to any queries I make while still in that transaction. So if I add an entity and session.save() it, then further on in the code, there is a linq query against that entities table, the entity I just added is not returned.

Strangely this seems to work fine if I use explicit NHibernate transactions in my tests.

Anyone have any ideas as to why and what I can do about it?

Many thanks

Andrew

© Stack Overflow or respective owner

Related posts about nhibernate

How can I eager-load a child collection mapped to a non-primary key in NHibernate 2.1.2?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have two objects with a many-to-many relationship between them, as follows: public class LeftHandSide { public LeftHandSide() { Name = String.Empty; Rights = new HashSet<RightHandSide>(); } public int Id { get; set; } public string Name { get; set;… >>> More
Nhibernate 2.1 and mysql 5 - InvalidCastException on Setup

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello there, I am trying to use NHibernate with Spring.Net und mySQL 5. However, when setting up the connection and creating the SessionFactoryObject, I get this InvalidCastException: NHibernate seems to cast MySql.Data.MySqlClient.MySqlConnection to System.Data.Common.DbConnection which causes… >>> More
Nhibernate transactions:Avoiding Nhibernate dependency in the service layer

as seen on Stack Overflow - Search for 'Stack Overflow'
One of practices advocated by Nhibernate experts is to do all actions in inside a transaction. In a typical 3 tier web architecture, Nhibernate depedency is limited the data layer. In such a case is it fine to use using (var tr = NHibernateSession.Current.BeginTransaction()) { at the controller… >>> More
Series of abstract classes and NHibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, and first off thanks for your time to look at this. For a research project I'm working on, I have a somewhat complex design (which I've been given) to persist to a database via NHibernate. Here's an example of the class hierarchy: TransitStrategy, TransportationCompany and TransportationLocation… >>> More
Using Time columns with NHibernate, Fluent NHibernate and SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a table with a time column in my SQL Server 2008 database. The property of the object I'm trying to map to is a TimeSpan. How can i tell FluentNHibernate to use the TimeAsTimeSpan NHibernate type, so that I don't have cast problems? >>> More

Related posts about transaction

Protecting against transaction concurency (Transaction type; Transaction IsolationLevel)

as seen on Stack Overflow - Search for 'Stack Overflow'
Middle-tier component will execute the data access routines in application. The component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction. The code for the middle-tier will implement the following… >>> More
Commit in SQL

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SQL Transaction Control Language Commands (TCL) (COMMIT) Commit… >>> More
Understanding EDI 997.

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Hi Guys, This is for the EDI starter. Below is the complete detail of EDI 997 segment and element details. 997 Functional Acknowledgment Transaction Layout: No. Seg ID … >>> More
Understanding EDI 997

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Hi Guys, This is for the EDI starter. Below is the complete detail of EDI 997 segment and element details. 997 Functional Acknowledgment Transaction Layout: No. Seg ID … >>> More
How to nest transactions nicely - "begin transaction" vs "save transaction" and SQL Server

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Do you write stored procedures that might be used by others? And those others may or may not have already started a transaction? And your SP does several things, but if any of them fail, you have to undo them all and return with a code indicating it failed? Well, I have written such code, and it… >>> More