Compatibility

ExpandedToggleIcon        IDE Compatibility

Entity Developer generates models compatible with Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, Visual Studio 2019б and Visual Studio 2022. Entity Developer is integrated with Visual Studio and can be invoked from the IDE, but Visual Studio is not required by Entity Developer to function.

.NET Framework 3.5 Service Pack 1 or higher is required for Entity Developer.

 

ExpandedToggleIcon        ORM Framework Compatibility

Entity Framework and Entity Framework Core (all release versions)
NHibernate 3 and higher
Telerik Data Access
LINQ to SQL
LinqConnect

 

ExpandedToggleIcon        DBMS Server Compatibility

Entity Developer is compatible with the following DBMS servers:

SQL Server 2000 and higher
MySQL 4.1 and higher
Oracle 8 and higher
PostgreSQL 8 and higher
SQLite 3 and higher
Salesforce (for Entity Framework)
Firebird 2.0 and higher (for Entity Framework and NHibernate)
DB2 9.5 and higher (for Entity Framework and NHibernate)

 

ExpandedToggleIcon        Database Providers Support

Entity Developer supports the following ADO.NET providers:

SQL Server:
oSqlClient
oSQL Server Compact:
oMicrosoft data provider for SQL Server CE
MySQL:
odotConnect for MySQL *
oMySQL Connector/Net
oAsync MySQL ADO.NET Connector **
Oracle:
odotConnect for Oracle *
oOracleClient *
oOracle Data Provider for .NET
oOracle Managed Data Provider for .NET
PostgreSQL:
odotConnect for PostgreSQL *
oNpgsql
SQLite:
odotConnect for SQLite *
oSystem.Data.SQLite
oMicrosoft.Data.Sqlite **
Salesforce:
odotConnect for Salesforce (for Entity Framework models)
Firebird:
oFirebird ADO.NET Data Provider
DB2:
odotConnect for DB2 *
oIBM DB2 .NET Data Provider *

 
* Not supported for Telerik Data Access.

** Supported for Entity Framework Core only

For LINQ to SQL models Entity Developer supports only SqlClient to connect to SQL Server database.

 

Entity Developer Configuration for Third-Party Providers

 

Most database providers does not require any specific configuration to use in Entity Developer. However, some of the providers, for example, System.Data.SQLite, are not added to the machine.config file by default. If you use Visual Studio 2008, or if you have .NET Framework 3.5, and not higher, in your system, you may need to add the corresponding record into the config file yourself for such provider. The record for the System.Data.SQLite provider will look like the following:

<add name="System.Data.SQLite Data Provider" invariant="System.Data.SQLite" 
    description=".NET Framework Data Provider for SQLite" 
    type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.105.2, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

This record must be added to the following section:

<system.data>
    <DbProviderFactories>
        ...
    </DbProviderFactories>
</system.data>

You may either add the record to the EntityDeveloper.exe.config file to work with ORM models using this provider only in Entity Developer as a standalone application. Alternatively, you may add this record to the machine.config file of your computer. In this case the provider is globally available, and you can use it in both standalone Entity Developer, and Entity Developer as a Visual Studio add-in.

In the EntityDeveloper.exe.config file, there is no such section by default, so you will need to add it.

 

ExpandedToggleIcon        LinqConnect Compatibility

LINQ to Oracle 9.2.0.4 and higher
LINQ to MySQL 5.0 and higher
LINQ to PostgreSQL 8.2 and higher
LINQ to SQLite 3 and higher

 

ExpandedToggleIcon        See Also


Send feedback on this topic

© 2008 - 2024 Devart. All rights reserved.