I want to ask you this: I have MSSQL server database table with uniqueidentifier filed types, I want to move my application from MSSQL to PostgreSQL. As you probably know, PostgreSQL doesn't support uniqueidentifiers. Does AdpSqlClient transform C# Guid data type to string or some other PostgreSQL db type automaticly?
Cheers, Aleksandar Dezelin On Fri, 25 Feb 2005 13:29:19 -0300, Everaldo Canuto <[EMAIL PROTECTED]> wrote: > Hi Aleksandar, > > > Is is using native data providers like System.Data.SqlClient, Npgsql, > > etc. or you have implemented all of them? > > Yes... Adp uses a native provider but it is "transparent" to you. If you > have another provider that are not implemented on Adp then you set your > new provider on "app.config". Additionaly Adp implements new methods > insome classes to easy development like a AdpCommand.ExecuteDataSet and > AdpCommand.ExecuteDataTable (I love this methods!). > > > I'm currently working on a project that needs a runtime changing of > > data provider so a month or two ago, I set down and tried to write > > data layer independent of the underlying database. I run into a big > > problem: didn't know how to write adapters for classes like > > SqlTransaction and similar. Ex. SqlTransaction class is sealed and > > doesn't have proper constructors to call when you want to instantiate > > an object of that type. How did you wrote them? > > Hey... my english is not good explain it, attached my AdpTransaction.cs > and AdpConnection, if you like to view all source code please download > from homepage. > > Basically I have create a class that inherits IAdpTransaction and I use > two internal fields to access native transaction class. When you call > AdpConnection.BeginTransaction then I create a AdpConnection and set > internal field to native transaction... when you call as examples > AdpTransaction.Commit then AdpTransaction redirect this call to native > transaction commit. > > If you have some questions I will be happy to help you :) > > Cheers, > Everaldo. > > -- Linux is like wighwam, no windows no gates and apache inside... _______________________________________________ Mono-devel-list mailing list [email protected] http://lists.ximian.com/mailman/listinfo/mono-devel-list
