This question is locked. New answers and comments are not allowed.
I'm wondering if there's something like ESQL in OA ? I used ESQL heavily in a project a while ago where I needed to use several jqGrids and dynamically pass in sorting and filtering expressions to the business layer that got passed up all the way to the DAL (EF) to execute against the db.
If so, how does OA's implementation compare to the functionality supported/not supported by EF through ESQL?
If so, how does OA's implementation compare to the functionality supported/not supported by EF through ESQL?
1 Answer, 1 is accepted
0
Hello Diego,
We are not supporting ESQL in OpenAccess. Due to historical reasons we have OQL support, but I would not suggest to implement any new features/products using it since it is considered deprecated feature.
One thing that is a bit close could be the Dynamic Linq statements (you can find more on Scott Gu's blog here). They are LINQ statements expressed as strings and they are later converted into expression trees and database server dependant SQL statements by our runtime.
Unfortunately transition from ESQL to either DynamicLinq or OQL will require significant rewrite of the existing statements.
If you are using ESQL for paging and sorting solely, I believe the best solution is to use either normal LINQ (if your UI components permit it) or DynamicLinq string-based methods.
If you need any additional assistance please post snippets of the code that you would like to change.
Greetings,
Viktor Zhivkov
the Telerik team
We are not supporting ESQL in OpenAccess. Due to historical reasons we have OQL support, but I would not suggest to implement any new features/products using it since it is considered deprecated feature.
One thing that is a bit close could be the Dynamic Linq statements (you can find more on Scott Gu's blog here). They are LINQ statements expressed as strings and they are later converted into expression trees and database server dependant SQL statements by our runtime.
Unfortunately transition from ESQL to either DynamicLinq or OQL will require significant rewrite of the existing statements.
If you are using ESQL for paging and sorting solely, I believe the best solution is to use either normal LINQ (if your UI components permit it) or DynamicLinq string-based methods.
If you need any additional assistance please post snippets of the code that you would like to change.
Greetings,
Viktor Zhivkov
the Telerik team
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!