----- Original Message -----
From: "Graham Hardwick" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, April 20, 2006 6:57 AM
Subject: [Firebird-net-provider] DDEX
Has anyone looked at how SQLite's ADO.NET 2.0 provider integrates with
Visual Studio 2005 ?
It only requires running the install.exe file and SQLite is available in
VS2005.
Firebird's provider's integration into VS2005 is clumsy, and it's not
available like SQLite's is.
Since SQLite is open source too, maybe its provider's installer could be
adapted to the Firebird's provider.
I've looked, but I can't do it.
This would probably help you Firebird users out a lot :) The install.exe
file does the following:
- Automatically detects what VS2005 editions you have installed and allows
you to install the provider into each one on an individual basis.
- Installs the SQLite provider and its designer into the GAC
- Adds the SQLite provider to the machine.config on both 32-bit and 64-bit
frameworks
- "Moves" the JET database provider on Express Editions and replaces the JET
entries with SQLite entries so that SQLite can be used on Express Editions.
(Also moves it back when you uninstall the SQLite provider)
- Adds SQLite's path to the registry so it can be found when adding it to
Compact Framework projects and full .NET projects
- Adds it's paths for all the build types to the LIBPATH variable -- no easy
task actually as VS2005 puts this information in several places on disk and
in your localsettings folder. This is needed in order to support typed
dataset generation in managed C++
The installer is one of those projects I slapped together quickly and it
kindof grew up a little too fast -- so its not as readable as my other code
nor as easy to follow.
In order to adapt it to Firebird you'd have to:
- Change the GUID's for the DataProvider and DataSource from SQLite's to
Firebird's
- Change all the folder paths that the install.exe expects to find things
in. ** This one is loaded -- all the XML editing code for setting the
LIBPATH and things also have to be changed.
- Comment out the 64-bit GAC registration, provided Firebird was pure MSIL
and compiled for "Any CPU"
- Change all the namespace references from SQLite's to Firebird's. This
includes the various Firebird designer namespaces and class names.
Robert
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
