Lab Sql

I have registered an SQL function in my dialect subclass RegisterFunction('addseconds', new… Read more Can Nhibernate's Queryover Syntax Select Max() Of An Sqlfunction?

In my C# .NET 3.5 application I am using CastleProject ActiveRecord over NHibernate. This is deskto… Read more Timeout Exception When Timeout Set To Infinite Time

Background We are in the process of upgrading a legacy import tool, what it does is it moves data f… Read more Is A Orm The Right Tool To Use For Migrating Data?

Is there a way in NHibernate / QueryOver API to pass a parameter already in the mapping (so it uses… Read more Nhibernate / Queryover: How To Left Join With Parameter

Lets say you are working in SQL 2005 with a copy of Northwind database installed. Your working on a… Read more How To Do A Select Distinct Equivalent For A Page Filter In Nhibernate?

I'm trying to map an Entity with a string property to a varchar column in NHibernate 3 using th… Read more Nhibernate 3 Specify Sql Data Type With Loquacious Syntax

I have the following LINQ query which uses NHibernate against a SQL Server backed repository... var… Read more Nhibernate Linq Group By Fails To Group Properly In Sql Server

We have a situation where we are trying to retrieve a couple of levels deep for an object graph usi… Read more Nhibernate Queryover - Is There Any Way Of Getting Better Sql Out Of Nhibernate When Retrieving This Object Plus Collections Graph?

After converting to Visual Studio 2010 with ReSharper5 some of my unit tests started failing. More … Read more Problem With Sqlite Related Nunit-tests After Upgrade To Vs2010 And Re#5

I have a tests project that I am trying to test my nhibernate layer with using sql lite in-memory d… Read more Could Not Create The Driver From Nhibernate.driver.sqlite20driver, Nhibernate, Version=3.1.0.4000

I have upgraded from Fluent Nhibernate 1.0 with Nhibernate 2.1 to pre- release 1.x with NHibernate … Read more Binary Blob Truncated To 8000 Bytes - Sql Server 2008 / Varbinary(max)

I need to select first (let's say) 10000 rows in database and return them. There may be more cl… Read more Is Update With Nested Select Atomic Operation?

I have a NHibernate criteria, from which I need to get the SQL query. I tried the various methods f… Read more Get Sql Query From Nhibernate Criteria, Before The Criteria Executes

I want to have a intermediate table with only two foreign keys (as a ComposedId). But NHibernate is… Read more Nhibernate Composedid On Intermediate Table

I tried to use NHibernate with SQLite, version=1.0.74.0 for .NET 4 and 32 bit. I use a 64bit WIN7, … Read more System.data.sqlite Badimageformatexception With Nhibernate, Works Finewhen Standalone

What I want to do is convert my whole application to nhibernate from ADO.NET and test it using diff… Read more If I Use Nhibernate Can I Switch Between Databases And Not Change The Nhibernate Code?

I know you can view the NHibernate generated SQL by hooking it up to log4net or piping it out to th… Read more How To Obtain Nhibernate Generated Sql In Code At Runtime?

I have database table contains around 3 millions records. When I delete large number of rows, aroun… Read more Delete Large Number Of Rows Is Very Slow - Sql Server

Is there a way of ordering a list of objects by a count of a property which is a collection? For a… Read more Ordering By Collection Count In Nhibernate

I want to query like this: select * from table where concat(',', ServiceCodes, ',')… Read more Invoke Sql Function Using Nhibernate?