[Mono-devel-list] Which Provider?

[Rafael Teixeira]

You should try Npgsql for PostgreSQL. It is distributed with mono and
available individually and
http://gborg.postgresql.org/project/npgsql/projdisplay.php.

Also Firebird.NET is a good option. It's provider is going to be
packaged with mono also.

MySQL has an specific issue: The older LGPL provider (ByteFX) is
packaged with mono but is not being maintained up-to-date. It's main
developer now works for MySQL that offers a newer one but that is only
availabe with a GPL or commercial license.

As always the important thing is software that is really being
maintained/developed. Until Everaldo's salvaged it a bit in the
developing branch, the sqlite ADO.NET provider was an abandoned child
for years, but it still has not all the bell-n-whistles of the more
commonly used providers...

Hope it helps,


On Wed, 26 Jan 2005 15:05:23 -0600, Nicholas Perez
<nicholasrperez at gmail.com> wrote:
> I keep stumbling all over myself with SQLite when it comes to the
> ADO.NET paradigm. This time it's a NotImplementedException on the
> GetEnumerator on the SqliteParameterCollection. Now, I wouldn't mind
> writing patches for this (I really like the idea of SQLite and use it
> frequently in perl), but I don't necessarily have the time at the
> moment. So my question is this: which provider is the most complete in
> terms of functionality of providing IDbCommands to the adapter,
> manuplating an untyped dataset and then doing an Update() and have it
> automagically work? And I guess my last restriction would be the added
> restraint of only having a mono-1.0.4 environment (the debian unstable
> packages haven't been updated to 1.0.5 last time I check).
> 
> Now I realize I might be opening some sort of floodgate into the whole
> topic, but I am just looking for something That Works (tm) and some
> simple recomendations. I am really trying to avoid doing things the
> hard way, if that makes any sense. But if the hard way is the only
> way, then I will just suck it up and work around things.
> 
> Thanks for putting up with my completely no0b questions and not
> flaming me off from the get go :)
> 
> --
> Nick
> --
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
> 


-- 
Rafael "Monoman" Teixeira
---------------------------------------
I'm trying to become a "Rosh Gadol" before my own eyes. 
See http://www.joelonsoftware.com/items/2004/12/06.html for enlightment.