Some time ago I blogged about a technique to use SqLite in Unit testing when you have nhibernate mapping that targets Sql Server tables in a schema different from dbo. The problem was: if you specify the schema name in the mapping of a class, then you are not able to execute the test in [...]
Continue reading about Using schema with NHibernate and SqlLite
In a previous post I described a technique to insert query hints into NHibernate query with the use of comments. Testing this code in a real project lead to a strange exception when I issue queries with ICriteria The query should start with ‘SELECT’ or ‘SELECT DISTINCT’ This happens because ICriteria queries inserts comments inside [...]
When you work with Big databases with many records and not uniform distribution of data into columns used for join or where conditions, you can have really bad performance problem due to Query Plan caching. I do not want to give a deep explanation of this problem, you can find information here, but I want [...]
Continue reading about Use Sql Server Query Hints with NHibernate HQL and ICriteria
Entity Framework is quite a good product, but in my opinion still misses some point to be called an ORM. I must admit that I never used the 4.1 Code first in real project, but there are some stuff that still does not convince me when using EF. When I decide to use EF (and [...]
I have a domain where one of the business operation consists of analysis of some entities, for each entity we need to do complex analysis involving external servers and until now we could live with a single server that sequentially analyze those entities one after another. All works good, but we reach a point where [...]
Continue reading about EntityLock, implement a logic locking strategy in my domain
