Want to make a Invoice standalone software with sql local db

Question

I have developed an invoice software using windows forms and microsoft sql local db. In which I used dataset designer of microsoft to make a dataset. Dataset used to bind with datagrid and all the sql transactions are made through the dataset. so I cant use another datasource like sql compact datasource . Now I want to export the project as setup file and want to install on client machine without any need of sql server express. I have already tried to deploy but after installing in client machine it shows error that cannot access the database. I have installed .net 4.5 sqllocaldb.msi etc all required tools but nothing helped.... please help... I want to know how a realtime softwares are devloping with databaseI mean we only want to install setup.exe and it contain all the necessary files and run standalone a=in any machine

Kashif Sohail · Answer

SQL Server Compact facilitates you to develop the standalone applications that can be deployed easily without the need of any other database engine. You need to include SQL Server Compact Database in order to publish your application. The steps are very simple. Here is the guide for deploying application with SQL Server Compact https://msdn.microsoft.com/en-us/library/aa983326.aspx