1. Copying Web folders
2. Copying DLL files
C:\Program Files (x86) \microsoft Asp.net\asp.net Web Pages\v1.0\assemblies
C:\Program Files (x86) \microsoft Asp.net\asp.net MVC 3\assemblies
3. Copy the SQL Server Compact DLL file
C:\Program Files (x86) \microsoft SQL Server Compact edition\v4.0\private
4. Create or edit the Web. config file in the application:
<?xml version= "1.0" encoding= "UTF-8"?>
<configuration>
<system.data>
<DbProviderFactories>
<remove invariant= "system.data.sqlserverce.4.0"/>
<add invariant= "system.data.sqlserverce.4.0"
Name= "Microsoft SQL Server Compact 4.0"
Description= ". NET Framework Data Provider for Microsoft SQL Server Compact"
Type= "System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe,
Version=4.0.0.1,culture=neutral, publickeytoken=89845dcd8080cc91 "/>
</DbProviderFactories>
</system.data>
</configuration>
5. Replicating SQL Server Compact data
NET Publishing MVC projects