NHibernate & Linq - "failed to resolve property"

Question

Mapping file:

<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DaVinci" namespace="DaVinci.Domain"> <class name="Waehrungskurs" table="WAEHRUNGSKURSE"> <id name="Id" column="ID"> <generator class="native" /> </id> <property name="ISOCode" column="ISO" /> <property name="AktuellerKurs" column="AKTKURS" /> <property name="Kursart" column="KIND_OF_KURS" /> <property name="WährungstabkurseId" column="WAEHRUNGSTABKURSE_ID" /> <property name="Departure" column="DEPARTURE" /> <property name="Datum" column="DATE_TIME" /> <property name="RealerKurs" column="REALKURS" /> <property name="Gültig" column="GUELTIG" /> </class> </hibernate-mapping> 

Domain.cs:
...
public virtual double AktuellerKurs {get; set; }
public virtual DateTime Datum {get; set;}
public virtual DateTime Gültig {get; set; }
public virtual int Id {get; set; }
public virtual string ISOCode {get; set; }
public virtual int Kursart {get; set; }
public virtual double RealerKurs {get; set; }
public virtual int WährungstabkurseId {get; set; }
...

I get NHibernate.QueryException ("failed to resolve property: Datum.Date of: DaVinci.Domain.Waehrungskurs") when I call the following function:

  public static Domain.Waehrungskurs GetByISOAndKursartAndDate(string isocode, int kursart, DateTime datum) { return (from WK in session.Linq<DaVinci.Domain.Waehrungskurs>() where WK.ISOCode == isocode && WK.Kursart == kursart && WK.Datum.Date == datum.Date orderby WK.Id descending select WK).First(); } 

When I delete the search condition "WK.Datum.Date == datum.Date", the function works fine.

Any ideas why the property could not be found?

Answer 1

The date property of the date was not found because it is not implemented. Please write a patch for this class.

Answer 2

The property does not exist.

Try replacing: WK.Datum.Date == datum.Date

from

 WK.Datum == datum.Date