Is there an easy way to get the DBO and qualifier yet in DNN 4.X? Seems like it should be under DotNetNuke.Common by now... at the moment I have two functions that get these fine, but it's just rather messy.

---

Jason Honingford - Web & Software Developer
www.PortVista.com

Seems you've confirmed this is the only way. lol! This is what I use...
Edit: added the DBO function here

Public Shared Function getDBO() As String
            Dim _providerConfiguration As DotNetNuke.Framework.Providers.ProviderConfiguration = DotNetNuke.Framework.Providers.ProviderConfiguration.GetProviderConfiguration("data")

            Dim objProvider As DotNetNuke.Framework.Providers.Provider = CType(_providerConfiguration.Providers(_providerConfiguration.DefaultProvider), DotNetNuke.Framework.Providers.Provider)

            Dim _dbo As String = objProvider.Attributes("databaseOwner")

            If _dbo <> "" And _dbo.EndsWith(".") = False Then
                _dbo += "."
            End If
            getDBO = _dbo
End Function



Public Shared Function getQualifier() As String

            Dim _providerConfiguration As DotNetNuke.Framework.Providers.ProviderConfiguration = DotNetNuke.Framework.Providers.ProviderConfiguration.GetProviderConfiguration("data")

            Dim objProvider As DotNetNuke.Framework.Providers.Provider = CType(_providerConfiguration.Providers(_providerConfiguration.DefaultProvider), DotNetNuke.Framework.Providers.Provider)

            Dim _objectQualifier As String = objProvider.Attributes("objectQualifier")

            If _objectQualifier <> "" And _objectQualifier.EndsWith("_") = False Then
                _objectQualifier += "_"
            End If
            getQualifier = getDBO() & _objectQualifier
      
 End Function

---

Jason Honingford - Web & Software Developer
www.PortVista.com