Product Variants

Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.

Product Information

Telerik OpenAccess is an Enterprise-grade ORM that does the data access plumbing in desktop and web applications. Supporting both forward and reverse 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 generated code by customizing the tool and leveraging its advanced features for code optimisation and caching.

New Features

New in Q1'12

• Batch operations for modifying your model at once - update large models in just a few clicks - update many (or all) classes and properties such as changing class namespaces, changing property types etc. Get names and properties in a datagrid to speed up multiple edits and use a grid-based overview so you always have a good reference for the current state of your model.
• One minute fluent API code generation - generate all of your Fluent code automatically as it is done with the Visual Designer models. At the same time, since the generated code contains Fluent API declarations, you can benefit from the capabilities this API is offering for modifying and extending the mapping.
• Oracle stored procedure improvements - return even REF cursors from your stored procedures – OpenAccess will automatically generate a method reading the result set and return it to your client code.
• Context API enhancements -various enhanced Context API functionalities like Flush, Tracking callbacks, etc., allow you to easily apply changes to the database without finalising the transaction, get the change history and more.
• Fetch strategy as part of LINQ statements - define a fetch strategy for a specific LINQ query before execution and clear the strategy after it. The Fetch Strategy will become a part of the LINQ statement and no extra code has to be written.
• OpenAccess Profiler stores the trace locally - the OpenAccess Profiler can now store your trace data locally for analysis - just by clicking the new Save button you will have the trace saved in a file you choose.
• OpenAccess dynamic data application project template - you won’t have to do any additional setup in order to start creating your data-driven application.

New in Q3'11

• Visual Studio project templates - new templates for .NET 4.0 projects make it easier to get up and running, templates include: Telerik OpenAccess WebSite, Telerik OpenAccess Web Application, Telerik OpenAccess Class Library, Telerik OpenAccess Fluent Library, Telerik OpenAccess MVC2 Application
• Full stored procedure support - now you can bind to a stored procedure, specify the result set, give a name to the generated method and use projections in an easy fashion
• LinqDataSource Component - use the OpenAccessLinqDataSource to connect to any supported relational data store such as a database based on the OpenAccess domain model, which can then be consumed by the data-bound UI controls
• Dynamic Data Support - support for the .NET 4 Dynamic Data model. The Dynamic Data wizard assists with creating and customising data pages, choosing the insert/details/editing options needed for the custom page, controlling the validation and more
• New Profiler View - a new view provides a configurable dashboard which can show database read/write traffic, second level cache hits, context pool and connection pool
• Support for SQL Azure 11.x - OpenAccess now supports SQL Azure 11.x
• Mapping Metadata Improvements - Telerik have optimised the mapping metadata which results in better memory footprint by 50% and improved Change Notification Mechanism.

New in Q2'11

• OpenAccess Profiler - the new OpenAccess Profiler eliminates the common 'black box' problem associated with ORM frameworks. With support for SQL and LINQ statement visualisation, performance deficiency analysis and detection and key behavior summary values, the profiler helps developers quickly understand and optimise data operations powered by OpenAccess.
• Low level (ADO) API for fetching data efficiently - the new ADO.NET-like API gives fast low-level access to your data. The new API is especially helpful in data-intensive enterprise applications, where performance is key, such as really complex setups that require native SQL execution, materialisation of objects that are not entities, traversal of multiple resultsets and better stored procedure handling.
• Fluent mapping API: feature complete, easier to get started with - the OpenAccess Fluent Mapping API is now feature complete, covering 100% of Telerik OpenAccess's functionality.
• Updated wizards - many of the wizards have an updated, more intuitive user interface.

Features

Incredible productivity

Slash your data access code by a factor of 10. Drastically improve development time. Less mistakes in the DAL to fix.

Forward and reverse mapping

You can start from the database or from your persistent classes. OpenAccess 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.

LINQ support

Use familiar LINQ constructs when you query your database. If that’s not enough, we offer two other options – standard OQL and direct SQL. Regardless of the language, we provide you all the means to easily query your data.

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 OpenAccess 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 Object-relational Mapper has unique caching features to optimise the data handling: Connection Pool settings, Compiled Query Cache / Prepared Statement Cache, First Level Cache, Distributed Second Level Cache. Read more...

Database-independent code

Enjoy true portability for your application. OpenAccess support most of the commercial databases in use such as Microsoft SQL Server, Oracle and MySQL.

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 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.

Optimised code

OpenAccess allows you to optimise the SQL generation not only during query time but also during navigation on the object model. The 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 optimise navigation on a generic node tree and always fetch 3 levels together.

Transparent persistence

All classes in OpenAccess 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.

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.