[Mono-list] portable SQL
Rodrigo Moya
rodrigo@ximian.com
22 Oct 2002 02:35:50 +0200
On Mon, 2002-10-21 at 17:23, Tim Terlegård wrote:
> Coding SQL for multiple vendors is not that cool. One have
> to write every SQL statement twice or more. If one all of a
> sudden wants to support another rdbms vendor, one will have
> some work to do. So portable SQL would be nice...
>
> My understanding is that ADO.NET doesn't provide any
> facility for portable SQL, is that correct? Are there any plans
> for Mono to provide som sort of object oriented api one could
> use that builds native SQL statements?
>
libgda (http://www.gnome-db.org) already tries to hide SQL as much as
possible, and as there are C# bindings for it as part of the GTK#
project, I guess that's one way you've got.
Another possibility would be to add extra classes in Mono.Data to hide
the SQL differences. There are no plans for this so far, but of course,
we're open to any discussion/contribution.
cheers
--
Rodrigo Moya <rodrigo@ximian.com>