Telerik

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 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
Persistent classes should be used as business classes. All classes in OpenAccess work independently and can easily be 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 counter shows you the state of your running application, website or application server.

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

Optimized code
OpenAcccess allows you to optimize 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 optimize navigation on a generic node tree and always fetch 3 levels together.

Transparent persistence
Persistent classes should be used as business classes. All classes in OpenAccess are persistent ignorant and work independently. Persistent classes can easily be 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 counter shows you the state of your running application, website or application server.

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, Vanatec OpenAccess offers the object container. It's light, compact and easy-to-use.