Data Access allows you to reuse existing Stored Procedures and Functions and follow the widely adopted pattern of encapsulation logic inside the database. Using one of the two flavors of mapping Functions you can either call them directly or include them seamlessly in LINQ expressions.
You only need to modify the state of an object when updating data - Data Access takes care of the rest. Because the programming model does not change, you do not need to know any of the SQL performed on the backend. Telerik Data Access converts the commands issued by the domain model at runtime (usually via LINQ or low-level API), into backend database retrieval and SQL statements. This frees you from writing the time-consuming CRUD operations. Data Access helps you with the following CRUD operations:
If you view code as your model, preferring to write code instead of using visual assistance tools, Telerik Data Access provides Fluent Mapping API that assists you in setting-up your classes for use with Data Access. There is no need to touch a designer or work with the XML mappings. The completely automated, initial Fluent Mapping code generation is done by Data Access. The Data Access Fluent API covers 100 percent of the the functionality of the mapper, and is efficiently used by Telerik Sitefinity CMS. If required, your model can be visually adjusted in the Visual Mapping Designer.
All classes enhanced by Telerik Data Access are still normal CLR objects, and as such, can be easily tested by state of the art unit tests. SQL code can be traced by writing it to the console, in a text file or to the .NET tracing framework. Performance counters show you the state of your running application, website or application server.
Data Access uses standard .NET conventions and idioms (inheritance, polymorphism, composition, .NET/generic collections, etc.). It does not use .NET reflection. The code is free of data access code "plumbing" and is enhanced transparently after compilation. The code generated by Data Access closely follows all established .NET and object-oriented programming standards.
All classes in Telerik Data Access are persistent ignorant and work independently from the source code and database. This means true portability for your .NET applications, where you can switch the database and reuse the same code and even data model.
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.