This article walks through the process of deploying a LightSwitch application that uses any of the RSSBus ADO.NET Data Providers to a new host.

There is a problem in deploying a LightSwitch application to another server or Web host. It does not automatically port some of the settings and dependencies needed for it to work on a machine different from the one it was developed on. If you are using a custom ADO.NET Data Provider such as our ADO.NET Data Providers, then your dlls and <system.data> config settings will not be added to the finished product. Here is what you need to do to get it to work on the new machine.

Modify the Web.config

On your local machine, there is a machine.config file where your Data Providers are registered. You will need to copy some settings from this file into your web.config file.

• Step 1: Open a window and browse to C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config.
• Step 2: Open machine.config with a text editor.
• Step 3: Search this file for the <system.data> section. It should look like this:

<system.data>
	<DbProviderFactories>
		  ...
		<add name="RSSBus QuickBooks Data Provider" .../>
		  ...
    </DbProviderFactories>
</system.data>

• Step 4: Add the full system.data section to the web.config file in your published LightSwitch application.
• Step 5: Remove all ADO.NET Data Providers that your application does not use or that come installed with Visual Studio.

Add Missing DLLs

• Step 1: In your published LightSwitch application, add any missing dll files to the bin directory. These must be .NET 4.0 dlls.
• Step 2: For example, if you are using the RSSBus QuickBooks Data Provider, you would need to add the System.Data.RSSBus.QuickBooks and System.Data.RSSBus.QuickBooks.Entities dlls. These can be found in C:\Program Files (x86)\RSSBus\RSSBus QuickBooks Data Provider\lib\4.0