ORM and Beyond
Telerik OpenAccess is an Enterprise-grade .Net ORM that does the data access plumbing in desktop and web applications. Supporting forward (model-first) and reverse (schema-first) mapping, the tool offers transparent persistence for your DAL and business objects. OpenAccess ORM provides tight Visual Studio integration and allows you to seamlessly create database independent code. Take full control of the mapping process and generated model with the powerful Visual Designer for OpenAccess ORM and the advanced features for code optimization and caching.
Telerik controls support Visual Studio 2010
Why Choose
Powerful Visual Designer
Create a working project in minutes with the Visual Designer for OpenAccess ORM. Build your domain model and take full control of the mapping process with the help of an advanced visual editor.
Forward (model-first) and Reverse (schema-first) Mapping
You can start from the database or from your persistent classes. Telerik's .Net ORM can start from existing legacy databases, detect your data model, create object models, and even let you edit the object model. Alternatively, you can just start from your model of persistent classes and push those to the database. OpenAccess supports rich variety of mappings for collections and class hierarchies.
Full round-trip Mapping
With the Visual Designer for OpenAccess ORM you don’t have to choose whether to forward- or reverse-map your project in advance. Thanks to the full round-trip mapping support you are able to employ both approaches at any moment during design time.
Extensive LINQ Support
Use the extensive LINQ support that OpenAccess provides to work with your data in a unified way. You can also use any of the two other options – standard OQL and direct SQL. Regardless of the language, we provide you with all the means to easily query your data. Read more...
Fluent mapping API (Beta)
Fully configure the OpenAccess ORM model mapping by using only code and without the use of attributes or XML definitions.
Full Database Mapping
OpenAccess can map to all three database objects – Views, Stored Procedures and Tables. This means you can significantly improve your applications’ performance and security by fully utilizing the resources of your database server.
Silverlight Integration
Simple, yet powerful integration with Silverlight through supporting plain WCF services, Data Services, Ria Services technologies.
Build-time Bytecode Enhancement
No source code generation, easy to understand persistent classes, no mistakes can be made to break lazy loading or change tracking.
Testability
All classes enhanced by Telerik's .Net ORM are still normal CLR objects, and as such can be easily tested by state of the art unit tests. Moreover, 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.
Caching
The OpenAccess .Net Object Relational Mapper has unique caching features to optimize the data handling: Connection Pool settings, Compiled Query Cache / Prepared Statement Cache, First Level Cache, Distributed Second Level Cache.
Generic Data Access
OpenAccess provides a unique technique to access the persistent data in a generic way without the need to use reflection. The technique significantly increases the speed of all read and write operations. Read more...
Transparent Persistence
All classes in Telerik's .Net ORM are persistent ignorant and work independently. User experience is enhanced through strong Visual Studio integration and interactive wizards. The code is free of data access code “plumbing” and is enhanced transparently after compilation. Read more...
Native .NET API and ZERO Reflection
OpenAccess uses standard .NET conventions and idioms. Enjoy inheritance, polymorphism, composition and the .NET collections framework, including generic collections. What’s more, OpenAccess does not use .NET reflection and can be used even in Medium Trust environments.
Visual Studio Integration
Leverage a familiar environment. The powerful wizards will allow you to set up a persistent model with just a few clicks. Use datasources for all platforms to do most of the work codelessly. OpenAccess is fully integrated into Microsoft Visual Studio 2005/2008/2010 and supports all IL compatible languages. OpenAccess supports full source code control in TFS or any other SCM system.
Multi-tier Support
Easily send around persistent data directly or with the OpenAccess Object Container. OpenAccess takes care about change tracking / lazy loading and all necessary optimistic concurrency information.
SQL Optimization
Telerik OpenAccess lets you control the generation and use of SQL code. Using the Fetch Plans you can optimally fetch the initial result of your query and to navigate to a data that is not yet in memory. Performance can be further enhanced through the use of Stored Procedures for read and write operations , which let you reuse existing SQL code to return queried data and to execute insert, update, and delete operations in the data source.
Runtime Changes
Using a unique functionality of OpenAccess you can make runtime changes to your applications object model or database schema without the need to recompile. This feature is especially valuable for applications which allow the users to customize its structure, e.g. CRMs or CMSs. Read more...
Support for Medium Trust Environments
OpenAccess offers support for medium-trust code security levels. This means you will be able to seamlessly integrate it in ASP.NET hosting environments.
Distributed Systems Support
In the emerging mobile and Web 2.5 world, your .NET application needs to support all kinds of disconnected scenarios. Anywhere, anytime. To work with portions of your data in a disconnected mode, OpenAccess offers the object container. It's light, compact and easy-to-use.
Database-independent Code
Enjoy true portability for your application. OpenAccess support most ofthe commercial databases in use such as Microsoft SQL Server, Oracle andMySQL.