Unlike most Data Access solutions, Telerik Data Access is able to working with single entities to define thousands of updates or deletes in an unified LINQ-like API, executed with a single database call.
Poor network connectivity between a database and an application sometimes slows data access. In such scenarios, Telerik Data Access combines similar database calls in fewer batches. This results in fewer database calls, and does it based on parameters defined by you.
Telerik Data Access retrieves data “lazily” by default, once it is accessed for the first time. Fetch Strategies optimally fetch related entities to reduce the number of database calls. This feature avoids the common performance pitfall that is known as the, "N+1 query problem." Instead of querying for one order and then performing the n order details, a Fetch Strategy can be configured for one optimal query.
If you are concerned about performance and comfortable with writing ADO.NET like code, then the Data Access ADO API is perfect for you. It gives you fast low-level access to your data and is especially helpful in data-intensive enterprise applications where performance is key. The benefits of this approach include:
Telerik Data Access helps guarantee speedy access to your data because it does not use reflection. The tool employs a technique called Enhancement, which augments the code the compiler generates by adding the needed persistence, lazy loading and change tracking capabilities.
Get your fully functional free copy of Data Access.
Read comprehensive technical documentation complete with code snippets
Explore Knowledge Base
Explore tutorials and working examples on how to achieve common scenarios
Copyright © 2017, Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.