Some months ago I've read an announce of Microsoft to be going to release an embedded (serverless, linked to an application as a library/assembly and using a simple file to store data) SQL Server version to replace (for those needing this, not to replace at all) SQL Server Express (full-functional but needing a separate server software to be installed) and SQL Server Compact (embedded but low-functional - without stored procedures, triggers etc.) and support all the candies like stored procedures and triggers.
But I've forgotten how was it meant to be named and ca开发者_Go百科n't find it now.
Do you know of this?
It's called LocalDB:
Introducing LocalDB, an improved SQL Express
SQL Server Compact
Note that SQL CE does not support "Procedural T-SQL" (Select Case, If, etc) or Stored procedures, views, and triggers. In other words it is "light and tight" but that comes at a price.
MS has not released an embedded SQL database that supports stored procedures.
You might have a look at VistaDB if those are your requirements.
精彩评论