#Region "Shared/Static Methods"

  ' singleton reference to the instantiated object
        Private Shared objProvider As DataProvider = Nothing

  ' constructor
        Shared Sub New()
            CreateProvider()
        End Sub

        ' dynamically create provider
        Private Shared Sub CreateProvider()
            objProvider = CType(Framework.Reflection.CreateObject("data"), DataProvider)
        End Sub

        ' return the provider
        Public Shared Shadows Function Instance(Optional ByVal DataConnection As String = "data") As DataProvider
            If DataConnection <> "data" Then
                objProvider = CType(Framework.Reflection.CreateObject(DataConnection), DataProvider)
            End If
            Return objProvider
        End Function

#End Region

Now it all compiles and everything seems to work so far but not sure if this is the best way to do this

So to use this I would add a connection string to my web.config for my other database

then if I was using the DAL+ methods (should work with the traditional DAL) I would do something like :

   Using dr As IDataReader = DotNetNuke.Data.DataProvider.Instance("newConnectionString").ExecuteReader("Codegalaxy_DNN_Classifieds_Admin_GetAllMainCategories")

then all data from stored proc "Codegalaxy_DNN_Classifieds_Admin_GetAllMainCategories" would come from database defined in the "newConnectionString" connection

- I dont see anything wrong with this small hack.

Can anybody maybe comment on what impact this might have

PS - I know I can use normal data access methods to get to other databases  but using DNNs DAL this makes the whole project cleaner and more easily documented and followed by future developers