In a simple drag and drop application, I have:
connectionString="Data Source=MIKE-VAIO;Initial Catalog=WSCGSoftware;Integ
connecting to a database (WSCGSoftware) in SQL Server 2012 Enterprise. I used "Add New Data Source" wizard to do this.
Question: How can I modify this connection string to the same database at "C:\TestFolder\WSCGSoftwar
e.mdf" on the same computer?
This application will be tested in another computer later with "C:\TestFolder\WSCGSoftwar
e.mdf" on it, but there will be no SQL Server installed on it.
If this is not possible, what if the second computer had SLQExpress installed on it.
Idealy, path "C:\TestFolder\" should be the root directory of the project itself. Some comment on it will be appreciated.
<?xml version="1.0" encoding="utf-8" ?>
connectionString="Data Source=MIKE-VAIO;Initial Catalog=WSCGSoftware;Integrated Security=True"
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0,Profile=Client" />