tags:

views:

55

answers:

0

For class:

public class A
{
    public virtual IDictionary<B, int> dict { get; protected set; } //int is 1 or -1
}

public class B
{
    public virtual DateTime CreateDate { get; set; }
}

That is mapped as:

<map name="dict" table="TABLE">
  <key column="ID_A" />
  <index-many-to-many column="ID_B" class="B" />
  <element column="FACTOR" type="Int32" />
</map>

I'm trying to do something like this:

db.CreateFilter(x.dict, "DictionaryValue = 1 order by CreateDate"); //Not valid HQL

How do I write this filter in HQL?