How to create a LocalDB on Visual Studio 2013 that doesn't require SQL Server installed

Question

I want to create a project that needs Database but I dont want any db server have to be installed on both developer computer and clients.

How can I achieve this, which is the best way to do so?

Answer 1

Instead of LocalDB, use SQL Server Compact Edition. You can "bin deploy" that. Just set the references to copy local and it can run without installing anything.

See also:

• http://tech.aendeavors.com/2011/06/09/bin-deploy-sqlce-4-0-and-ef-4-1/

You can download the binaries from the Microsoft Download site. And here is an explanation on how to create a .sdf file. And the SQL Server CE Toolbox is a set of add-ons for Visual Studio that helps you manage SQL Server CE database.