nhibernate

Nhibernate Component Mapping : Parent Object null in Value Object while querying from database

Hello, I am mapping my value Object Item as component withthe folowing mapping configuration { Table("Product"); Not.LazyLoad(); Id(x => x.Id, "id"); Map(x => x.Number, "number"); Map(x => x.Name, "name"); Map(x => x.Description, "description"); Map(x =...

Use Mvc 2 with ninject 2 and NHibernate - Get SessionFactory

Hey I'm trying to combine Mvc2 with Ninject and NHibernate, and found a guide here: http://damianm.com/tech/nhibernate-mvc-and-ninject/ The problem is that he use Ninject 1. So i have to convert it, and I'm almost succesfull, but i still got one problem: Im not sure how to convert the "context.Kernel.Get" here: protected override ISe...

NHibernate: LeftOuterJoin without association

Hi, I have the following structure. Message (Text) MessageReading (Message, User) I'd like to load messages with corresponding MessageReading if it exists. I can achieve that with HQL: var query = session.CreateSQLQuery( @"SELECT {msg.*}, {mr.*} FROM Message msg LEFT OUTER JOIN MessageReading mr ON (mr.Message_Id = msg.Id...

Track changes to SQL query in real time

Hello! Here is my situation: 1) User A must monitor the results of an sql query Q. 2) User B can modify data that may change the results of Q 3) running Q on the entire database is slow What I would like have is: whenever user B modifies the data: with a create, update or delete, then generate the delta to the results of Q. i.e. retur...