Query with dependend entites and 1:n relation

hello,

I want to get rows from one table (Document) where on of my "where"-clauses depends on another table.

Table "Document" 1:n "DocumentData" (DocumentData contains row "DocumentId")

Here is my query:

var documentQuery = new Query();
documentQuery.QueryExpression &= (Entity.Attribute("CreationDate") >= filter.FilterDateFrom);
documentQuery.QueryExpression &= (Entity.Attribute("DocumentData.State").In(1,2,3)));

 //get count of all documents
var count = unitOfWork.Count<Database.Document>(documentQuery); 

//get Top 10 rows where GetModelExt is our own Model with additional data
var documents = unitOfWork.Find<Database.Document>(documentQuery.QueryExpression,order, page).Select(document => document.GetModelExt(false)).ToList();

After I execute this query, I get the following error:

"Path component [DocumentData] not found in type [Document]".

When I remove the "DocumentData.State"-expression and add something like

documentQuery.QueryExpression &= (Entity.Attribute("Job.State").In(1,2,3)));

to test another dependency it works (the only difference is the relation between the tables: Document n:1 Job).

Could you help me here?

I prefere Linq-Statements but the columnname could be any of the table so I have to use strings. Is there any way to use string-names for columns in linq-expressions?

thanks Tobi

I found a way to use Linq with dynamic Columnnames. Microsoft has an Class called DynamicLinq (System.linq.dynamic)

If someone needs this too, here is a link: enter link description here

thanks Tobi

Did you still need help with this or have you solved this now by using DynamicLinq?

Jeremy

I could solve my problem with the dynamic linq. Thanks

Please post an example of the solution using DynamicLinq. This would be helpful. Thanks!