Supported Databases:

• Microsoft SQL Azure
• Microsoft SQL Server 2000, 2005, 2008, 2012
• Microsoft SQL Server 2005, 2008, 2012 Express, LocalDB
• Microsoft SQL Server Compact 3.5, 4.x
• MySQL 5.x
• Firebird 2.x
• Advantage Database Server 9.1, 10.1
• Sybase SQL Anywhere 11.x, 12.x
• Oracle Server 9.2, 10.x, 11.x
• Oracle Database 10g, 11g Express Edition
• VistaDB
• SQLite
• PostgreSQL 8.4+
• Maria DB 10.0 Alpha

LINQ (Language Integrated Query) Support

OpenAccess ORM offers extensive LINQ support against all supported databases, which has been validated with the Microsoft 101 LINQ to SQL Samples (available in the OpenAccess Samples Kit). The major advantage of LINQ is the compile-time check of your queries – meaning no surprises at run time.

OQL (Object Query Language) Support

OpenAccess supports OQL, another object-oriented query language defined a long time ago by the Object Database Management Group. It was there before the invention of LINQ but now you can use it in such cases where you need to build the query at runtime dynamically.

Using Existing Stored Procedures, Views and Tables

Stored Procedures

OpenAccess allows developers to create new or reuse existing Stored Procedures, and to follow the widely adopted pattern of db logic encapsulation inside the database. Under higher security requirements the stored procedures can be used for all insert, read, update and delete operations to inject additional checks in the database server. A Stored Procedures Editor simplifies the setup and use of stored procedures. If you are working with an Oracle database, you can 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.

Tables and Views

With Telerik OpenAccess ORM you can map database views and tables to classes and vice versa (forward and reverse mapping). The data exposed by the tables and views can be modified and stored back to the database.

Concurrency Mechanisms

OpenAccess supports both optimistic and pessimistic concurrency control. Both approaches can be mixed during runtime. Additionally it is possible to automatically obtain a pessimistic lock upon the first modifying access in an otherwise optimistic transaction. When using optimistic concurrency control (the default), conflicts can be detected by designated version fields, the old content of the modified fields or all fields. And you can also turn conflict detection off.

OpenAccess LINQ DataSource Component

This LINQ-enabled data source component targets the RAD developer. It allows you to connect to any supported relational data store such as a database based on the OpenAccess domain model, which can then be consumed by data-bound UI controls, such as RadControls for ASP.NET Ajax. The data source is developed exclusively for .NET 4.0+ enabling support for all the latest enhancements in ASP.NET like query extenders and Dynamic Data support.

Dynamic Data Support

OpenAccess ORM supports the Dynamic Data model (in .NET4) by offering model providers and a Dynamic Data wizard for converting the OpenAccess metadata to the Dynamic Data model.