Dynamic LINQ

Hi Bo Hessner,

dynamic LINQ is supported, but the example given by you must be slightly rewritten:

 var getIt = scope.Extent<Bo>()
.Where("SkuUid == @SkuUid and SalesType == @SalesType", 1234, 5678);

So the entire query cannot be made up by string concatenation, but string pieces must be given along with the parameters in the right order.
You might want to check this link also : Dynamic LINQ .

Kind regards,
Alexander
the Telerik team

Hi Hessner,

There was a little misunderstanding in our last letter to you. The format of the dynamic Linq query should be slightly different:

 var getIt = scope.Extent<Bo>()
.Where("SkuUid == @0 and SalesType == @1", 1234, 5678);

The thing is that named parameters are not supported at the moment with OpenAccess and numbed parameters should be used instead.

Again we are sorry for the inconvenience.


All the best,
Zoran
the Telerik team

Regarding:

 var getIt = scope.Extent<Bo>()
.Where("SkuUid == @SkuUid and SalesType == @SalesType", 1234, 5678);

My real "where part" contain fields from several tables, how is this done?
var getIt = scope.Extent<table1 Join table2 Join table3 >?
.Where("table1.SkuUid == @SkuUid and table2.SalesType == @SalesType", 1234, 5678);

Hello Hessner,

You should just point the references in the where clause like in the sample bellow which is based on the
Northwind database.



All the best,
Zoran
the Telerik team

I got it - this work out fine: