Compatibility

IDE compatibility

Entity Developer generates models compatible with Visual Studio 2015, 2017, 2019, 2022, and 2026. 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 or higher is required for Entity Developer.

ORM framework compatibility

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

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)

Database providers support

Entity Developer supports the following ADO.NET providers:

• SQL Server:

  • SqlClient
  • SQL Server Compact:
  • Microsoft data provider for SQL Server CE

• MySQL:

  • dotConnect for MySQL *
  • MySQL Connector/Net
  • Async MySQL ADO.NET Connector **

• Oracle:

  • dotConnect for Oracle *
  • OracleClient *
  • Oracle Data Provider for .NET
  • Oracle Managed Data Provider for .NET

• PostgreSQL:

  • dotConnect for PostgreSQL *
  • Npgsql

• SQLite:

  • dotConnect for SQLite *
  • System.Data.SQLite
  • Microsoft.Data.Sqlite **

• Salesforce:

  • dotConnect for Salesforce (for Entity Framework models)

• Firebird:

  • Firebird ADO.NET Data Provider

• DB2:

  • dotConnect for DB2 *
  • IBM 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.

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

See also

• General Information
• Introduction