0

I use the specification pattern to dynamically generate LINQ expressions, which will be used

  1. On entities in memory
  2. For SQL code generation by OpenAccess

See this blog post for an example of what I'm trying to achieve.

It all works fine so far, except that I would like to somehow override the SQL that OpenAccess generates for one particular specification (which could turn up anywhere in the generated expression tree). All the rest is fine, which is why I would like to avoid writing my own translator.

EagleBeak
  • 6,939
  • 8
  • 31
  • 47

1 Answers1

1

There is currently no way to directly influence the generation of the SQL per API. However, what you could do is to break the entire expression tree into a server side executed and a client side executed part manually by performing .ToList() between the parts. Alternativly you could see the Telerik Support with the query that you need to achieve and the source LINQ + model.

Tom67
  • 153
  • 4
  • I have asked the identical question in the [Telerik forum](http://www.telerik.com/community/forums/orm/linq-questions/tweaking-the-sql-telerik-openaccess-generates-from-linq-expression.aspx#2259955). Unless I get something better there, I'll accept your answer, @Tom. – EagleBeak Sep 04 '12 at 11:24
  • Breaking up the tree into a server and a client part will probably not be trivial, because the problematic expression might turn at up at any level of the tree and even multiple times. – EagleBeak Sep 04 '12 at 11:25