The latest ADO.NET evolution focuses on raising the level of abstraction from the
logical (relational) level to the conceptual (entity) level. For this purpose Microsoft
introduces the Entity Framework, designed to simplify data
- object conversion and embed data access queries into program code.
The Devart dotConnect product line supports the ADO.NET Entity Framework for Oracle,
MySQL, PostgreSQL, and SQLite.
dotConnect data providers offer the most complete support for LINQ to Entities and
dotConnect data providers support most of the Entity Framework Canonical Functions for Oracle, MySQL,
PostgreSQL and SQLite.
dotConnect data providers support Dynamic database creation and database deletion for Entity
Framework v1, v4.x and v5.
dotConnect product line offers wide support for database types including
Oracle CURSORs. Users can add support for more datatypes, e.g. PostGIS types
dotConnect product line offers wide support for stored procedures.
Database specific functions can be used in LINQ to Entities and Entity SQL.
Our providers support configurable batch updates, grouping several INSERT/UPDATE/DELETE
statements into one SQL block, which increases ObjectContext.SaveChanges performance
substantially, because of reducing number of server calls and producing more compact
A number of SQL optimizations allows generating high-performant SQL. Additionally,
you may optionally disable SQL formatting to reduce SQL statement size.
You may generate an Entity Framework model, based on an existing database, and then
update the model if the database was changed. This can be done both with Entity
Data Model Wizard and Update Model Wizard in Visual Studio 2008 or 2010
and with our own ORM model designer - Entity Developer,
which is supplied with the providers.
You may create a model in Visual Studio 2010 Entity Model Designer and then generate
database DDL script with Create Database Wizard.
The same can be done with Entity Developer in both Visual Studio 2008 and 2010.
You may create a set of POCO classes and set up mapping with attributes or fluent
mapping and specify the database creating/deleting and filling with initial data.
Our ADO.NET providers
support this approach completely and allow additional tweaking.
* Some of the advanced features are available only in Entity Developer
** EDM designer supports this functionality since Visual Studio
Read about new features of Entity Framework support in our providers.
See how to use Code-First in dotConnect for Oracle.
Try our Entity Framework support on Entity Framework Query Samples application.
Read about our Entity Framework dbContext template with fluent mapping.