Entity SQL comparable feature in OA?

2 posts, 0 answers
  1. Diego
    Diego avatar
    8 posts
    Member since:
    May 2012

    Posted 14 Sep 2012 Link to this post

    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?
  2. Viktor Zhivkov
    Viktor Zhivkov avatar
    290 posts

    Posted 19 Sep 2012 Link to this post

    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.

    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!
  3. DevCraft banner
Back to Top