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 |
| | 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 |
| | Yes | Not Supported |
| Oracle Database 10g Express Edition | Yes | Not Supported |
| | 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 |
| | Yes | Not Supported |
| Custom Types Framework | Yes | Not Supported |
| | Yes | Not Supported |
| | 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 |
| | 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 |
| | Yes | Yes |
| | Not Supported | Yes |