Fabio, I think you are a lucky man. On Sep 22, 1:22 pm, Fabio Maulo <[email protected]> wrote: > In some moment, in my life, I would know which is the advantage to use > strings instead the real underlying type of the enum. > But I know that I have some understanding problems. > > On Wed, Sep 22, 2010 at 4:14 PM, José F. Romaniello > <[email protected]>wrote: > > > > > > > > > > > Yes, the query provider (inside nhibernate) doesn't know how to deal with > > the user type "FluentNHibernate.Mapping.GenericEnumMapper" (from FNH) > > > 2010/9/22 Aaron Fischer <[email protected]> > > > I am getting an error when i use specific enum in a where clause. For > >> some reason nhibernate is setting up the parameter as an int rather > >> then string. > >> The status class: > >> public class StatusDate > >> { > >> public virtual StatusType? MyStatusType {get;set;} > >> public virtual DateTime? Date{get;set;} > >> } > > >> The StatusDate MyStatusType property mapping: > > >> <property name="CalyxStatusType" > > >> type="FluentNHibernate.Mapping.GenericEnumMapper`1[[Calyx.Common.Models.Ori > >> gination.Entities.StatusType, > >> Calyx.Common.Models.Origination, Version=1.0.0.0, Culture=neutral, > >> PublicKeyToken=0ca8877e5830dba7]], FluentNHibernate, > >> Version=1.1.0.692, Culture=neutral, PublicKeyToken=8aa435e3cb308880" > >> lazy="false"> > >> <column name="CalyxStatusType" /> > >> </property> > > >> when i do a LINQ query > > >> var testit = from statDate in _Session.Query<StatusDates>() > >> where statDate.MyStatusType == > >> StatusType.EstimatedClose > >> select statDate; > >> testit.ToList(); > > >> I am receiving this error message: > > >> could not execute query > >> [ select statusdate0_.MyStatusType as col_0_0_ from [StatusDates] > >> statusdate0_ where ((statusdate0_.MyStatusType is null) and (@p0 is > >> not null) or (statusdate0_.MyStatusType is not null) and (@p0 is null) > >> or statusdate0_.MyStatusType<>@p0) and ((statusdate0_.MyStatusType is > >> null) and (@p1 is null) or statusdate0_.mystatusty...@p1) ] > >> Name:p1 - Value:null Name:p2 - Value:12 > >> [SQL: select statusdate0_.MyStatusType as col_0_0_ from [StatusDates] > >> statusdate0_ where ((statusdate0_.MyStatusType is null) and (@p0 is > >> not null) or (statusdate0_.MyStatusType is not null) and (@p0 is null) > >> or statusdate0_.MyStatusType<>@p0) and ((statusdate0_.MyStatusType is > >> null) and (@p1 is null) or statusdate0_.mystatusty...@p1)] > > >> NHibernate.Exceptions.GenericADOException > > >> Any thoughts as to what could be causing this? > > >> -- > >> You received this message because you are subscribed to the Google Groups > >> "nhusers" group. > >> To post to this group, send email to [email protected]. > >> To unsubscribe from this group, send email to > >> [email protected]<nhusers%[email protected] > >> > > >> . > >> For more options, visit this group at > >>http://groups.google.com/group/nhusers?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<nhusers%[email protected] > > > > > . > > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
