Can you post the class definition?  When I map enumerations, it's very
simple:

// In the POCO:
public class MyClass
{
    public virtual MyEnumType EnumValue { get; set; }
}

<!-- In the mapping: -->
<property name="EnumValue">
    <column name="ENUM_VALUE" not-null="true" />
</property>

This just works, then I can query using:

Session.Query<MyClass>().Where(c => c.EnumValue ==
MyEnumType.FirstValue);

I hope that's helpful,

On Sep 12, 10:58 am, Val <[email protected]> wrote:
> Could someone please comment on this? Am I doing something wrong here
> or this is a limitation in the NHibernate's Linq provider?
>
> I would really appreciate it!
>
> Thanks
> Val
>
> On Aug 20, 6:25 pm, Val <[email protected]> wrote:
>
>
>
>
>
>
>
> > Hello,
>
> > I have the following query:
>
> >                                     (from i in
> > Session.Query<ImportFactoryData>()
> >                                      where i.ImportType == importType
> > &&
> >                                               i.ObjectSetName ==
> > dataSet
> >                                      select i)
> >                                     .Fetch(i => i.Downloader)
> >                                     .SingleOrDefault();
>
> > where ImportType is an enum mapped to a custom type. However the
> > resulting query is:
>
> > select importfact0_.Id                   as Id4_0_,
> >        httpdownlo1_.Id                   as Id3_1_,
> >        ...
> >        importfact0_.ImportType           as ImportType4_0_,
> >        ...
> >        httpdownlo1_.Uri                  as Uri3_1_,
> >        ...
> > rom   [ImportFactoryData] importfact0_
> >        left outer join [HttpDownload] httpdownlo1_
> >          on importfact0_.Downloader_id = httpdownlo1_.Id
> > where  importfact0_.ImportType = '1'
> >        and importfact0_.ObjectSetName = 'dist_03'
>
> > Note that the enum stores and loads just fine. Only the where clause
> > does not use the custom type. The workaround of course is easy but
> > somewhat annoying:
>
> >                                     (from i in
> > Session.Query<ImportFactoryData>()
> >                                      where i.ImportType.ToString() ==
> > importType.ToString() &&
> >                                            i.ObjectSetName == dataSet
> >                                      select i)
> >                                     .Fetch(i => i.Downloader)
> >                                     .SingleOrDefault();
>
> > Am I missing something? Maybe my custom type is not OK...?
>
> >     public class EnumMapper<T> : IUserType where T : struct
> >     {
> >         public EnumMapper()
> >         {
> >             if (!typeof(T).IsEnum)
> >                 throw new ArgumentException("The generic parameter of
> > 'EnumMapper<>' must be an enum type.");
> >         }
>
> >         public bool IsMutable
> >         {
> >             get { return true; }
> >         }
>
> >         public Type ReturnedType
> >         {
> >             get { return typeof(T); }
> >         }
>
> >         public SqlType[] SqlTypes
> >         {
> >             get { return new SqlType[] { new
> > AnsiStringFixedLengthSqlType(32) }; }
> >         }
>
> >         public object Assemble(object cached, object owner)
> >         {
> >             return DeepCopy(cached);
> >         }
>
> >         public object DeepCopy(object value)
> >         {
> >             if (value!=null)
> >                 return (T)value;
> >             else
> >                 return null;
> >         }
>
> >         public object Disassemble(object value)
> >         {
> >             return DeepCopy(value);
> >         }
>
> >         public new bool Equals(object x, object y)
> >         {
> >             if (x==null)
> >                 return y==null;
> >             if (y==null)
> >                 return false;
>
> >             return object.Equals((T)x, (T)y);
> >         }
>
> >         public int GetHashCode(object x)
> >         {
> >             if (x==null)
> >                 return 0;
>
> >             return x.GetHashCode();
> >         }
>
> >         public object NullSafeGet(IDataReader rs, string[] names,
> > object owner)
> >         {
> >             if (rs == null)
> >                 throw new ArgumentNullException("rs");
> >             if (names == null)
> >                 return null;
> >             if (names.Length < 1)
> >                 return null;
>
> >             int i = rs.GetOrdinal(names[0]);
>
> >             if (rs.IsDBNull(i))
> >                 return null;
>
> >             string s = rs.GetString(i);
>
> >             if (string.IsNullOrWhiteSpace(s))
> >                 return null;
>
> >             return Enum.Parse(typeof(T), s.Trim(), true);
> >         }
>
> >         public void NullSafeSet(System.Data.IDbCommand cmd, object
> > value, int index)
> >         {
> >             if (cmd == null)
> >                 throw new ArgumentNullException("cmd");
>
> >             if (value==null)
> >                 ((IDbDataParameter)cmd.Parameters[index]).Value =
> > DBNull.Value;
> >             else
> >                 ((IDbDataParameter)cmd.Parameters[index]).Value =
> > value.ToString();
> >         }
>
> >         public object Replace(object original, object target, object
> > owner)
> >         {
> >             if (original==null)
> >                 return null;
> >             else
> >                 return (T)original;
> >         }
> >     }

-- 
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.

Reply via email to