SQL Server Compact 4.0

Has anyone every tried and got Sitefinity 5 or 6 to work with SQL Server Compact Framework 4.0??
If yes what are the steps please?

Hello Anders,

I'm quoting the reply in this thread:

thanks. I had already seen that post but there is a dearth on this issue in sitefinity forums and the google and all did not help getting past the provider error.

Hi Anders,

It seems there's a reason for you not finding too much information about SQL CE. I've been digging into the topic. I am at the stage of converting my project's MDF database to a SQL CE SDF. After searching on howto-s for that I've found that there's a SQL Server Compact toolbox plugin for Visual Studio, which I'm now downloading and trying out. I will update this thread with the results.

Next steps are setting up the project to work with SQL CE and trying it out.

I'll keep you posted.

*Update:

I tried converting my MDF database several times. It fails if I try to use the MDF file directly. I get further if I attach the database in my SQL server first. However, the conversion fails at some point with this error:


This is not a Sitefinity error, but one related to the conversion. I'll circulate this internally to see if any of the DB gurus on the team has any tips for us. You can try it on your end and post if you had success or the same issue as well.

Regards,
Grisha 'Greg' Karanikolov
Telerik

you need this latest version 11 August 2013 from here visualstudiogallery.msdn.microsoft.com/.../

It has an "export sql server to sql server compact 4.0..." menu option
thats what i used still no joy though ( it convert the mdb to sdf ok) on the sitefinity side.

Can you confirm this is the correct string for compact 4.0
<connectionStrings>
    <add connectionString="data source=|DataDirectory|\sitefinity.sdf" providerName="System.Data.SqlServerCe.4.0" dbType="SqlCE" name="Sitefinity" />
       
    </connectionStrings>

in Dataconfig.config

Error  I getting is below may be this will help your end.
The current type, Telerik.Sitefinity.Model.IDatabaseMappingContext, is an interface and cannot be constructed. Are you missing a type mapping?Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: The current type, Telerik.Sitefinity.Model.IDatabaseMappingContext, is an interface and cannot be constructed. Are you missing a type mapping?

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: 

[InvalidOperationException: The current type, Telerik.Sitefinity.Model.IDatabaseMappingContext, is an interface and cannot be constructed. Are you missing a type mapping?]
Telerik.Microsoft.Practices.ObjectBuilder2.DynamicMethodConstructorStrategy.ThrowForAttemptingToConstructInterface(IBuilderContext context) +286
BuildUp_Telerik.Sitefinity.Model.IDatabaseMappingContext(IBuilderContext ) +74
Telerik.Microsoft.Practices.ObjectBuilder2.DynamicMethodBuildPlan.BuildUp(IBuilderContext context) +42
Telerik.Microsoft.Practices.ObjectBuilder2.BuildPlanStrategy.PreBuildUp(IBuilderContext context) +319
Telerik.Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context) +260
Telerik.Microsoft.Practices.Unity.UnityContainer.DoBuildUp(Type t, Object existing, String name, IEnumerable`1 resolverOverrides) +373

[ResolutionFailedException: Resolution of the dependency failed, type = "Telerik.Sitefinity.Model.IDatabaseMappingContext", name = "SqlCE".
Exception occurred while: while resolving.
Exception is: InvalidOperationException - The current type, Telerik.Sitefinity.Model.IDatabaseMappingContext, is an interface and cannot be constructed. Are you missing a type mapping?
-----------------------------------------------
At the time of the exception, the container was:

Resolving Telerik.Sitefinity.Model.IDatabaseMappingContext,SqlCE
]

That's the one I used,
anyway, since you've managed to convert your DB successfully, would you like to upload your project and the .sdf database to an FTP account I've set up for you, so that I can try attaching the database?

I'm sending you the FTP details separately in an e-mail.

Regards,
Grisha 'Greg' Karanikolov
Telerik

Super I was thinking of doing that but did not want to publish
my pages.

I will emai when done upload say 15mins or so after receiving
the ftp or do you prefer I send you a Dropbox link on the private email

I think its quicker.

Whatever's more convenient for you, Anders!


Regards,
Grisha 'Greg' Karanikolov
Telerik

have not received the private email yet

email with sdf file sent

ANy luck on your side?

Hi Anders,

The current type, Telerik.Sitefinity.Model.IDatabaseMappingContext, is an interface and cannot be constructed. Are you missing a type mapping?

Thanks for the effort. Thats exactly where I am. I hope you guys can fix this.

Hi Anders,

Did further digging into this and spoke to one of the DB gurus on our team. Apparently they tried hooking Sitefinity to SQL CE some time ago, but hit some limitations in the database engines when working with our fluent mappings. That's the reason we've not listed SQL server compact as a supported DB engine.

This is the status so far, unfortunately. If there are any changes, we will announce it publicly and I will update this thread.

Anders, could you give me your current use case so that I can use it in our internal feature request logging system?

Regards,
Grisha 'Greg' Karanikolov
Telerik

Thanks for your effort.
I was trying to use sitefinity on my current hoster which does not provide SQL Server on its standard plan. Ie. you have to pay an additional 10USD a month for SQL Server.
I am now looking at the recommended hosters esp Arvixe.