Search code examples
.netnhibernatesql-server-cenhibernate-mapping

Can't set precision and scale on decimal when creating SQL Server CE table with NHibernate

I'm using NHibernate mapping by code to create tables both on server (SQL Server 2008) and client (SQL Server CE 3.5).

This one column

Property(x => x.Latitude, c =>
                       {
                         c.Precision(10); 
                         c.Scale(8); 
                         c.NotNullable(false);
                       });

works excellently on the server where it generates a decimal(10,8).

But on the SQL Server CE client it generates a numeric(19,0)? Am I doing something wrong in the mapping here? I'm using NHibernate 3.3.2.

Solution

  • This issue has now been resolved (NHibernate 3.3.3) Details can be found here: https://nhibernate.jira.com/browse/NH-2979