Hello gurus! I've quite recently discovered NHibernate.Linq, written some code and it worked perfectly. There's one thing I want to be able to do, I want to be able to use the IQueryable interface on my properties on my entities. How would you do that? I'm thinking about creating a class implementing IQueryable and ICollection, that takes an ISession and runs queries in that. I want to make the properties more lazy loaded than they are by default in NHibernate. So I can do something like this:
IUser user = this.UserService.GetUserById(1); IEnumerable<IMessage> messages = user.Messages.Where(m => m.IsActive).Skip(offset).Take(10); foreach(IMessage message in messages) Console.WriteLine(message); And that query will only get 10 messages from the database. How would you do this? Thanks in advance, Kim Johansson
