Whilst SQL Server is perfectly comfortable doing: where Id like \'45%\' (id being an int), NH will complain as it will still try to send the compare value into sql as a SqlParameter of type int whe
I have a table of positions where a position can have a related position (but not necessarily), and every position has a last modified date. I then want to fetch all positions (of a given type) that w
We have a query we\'re attempting to write for paging, where we want to use Fetch to eager load a collection for an object, then return a paged list of that object.The query below does not work becaus
I know so far that a local variable or a local property can be used as an alias like so ClassA _aliasA;
In NHibernate 3.1, ISession.SaveOrUpdateCopy() has been marked as deprecated. The documentation suggests using Merge() instead. The documentation for each is as follows:
I have a MS SQL db with a table that has a composite id. This is my xml configuration file: <?xml version=\"1.0\" encoding=\"utf-8\" ?>
How would you do this Select * from Personnel p where p.LastName + \', \' + p.FirstName + \' \' + p.MiddleInitial LIKE @Employee + \'%\'
I\'m trying to serialize an nhibe开发者_开发百科rnate entity in to json but I always get this error saying Cannot serialize a Session while connected? Does it has something to do with nhibernate proxy
Does anybody know a way to do compound from clauses - that are possible with Linq to objects - with nHibernate 3 QueryOver syntax. I know its possible with Linq To nHibernate, but I\'m still trying to
I am using FetchMany for some of my queries and the NHibernate profiler gives me the following error: