Nico's digital footprint

I grew up in the nineties, that makes me awesome by default

SQL server CE is a life savior

by Nico

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.


Tags:

.Net | Web development

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

  Log in

About the author

Hi,

My name is Nico, I’m an MCP living in Belgium.
I’m currently employed as a consultant in the Mobile Solution Center at RealDolmen, one of Belgium’s leading IT single source providers, where I focus on Windows Phone and Windows 8 development.

I'm also founding member and board member of the Belgian Metro App Developer Network, a user group focussed on Windows 8 and Windows Phone development. If you're in Belgium feel free to drop by if we're doing an event. http://www.madn.be

Since June 2012 I'm a proud member of Microsoft's Extended Experts Team Belgium. And in February 2013 I became a member of DZone's Most Valuable Bloggers family.

This blog will be about Windows Phone 7, C#, XNA , WPF, Silverlight, and much more!

I hope to get feedback from my readers either through comments, mail (nico_vermeir@hotmail.com), twitter, facebook, …

 

 

MeetLogo

 

MVBLogo

mybook

 

mybook

 

Month List