Creating Query on the fly - EF Linq

57 views Asked by At

I'm trying to convert a functional hard code query to a dinamic query. With my knowledge this is a impossible task.

Can anybody help me? This is the hard code query. This works fine:

Dim ret0 = qry.AsQueryable.Select(Function(f) New With { f.id, f.bint1, f.scampo1}) 

Where qry is a "return content table" comes from another query.

I've try:

Dim ret99 = qry.AsQueryable().Select(Function(f) ("new (key.id, key.bint1, key.scampo1)"))

and other variations but not is working.

If I do something like that:

Dim ret1 = qry.AsQueryable().Select("scampo1")

this works fine. But if I try more than one column only the very first one is returned.

Hope somebody could help me on that.

0

There are 0 answers