Re: OleDb

Bert Huijgen wrote:
> Hi,
>  
> Does Firebird support ADO.NET OleDb? I see Firebird created it's own 
> connection and adapter classes, but this is very against the ADO.NET 
> architecture, I think it is a very strange choice. ADO.NET has OleDb and 
> SQL classes. SQL for the Microsoft SQL Server database, OleDb for all 
> other databases. Firebird is an other database, so I would expect that 
> the Firebird ADO.NET service provider supports OleDb. If the Firebird 
> OleDb service provider supports OleDb then I can create database 
> independent code, because many other databases support OleDb. If I have 
> to use special classes for every database I get very messy code. So my 
> question is: does the Firebird service provider support OleDb, if not, 
> is this planned in the future?

You're absolutely wrong. OleDb isn't for others.

If you want to be right in ADO.NET, you have to use native providers (MS 
SQL, Oracle, FB, ...) and avoid using common (Ole, ODBC, ...). For 
independent code, you have to use interfaces, like IDbConnection, etc. and 
instatiate native classes.

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-------------------------------------------------------------------------
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