Possibilities of making InterLINQ work with Dynamic LINQ?

Apr 23, 2008 at 2:14 PM
Hi,

I've been experimenting with your excellent code - very good!

One thing I would really like to do to increase efficiency and further cut down network traffic is to introduce dynamic SQL into the mix. (i.e., on the client, if the user is only showing columns "Id" and "Name", then I would like to utilise the Dynamic code examples here:

http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx

to produce a query like this:

var customers = context.Customers();
var customerView = customers.Select("New(Id, Name)";

Unfortunately, because the dynamic linq code emits new classes in runtime, the WCF serializer breaks down when trying to send the expression tree to the server for evaluation (it tries to find the dynamically created assembly as a physical dll)

Any thoughts here would be most appreciated!

Thanks,
Mark