Re: [Firebird-net-provider] MS SQL to Firebird?

[Jason V. <jas...@ya...>]

While I can't quite answer your precise question, I am
developing applications for both MS SQL and Firebird
side by side in C++ with managed extensions, where
objects provide an abstraction between application
code and the ADO.NET interface for either engine (with
provisions for ODBC providers).

What I've found so far is that while there are
specific differences in the server or provider,
Firebird and the FB provider are generally very
similar in features, it's just the details that vary
slightly. For example, the FB provider is more
particular about requiring transactions than Sql
provider, the data type enumerations are different,
and the collection of meta-data is slightly different
between the servers.

It's my opinion that for any situation where even
slight differences exist, object abstraction is
indicated (even though it seems that ADO.NET is an
abstaction, it's not a consistent abstraction and
therefore fails to provide application code a single
interface). 





__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com