I subclassed the MsSql2005Dialect, and just added a

RegisterColumnType(DbType.Double, "FLOAT(53)");

in the constructor, that seemed to do the trick in my scenario.
Thanks for the hint, Fabio, even if cryptic! :)


On 6 Maj, 14:14, Fabio Maulo <fabioma...@gmail.com> wrote:
>  RegisterColumnType(DbType.Currency, "MONEY");
> RegisterColumnType(DbType.Decimal, "DECIMAL(19,5)");
> RegisterColumnType(DbType.Decimal, 19, "DECIMAL($p, $s)");
> RegisterColumnType(DbType.Double, "DOUBLE PRECISION"); //synonym for
> FLOAT(53)
> RegisterColumnType(DbType.Int16, "SMALLINT");
> RegisterColumnType(DbType.Int32, "INT");
> RegisterColumnType(DbType.Int64, "BIGINT");
> RegisterColumnType(DbType.Single, "REAL"); //synonym for FLOAT(24)
>
>
>
>
>
>
>
>
>
> On Fri, May 6, 2011 at 5:50 AM, Neo <ted.parnef...@gmail.com> wrote:
> > I have an entity with a double property, in the database this column
> > is a float.
> > During SchemaValidation I get an exception stating that it expected
> > "double precision".
> > If I, using ConfORM, set the property type to be "Single" it instead
> > expects a "real".
>
> > I've tried the following different ones:
> > mapper.Class<Balloon>(cm => {
> >    cm.Property(o => o.Size, pm =>
> > pm.Type(NHibernate.NHibernateUtil.Single));
> > });
> > mapper.Class<Balloon>(cm => {
> >    cm.Property(o => o.Size, pm =>
> > pm.Type(NHibernate.NHibernateUtil.Double));
> > });
> > & also
> > mapper.Class<Balloon>(cm => {
> >    cm.Property(o => o.Size, pm => pm.Type(GuessType(typeof(float))));
> > });
>
> > public class Balloon : Entity {
> >     public double Size { get; set; }
> > }
>
> > or what could I change the column to, since there is no "double
> > precision" available in sql-server, or from what I can understand the
> > "float" data type in sql server is exactly that.?
>
> > Cheers!
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "nhusers" group.
> > To post to this group, send email to nhusers@googlegroups.com.
> > To unsubscribe from this group, send email to
> > nhusers+unsubscr...@googlegroups.com.
> > For more options, visit this group at
> >http://groups.google.com/group/nhusers?hl=en.
>
> --
> Fabio Maulo

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to nhusers@googlegroups.com.
To unsubscribe from this group, send email to 
nhusers+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to