LightSwitch是否有可用的数据源？ [英] LightSwitch wth extenral Data Source?

问题描述

嗨专家，



我下载了SQL Server 2014，我按照下面的步骤操作：



1-我创建了一个名为MYSQLserver的SQL Server实例



2-我创建了一个名为：MyDatabase附加到MYSQLserver的数据库



3-并且我已将一个新的LightSwitch项目作为外部数据源附加到该数据库，连接字符串为：



数据源= EHABELNAHAS-PC\MYSQLserver;初始目录= MyDatabase;集成安全性=真



4-一切正常，现在我正在尝试发布应用程序，现在什么是你想如何发布默认数据库？对于？？我应该从这两个选项中选择什么？



5-这是Visual Studio 2013 LightSwitch Publish向导现在要求我提供三个连接字符串：

•附加数据源连接字符串

•用户连接字符串

•发布数据库架构是否为


我在所有连接字符串中放置了相同的连接字符串EHABELNAHAS-PC\MYSQLserver; Initial Catalog = MyDatabase; Integrated Security = True但它始终给出错误为应用程序部署数据库时发生异常无法部署软件包



，当双击它时，我会收到错误：



< deployschema connectionstring =$（PublishConnectionString）>

IncludeSecurityDBObjects =true

ServerArtifactsFolder =$（_ ServerArtifactsFolder）

Collat​​ion =$（DatabaseCollat​​io n）

IntrinsicDacPackageFilePath =$（_ IntrinsicDacPackageFilePath）

DatabaseProject =@（_ DatabaseProjectItem）

输入=@（ServerMetadataFiles）

ProjectPath =$（MSBuildProjectFullPath）/>



请帮助

Hi experts,

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 "EHABELNAHAS-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 the error:

<deployschema connectionstring="$(PublishConnectionString)">
IncludeSecurityDBObjects="true"
ServerArtifactsFolder="$(_ServerArtifactsFolder)"
Collation="$(DatabaseCollation)"
IntrinsicDacPackageFilePath="$(_IntrinsicDacPackageFilePath)"
DatabaseProject="@(_DatabaseProjectItem)"
Inputs="@(ServerMetadataFiles)"
ProjectPath="$(MSBuildProjectFullPath)"/>

Please Help

推荐答案

（PublishConnectionString）>

IncludeSecurityDBObjects =true

ServerArtifactsFolder =

(PublishConnectionString)">
IncludeSecurityDBObjects="true"
ServerArtifactsFolder="

（_ ServerArtifactsFolder）

Collat​​ion =

(_ServerArtifactsFolder)"
Collation="

（DatabaseCollat​​ion）

IntrinsicDacPackageFilePath =

(DatabaseCollation)"
IntrinsicDacPackageFilePath="

这篇关于LightSwitch是否有可用的数据源？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！