Windows form App with SQL Express

[hwdevelop]

I'm trying to create an database app using winform and sql express. In my connection string of course i know the settings. How should i code my connection strings after i release the app and install it on clients computer for multi user environment? Does anybody has a the best practice in achieving this? Can i wrap SQL Express within my winform project? Please help!

Thanks!
hans

 

[jmcilhinney]

The ConnectionString property is a dynamic property so you can store it in the config file and just set it there for each individual installation. The Visual Studio bootstrapper allows you to include SQL Express in your install I believe. Search MSDN for more info.