I have a framework. This is used in all Web applications, Windows Services and Web Services. Each of those applications has their own DLL. So, basically, I have Framework.dll and MyApplication.dll.
In the framework, I have four references to SQL Server libraries:
Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.Smo
Microsoft.SqlServer.SmoExtended
This is for scripting usage and things like that.
The current version of those is 10.0.0.0.
On one location, I have SQL Server 2008 on Windows Server 2003 and on another SQL Server 2012 on Windows Server 2008.
Because Windows Server 2003 is on a 32-bit platform, I cannot install the following libraries as those are restricted to 64-bit platform:
Microsoft SQL Server 2012 Shared Management Objects x64
Microsoft System CLR Types for Microsoft SQL Server System 2012 x64
So, this causes a problem. It is like I would need to maintain two versions of the framework because I still need to support 32-bit OS as this requires the old files.
Anyone would have a suggestion on keeping one framework project where I wouldn't need to worry about this issue?
So far, I have no choice but to put back references to 10.0.0.0 files so it would work on all platforms.