sql server ce is a life savior

Update

So the conversion to MVC3 is about done, I've uploaded the first testversion to http://www.huizedegraef.be/test and so far it's working fine.
The next step is to get the admin panel up and running, stay tuned!

Original

So the conversion of the Huize De Graef project from asp.net webforms to MVC3 is going really well.
A first testversion ran fine on my local test server using the trust configuration of the webhost (thank you SoHosted for providing the file) but unfortunatly once uploaded Entity Framework wouldn't connect to the MySQL DB, always giving security errors.

After spending 2 days researching and mailing with the SoHosted support team still no solution. At Techdays 2011 I heard something about SQL Server compact edition, a Microsoft SQL solution that didn't require an installation. A quick test indeed proved that MVC3 apps using EF and SQL CE work perfectly on the webhost.

So currently I'm converting the MySQL to SQL CE, I'm hoping to have it online by the end of the week.

This is an imported post. It was imported from my old blog using an automated tool and may contain formatting errors and/or broken images.

Leave a Comment