How to run desktop application with database locally without installing any database Server?

Question

I wanted to create a desktop application with database, am using Visual Studio 2013 and C# , Can anybody suggest me what server I used to create my database, in order to run my application in my client's system locally with out installing any database server in client's system [ie, with out installing MsSql server or MySql server or Acess], I want my app works properly when installing my own application's exe file ?

And Now am using MSSQL server with my application , Is there any way run this application in client's system locally with out installing MSSQL Server? [my application front end works when I install .Net FrameWork 4.5 , I need something like this for my .mdf databse in Sql Server]

somebody says about SQL Server Compact ,but i don't know how to use it

Answer 1

You can use SQL Server Compact, which can either be installed separately or deployed as part of your application.

See here: How to deploy SQL Server Compact Edition 4.0?

And here: https://msdn.microsoft.com/en-gb/library/aa983326(v=vs.110).aspx

Your DB code in your app - apart from your connection string - should not need to change as you're already using some version of SQL Server.

There is also SQLite, which is as far as I know is well regarded, but I know very little about it. http://www.sqlite.org/

Hope that helps!