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,
SQLite, DB2, and Salesforce.
dotConnect data providers support all the Entity Framework versions - Entity Framework
v1, v4, v5, and v6.
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, SQLite,
dotConnect data providers support
Dynamic database creation and database deletion for Entity Framework v1,
v4.x, v5, and v6. They also
support Code-First Migrations for Entity Framework 4.3 and higher.
dotConnect data providers for Oracle, MySQL, and PostgreSQL support Entity Framework Spatials functionality for Entity Framework
v5 and v6.
dotConnect product line offers wide support for database types including
Oracle CURSORs and SDO_GEOMETRY, MySQL geometry, PostgreSQL PostGIS geometry
and geography data types.
dotConnect product line offers wide support for user-defined stored procedures and
Database-specific system functions of Oracle, MySQL, PostgreSQL, SQLite, and DB2 can be used in LINQ to Entities and
SQLite support database full-text search functionality in LINQ
to Entities and Entity SQL queries.
Our providers support configurable
batch updates, grouping several INSERT/UPDATE/DELETE statements into one
SQL block, which increases SaveChanges() performance substantially, because of reducing
number of server calls and producing more compact SQL code.
A number of SQL optimizations allows generating high-performant SQL. Additionally,
you may optionally disable SQL formatting to reduce SQL statement size. dotConnect
for Oracle supports
Oracle Optimizer Hints for further performance improvements.
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 with Entity Data
Model Wizard and Update Model Wizard (or with Attach Data Source wizard for LightSwitch
applications) in Visual Studio and with our own ORM model designer - Entity Developer, which is supplied with the providers.
You may create a model in Visual Studio 2010, 2012, or 2013 Entity Model Designer and then
generate database DDL script with Create Database
Wizard. The same can be done with
Entity Developer in Visual Studio 2008, 2010, 2012, and 2013. Entity Developer
also allows updating database according to the model changes.
You may create a set of POCO classes, set up mapping with attributes or fluent mapping,
and specify the database creating/deleting and filling with initial data. Our providers
support this approach completely and allow additional tweaking. Reverse
engineer Code-First is also supported via Entity Developer's
DbContext template, generating POCO classes and Code-First mapping for an
* Some of the advanced features are available only in Entity Developer
** EDM designer supports this functionality since Visual Studio
Visit our Entity Developer
vs Entity Data Model Designer page to get more information on Entity Developer
See how to use Code-First in dotConnect for Oracle.
Try our Entity Framework support on Entity Framework Query Samples application.
Try our Entity Framework Spatials support for Oracle, PostgreSQL, and MySQL