Association truble

[genusP]

If association property used in select clause, query crash.

Query:

var db = new DataConnection();
var res = 
    from o in db.GetTable<Organization>() 
    where o.Id == 1 
    select new Class1<Organization, IEnumerable<Employee>>() { obj = o, Expand = o.EmployesToOrganizations };
var arr = res.ToArray();

Object model.

public class Organization
{
  [PrimaryKey, Identity ] 
  public int    Id  { get; set; } 

  [Column, Nullable] 
  public string Name { get; set; }

  [Association(ThisKey="Id", OtherKey="Organization_Id", CanBeNull=false)]
  public IEnumerable<Employee> EmployesToOrganizations { set; set; }
}

public class Employee
{
  [PrimaryKey, Identity ] 
  public int    Id  { get; set; } 

  [Column]
  public string FIO { get; set; }

  [Column, NotNull]
  public int Organization_Id { get; set; }
}

class Class1<T, TExpand>
    {
        public T obj { get; set; }
        public TExpand Expand { get; set; }
    }

[igor-tkachev]

Multiple queries are not supported yet.

[genusP]

Support are planed ?

[igor-tkachev]

Yes.

[genusP]

Not work in 1.0.1