>>BTW, can you wrapper class switch between clients? In other words, it makes more sense to run SQLClient for SQL Server than IDbCommand
>
>Ok, this seems to be a better way. However, I do not have access to all namespaces. For example, if I add a reference to Microsoft.SQLServer.Management.Smo, I cannot have access to the Backup as it is not available under. There are also some namespaces that I cannot use as they do not appear in the list. For example, Microsoft.SQL Server.Management.SMO.ExecutionManager should be available. However, under Microsoft.SQL Server.Management.SMO, I do not see ExecutionManager. I wonder what causes this.
Did you add a reference to microsoft.sqlserver.smoextended.dll to your project?
I haven't tried this class myself from .NET, you may need to do a bit of research.
If it's not broken, fix it until it is.
My Blog