I seek assistance in this challenges I have at the moment.
I have an application that currently connect to a SQL Database well on my PC and sure it will do same if I deploy it to a PC that has SQL server install on it.
Now I dont want to install SQL server on the other PC where the application will be used,
1. which database file (.mdf or .sdf) will I use
2. how will I create a .sdf file if thats the solution and ensure it works well at development level
3. how will I attach it to my application at development and deployment level
A step by step instruction will be appreciated.