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.
Telerik Data Access comes with a caching mechanism (2nd Level or L2 cache), which reduces the calls made to the relational server. It does this by storing data and query results in the application process. This gives fast retrieval of the commonly used objects, and increases the efficiency and performance of your application. Caching can be fine-grained on a per class basis, implemented in multi-threaded applications and coupled over the network to provide a distributed synchronized cache.
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.
By using Fetch Plans you can optimally fetch the initial result of your query and later on retrieve data that is not yet in memory. You can easily instruct the tool whether to load the data immediately or to defer it (eager-loading), thus optimizing the query fetching performance. This feature avoids the common performance pitfall that is known as the 'N+1 query problem' where instead of querying for one order and then performing the n order details, a Fetch Plan 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 © 2002-2016 Telerik. All rights reserved.
Powered by Telerik