This question is locked. New answers and comments are not allowed.
Hello,
I'm currently use LLBL Gen pro as my ORM. I was poised to make the transition to Linq to Sql but found a serious flaw in the design/performance that has caused me to rule it out at this time.
Having a telerik subscription I am curious in evaluating this product but I need to know up front if Open Access supports the ability to prefetch as many tables as needed with any limitations.
An example of what I'm talking about. Let's take the Northwind database. Say I want to create a middle tier endpoint called GetEmployeeCustomers.
My entity in my Middle tier will contain data from the Employee, Customer, Order and Order Details database. I want all this info back at the same time.
With Linq to Sql you can only prefetch 2 tables at at time so this query would resort to lazy loading after prefetching employee and customer tables together. The result would probably be 150 to 300 database calls. Whether as with LLBL Gen Pro, there would be 4.
In looking through the online comments aboutu the Telerik ORM, I ran across the following.
"Fetch Plan is used to optimal fetch the initial result of the query and to navigate to a data that is not yet in memory. This allows you to optimize navigation on a generic node tree and always fetch 3 levels together."
Could somebody at Telerik please clarify that this statement means that Telerik ORM suffers the same problem as Linq to Sql in this regard? Or conversely can you verify that your ORM supports unlimited Prefetches of tables for eager loading.
Another question to add here, does your ORM give you a equivalent to the Adapter model with LLBL Gen pro. For my needs, the main importance of this feature for my environment is it forces the developers to prefetch any tables they need data for and effectively disables lazy loading. WHich is key in trying to prevent bad code from destroying performance if the persons writing the code don't pay attention to what they are doing?
Thanks.
I'm currently use LLBL Gen pro as my ORM. I was poised to make the transition to Linq to Sql but found a serious flaw in the design/performance that has caused me to rule it out at this time.
Having a telerik subscription I am curious in evaluating this product but I need to know up front if Open Access supports the ability to prefetch as many tables as needed with any limitations.
An example of what I'm talking about. Let's take the Northwind database. Say I want to create a middle tier endpoint called GetEmployeeCustomers.
My entity in my Middle tier will contain data from the Employee, Customer, Order and Order Details database. I want all this info back at the same time.
With Linq to Sql you can only prefetch 2 tables at at time so this query would resort to lazy loading after prefetching employee and customer tables together. The result would probably be 150 to 300 database calls. Whether as with LLBL Gen Pro, there would be 4.
In looking through the online comments aboutu the Telerik ORM, I ran across the following.
"Fetch Plan is used to optimal fetch the initial result of the query and to navigate to a data that is not yet in memory. This allows you to optimize navigation on a generic node tree and always fetch 3 levels together."
Could somebody at Telerik please clarify that this statement means that Telerik ORM suffers the same problem as Linq to Sql in this regard? Or conversely can you verify that your ORM supports unlimited Prefetches of tables for eager loading.
Another question to add here, does your ORM give you a equivalent to the Adapter model with LLBL Gen pro. For my needs, the main importance of this feature for my environment is it forces the developers to prefetch any tables they need data for and effectively disables lazy loading. WHich is key in trying to prevent bad code from destroying performance if the persons writing the code don't pay attention to what they are doing?
Thanks.