On Fri, 2003-01-17 at 00:52, Gabriel & Emily Bin wrote: > Hey, this is my first post to the Mono list! I'm totally stoked about this > project. As a recent convert from windows to Linux, I'm totally stoked > about moving our in-house apps over to run on Linux boxes. All our apps are > being re-written in C# or VB.NET. Currently all systems are running > windows, from the clients to the server. Switching the apps over to Linux > shouldn't (if the promise of Mono pans out - I'm crossing my fingers) be > that big of a deal. > > We are starting a new web app and are trying to migrate databases from SQL > Server to MySQL. I'm still a little unclear about how that might be done. I > 've come up with the following solution and was wondering if anyone with > experience in this area might help me before we write tons of code based on > a hope alone. > > This is what I've com up with: > (based on what I read at > http://lists.ximian.com/archives/public/mono-list/2003-January/004903.html) > > I could use a function whenever I needed a connection object. The key is > using System.Data.IDbConnection as an interface between the different types > of connection objects (SQL and MySQL). > > > ***** Start > Imports System.Data > Imports System.Data.SqlClient > Public Module DataLayer > Public Function BizConnection() As System.Data.SqlClient.SqlConnection > Dim dbcon As IDbConnection = New SqlConnection() > Return dbcon > End Function > End Module > ***** End > > > Then I could work with the SqlConnection just as I would at any other time. > > > ***** Start > Dim scon As SqlConnection = DataLayer.BizConnection() > ***** End > > > When we change the database we could then change the module. > > > ***** Start > Imports System > Imports System.Data > Imports System.Data.SqlClient > Imports Mono.Data.MySql > Public Module DataLayer > Shared Function BizConnection() As SqlConnection > Dim dbcon As IDbConnection = New MySqlConnection() > BizConnection = dbcon > End Function > End Module > ***** End > > Would this work? I'd test it but we can't wait around to set up a MySQL > server and get Mono running etc. > I think what you want is the data multiplexor developed by Brian, which is in the Mono.Data assembly. It contains classes to do generic connections to different data providers.
cheers -- Rodrigo Moya <[EMAIL PROTECTED]> _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
