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.Origination.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]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
