LightSwitch Connection String

Question

0.00/5 (No votes)

See more:

Hi all experts,

I have a Lightswitch application with an Internal Database,

I now need to publish the application on this pc and all other pcs on my network so that all can connection to the same database which designed internally.

I have no idea about SQL connection strings... and I knew that my application when published it will generate the database for me, I just need all to connect to the same database on one selected pc on the network using the connection string "Data source=""; Initial ...." format.

Thanks in advance

Posted 31-Aug-14 10:51am

ehabelnahas

Add a Solution

Comments

[no name] 31-Aug-14 16:54pm

www.connectionstrings.com

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

coded007 · Answer 1 · 2014-09-01T02:01:00

Solution 1

http://social.msdn.microsoft.com/Forums/vstudio/en-US/f5ef3884-8f17-407d-9f92-e6468f078f88/lightswitch-connection-strings-confusion?forum=lightswitch[^]

Posted 1-Sep-14 2:01am

coded007

Comments

ehabelnahas 6-Sep-14 15:12pm

OK, now I downloaded SQL Server 2014 and I followed the next steps:

1- I made a SQL Server Instance named: MYSQLserver

2- I Created a database called: MyDatabase attached to MYSQLserver

3- and already I attached a new LightSwitch project to that database as an external data source, and the connection string was:

"Data Source=EHABELNAHAS-PC\MYSQLserver;Initial Catalog=MyDatabase;Integrated Security=True"

4- Everything is ok, now I'm trying to publish the application, now what is the "How do you want to publish the default database?" for?? and what should I choose from the two options?

5- Second this is Visual Studio 2013 LightSwitch Publish wizard now asks me for three connection strings:
•Is the Attached Data Sources connection string
•Is the User connection string
•Is the Publish database Schema

I put the same connection string in all connection strings "PC\MYSQLserver;Initial Catalog=MyDatabase;Integrated Security=True" but it always give the error "An exception occurred when deploying the database for the application. Couldn't deploy package"

and when double click on it, it takes me to:

<

Target Name="DeploySchema"

Condition=" '$(ExecuteSchemaDeploy)' == 'true' ">

<

DeploySchema ConnectionString="$(PublishConnectionString)"

IncludeSecurityDBObjects="true"

ServerArtifactsFolder="$(_ServerArtifactsFolder)"

Collation="$(DatabaseCollation)"

IntrinsicDacPackageFilePath="$(_IntrinsicDacPackageFilePath)"

DatabaseProject="@(_DatabaseProjectItem)"

Inputs="@(ServerMetadataFiles)"

ProjectPath="$(MSBuildProjectFullPath)"/>

Please Help