ASP.NET MVC 2 Embedded Database

Question

I am building a very small temprorary website that needs a small backing store. I have built this in ASP.NET MVC 2, and wanted to host with DiscountASP - although this isn't essential.

I would like an backing store that will work with ASP.NET MVC 2, VS2010 Express, enabled LINQ (or EF) and work without further charges on a shared host.

From my investigation, SQLCE 3.5 doesn't work in .NET 4 SQLCE 4, is only CTP and doesn't work in VS2010 SQlite doesn't have any .NET 4.0 drivers.

HAve I got this right? Any good tutorials or blogs that show how to get this working step by step?

Thanks, Mark

Answer 1

SQLite does work on .Net 4.0. Here are some other very similar questions about embedded databases in .NET:

• Good embedded database solution (like SQLite) for .Net
• Embedded database for .net
• Open Source Embedded Database Options for .Net Applications