Home/Products/OpenAccess ORM/Resources/Why Choose OpenAccess ORM over Entity Framework

7 Reasons to Choose OpenAccess ORM over Entity Framework

1. New Features 3 Times per Year

It's a race - with technology and competition. And we like to be ahead, so that you are ahead with the newest tools. We never stop - 3 major and at least 3 service releases per year for every product. Weekly builds are also available so that your problems are eliminated right away.

2. Industry-Leading Dedicated Technical Support

Developer tools are useless without technical support. And we offer the very best one. Even during your trial period. Actually that's a key reason why people choose Telerik. We are there when you most need us. You don't get just DLLs, but solutions for your assignment.

3. Familiar Visual Designer, More Functionality

Create a working project in minutes with the Visual Designer for OpenAccess ORM, just like you would do with LINQ to SQL. The same experience and usability, but enriched with a functional visual editor, numerous wizards, and tools.

4. Batch-update Your Data Model Classes & Properties at Once

Use the OpenAccess Batch Operation Dialog to configure your data models easier than ever. With the help of the Batch Operation Wizard, developers can efficiently make updates to several entities or members, in a single operation. It is as easy as it sounds.

5. Convert from Entity Framework to Telerik OpenAccess

Easily convert existing Entity Framework projects to using OpenAccess ORM and take advantage of the Telerik ORM’s extended functionality. Use the converter wizard to simply select the target dbml file in the Visual Studio Solution Explorer and click “Convert from EF Model to Domain Model” from the contextual menu.

6. Broad Database Support

Telerik OpenAccess ORM works equally well with more than 20 databases (and new ones are constantly added), such as Microsoft SQL 2000, SQL Azure, Oracle, and more (see below for more information). All major features, such as stored procedures, views, and concurrency control are supported for all databases.

7. Quickly Get Started with the Free Software Development Kit

The Telerik Software Development Kit (SDK) for Telerik OpenAccess is an easy to use resource browser for all things OpenAccess. It includes demos and relevant information for developers to get started and quickly integrate Telerik OpenAccess ORM in their applications. Find out more and get it.

OpenAccess and Entity Framework 4 Comparison

Legend:

  • Full support
  • Limited support
  • Not supported
  • n/a- Not applicable
Database Support
Database OpenAccess ORM
Entity Framework 4.0
Close In Telerik OpenAccess ORM you have a unified behavior, exactly like with a normal database. With EF currently you need to link against local database, and later on just change the connection string.
MS SQL Azure Integrated Support
Yes Limited
MS SQL Server 2000 Yes Not Supported
MS SQL Server 2005/2008/2008 R2 Yes Yes
MS SQL Server 2005/2008 Express Yes Yes
MS SQL Server Compact 3.5 Yes Yes
Microsoft SQL Server 2000 Desktop Engine (MSDE) Yes Not Supported
Oracle ODP 9.2 Yes Not Supported
Oracle ODP 10.x Yes Not Supported
Close Oracle Corporation recently announced they are starting the implementation of EF Provider for Oracle.
Oracle ODP 11.x
Yes Not Supported
Oracle Database 10g Express Edition Yes Not Supported
Close There is an EF Provider implementation in the Open Source .Net Connector, but it is community driven, not a commercial implementation by the vendor.
MySql 5.0, 5.1
Yes Limited
Firebird Yes Not Supported
SQL Anywhere Server 10.x Yes Not Supported
VistaDB Yes Limited
Advantage DB Server 8.1 Yes Not Supported
SQLite Yes Not Supported
PostgreSQL 8.4+ Yes Not Supported

Legend:

  • Full support
  • Limited support
  • Not supported
  • n/a- Not applicable
Features
Feature OpenAccess ORM Entity Framework 4.0
Close Currently the Data Services Wizard (DSW) is representing this category, but post Q2 we will announce a complete AddIn framework for extending the Telerik OpenAccess ORM platform in various ways and places.
Productivity Add-in Framework
Yes Not Supported
Custom Types Framework Yes Not Supported
CloseWith Telerik OpenAccess ORM both the Visual Designer For Open Access and the Ria Services infrastructure are well integrated into a single mould technology stack.
WCF Ria Services Support (built-in)
Yes Not Supported
CloseWith Telerik OpenAccess ORM both the Visual Designer For Open Access and the Ria Services infrastructure are well integrated into a single mould technology stack.
WCF Data Services Support (built-in)
Yes Not Supported
Fluent Mapping API (Beta)
Yes Yes
Visual designer Yes Yes
Visual Round-tripping designer Yes Yes
DDL Capabilities Yes Yes
Database Schema migration (DML) Yes Not Supported
Runtime Database Schema API (DML) Yes Not Supported
Close This API is unique for Telerik Open Access ORM and is heavily utilized by our Sitefinity product. Everything is based on Artificial Fields and Types – types that are not mapped during design time, but in the runtime the definitions are specified Ad-Hoc. All CRUD operations are allowed through this API, so database schema alternation is possible too.
Ad-hoc (Runtime) Model Modification
Yes Not Supported
Built-in Validation Framework Yes Not Supported
Fetch Optimizations Yes Limited
Many-to-many support Yes Yes
Stored procedures support Yes Yes
LINQ Querying Yes Yes
Command line generation tools Yes Yes
Supports .NET 2.0 Yes Not Supported
Supports .NET 3.5 Yes Not Supported
Supports .NET 4.0 Yes Yes
Optimistic Concurrency Yes Yes
Pessimistic Concurrency Yes Not Supported
Built-In L2 Cache Yes Not Supported
Advanced Connection Pooling Yes Not Supported
Pure XML mapping Yes Not Supported
Pure Attributes mapping Yes Not Supported
Close The EF 4.0 has templates for generating Self-Tracking Entities, which can be considered DTOs and even POCOs.
DTO (Data Transporter Objects)
Yes Yes
Close The EF 4.0 has templates for generating Self-Tracking Entities, which can be considered DTOs and even POCOs.
POCO support
Not Supported Yes

Get the full stack with 7 more products! Premium Collection for .NET

  • All Telerik UI for web / desktop
  • Code Analysis & Refactoring tools
  • Data Access Tools & Reporting Engine

Compare now

Add-Ons for Telerik OpenAccess ORM
Integration Capabilities
Telerik OpenAccess ORM Free Edition

Customers Speak

open quotation We have been using the Telerik Premium Suite on our most recent project and it has proven to be an invaluable asset and resource for rapid development. Recently we have progressed with the integration of Telerik OpenAccess ORM in our suite of internal software, this has in turn given us a substantial improvement in the continuity of our data layer whilst providing effortless integration into the development environment.
Sacha Rice Senior Analyst Programmer
Selected Awards