Are there any examples out there using Massive with SQL Server Compact 4.0?
I have seen many examples with SQL Express but not with CE.
I am having issues with my configuration (connection string / provider) and would like to see some examples.
Update:
I was able to get an example working with SQL Server 2008 but not Compact 4.0.
This is the Compact 4.0 connection string:
<add name="MassiveSpike"
connectionString="Data Source=MassiveSpikeDb.sdf;"
providerName="System.Data.SqlServerCe.4.0"
/>
Any ideas?
Final Update
I tweaked the code in Massive to use a connection string provider if one is defined:
var _providerName = "System.Data.SqlClient";
if(ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName != null)
_providerName = ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName;
I used the standard Massive file, but I had to change the provider name on line 148 (about) to:
After that everything worked.