Embed database with exe file

Question

How can i embed the database with the exe file that will run properly on client machine without installing any database server? I meani will deliver my client a executable filehe will install it and enjoy it without installing any sql server.

Amit Gupta · Answer

If you don't want to install Sql Server on the client machine then you can attach your mdf file and pass that mdf path in your connection string. But I highly discourage you to avoid that you need to install Sql Server Express edition as mdf file can be understand by sql server instance. https://stackoverflow.com/questions/10366586/is-it-possible-to-access-a-mdf-database-without-sql-server Furthermore if you want to embedded database you can use Sqlite db.