Entity Developer supports the following ADO.NET providers:
o | Microsoft data provider for SQL Server CE |
o | Async MySQL ADO.NET Connector ** |
o | Oracle Data Provider for .NET |
o | Oracle Managed Data Provider for .NET |
o | dotConnect for PostgreSQL * |
o | Microsoft.Data.Sqlite ** |
o | dotConnect for Salesforce (for Entity Framework models) |
o | Firebird ADO.NET Data Provider |
o | 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.
|