I downloaded Firebird 2.5 and read somewhere that it supports Entity Framework. When I add ADO.NET Entity Data Model in my project and try to update database with model, Visual Studio 2010 only displays SQL Server data sources in the list. There is no ODBC or Firebird.NET provider listed.
In that case, how to make Firebird to act as a data source for the Entity Model in my proje开发者_Go百科ct?
Install Firebird-2.5.0.26074_1_Win32.
Install NETProvider-2.6.0.
And to integrate it in VS2010:
Extract FirebirdDDEXProvider-2.0.5.zip and follow instructions in ReadMe.txt inside.
(the combination of these versions is working - I haven't tried the newer versions)
Update: A little more details on how I did some of the steps in ReadMe.txt
In Step-1: Register these 2 files in GAC
cd "C:\Program Files\FirebirdDDEXProvider-2.0.5"
"C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin\NETFX 4.0 Tools\gacutil.exe" /i FirebirdSql.VisualStudio.DataTools.dll
cd "C:\Program Files\FirebirdClient"
"C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin\NETFX 4.0 Tools\gacutil.exe" /i FirebirdSql.Data.FirebirdClient.dll
In Step-2: Here is the part I added to machine.config
<configuration>
<configSections>
...
<section name="firebirdsql.data.firebirdclient"
type="System.Data.Common.DbProviderConfigurationHandler, System.Data,
Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
and
<system.data>
<DbProviderFactories>
<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient"
description=".Net Framework Data Provider for Firebird"
type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data.FirebirdClient, Version=2.6.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c" />
Replace "3750abcc3150b00c" in the above with the key from this:
"C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin\NETFX 4.0 Tools\gacutil.exe" /l Firebirdsql.data.firebirdclient
i did the same, in server explorer Firebird's provider is recognized, but i can't create entity data model, because there is no Firebird's provider in provider's list.
Better to use MSI packages that are now available. For both provider as well as DDEX. It will take care of registering DDEX etc. for you. Don't forgot to click "Advanced" button to select proper versions.
精彩评论