Geek Answers Handbook

SQL CE 4.0 or SQL Express? Is this Orchard right?

We are going to introduce new methods for our mvc web applications, and although all our larger projects end up on SQL Server when they live, most of them start working during SQLite or SQL Express development (depending on the developer). I want to optimize Dev in a real loop, and for this reason I would like to stop SQLite and choose SQL CE 4.0 or SQL Express as a starting point. I fear SQL CE because it is not intended for ASP.NET projects (apparently), but then Orchard uses SQL CE 4.0 by default.

CE is very easy to download with new projects, but should it be used for web projects (small and dev)? There are other limitations to DBType, but does anyone have any other experience with CE 4, good or bad?

Thanks for your thoughts on this.

+5
source share
1 answer

SQL Compact Edition 4.0 is definitely suitable for ASP.NET projects! Read Scott Gu 's blog post on VS 2010 SP1 and SQL CE 4, including some walkthroughs.

SQL Server Express and SQL Server Compact are completely different animals:

  • SQL Server Express - , , ; SQL Server Compact Edition - - .

  • SQL Server CE : , , , blob (NVARCHAR(MAX), NVARBINARY(MAX)). - , ! ....

    , Entity Framework, .sdf...

+8

More articles:


All Articles