ADO is built on top of OLEDB, and neither of those technologies have anything to do with the Firebird .NET provider. ADO and OLEDB are COM-based technologies (and I wouldn't say they were "recommended" by Microsoft - certainly not for .NET development).
The Firebird .NET provider is based off the .NET System.Data architecture, which is better suited to .NET and is a little more flexible as well. You do not NEED to use the Firebird classes (except to create the actual connection) - most actions can be performed via the IDb* interfaces that all System.Data providers implement (so IDbCommand instead of FbCommand, IDataReader instead of FbDataReader, etc). IMHO, though, trying to get "database independence" using the interfaces is usually not worth it, unless you're writing against multiple database engines right from the start. Dean. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Andrew Chalk > Sent: Friday, 29 December 2006 7:27 am > To: [email protected] > Subject: [Firebird-net-provider] Does this support the OleDbConnection > Class? > > I am not clear about the difference between ADO and OLEDb. The > Firbird .Net > Provider has lots of examples that use its own class to access the > provider. > What if I want to use the MS recommended OleDbConnection (and associated > OleDbXXX class) calls to access a database? Does this provider support > this? > > Thanks > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Firebird-net-provider mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
