首页 \ 问答 \ 如何使用相同的数据源发布多个Lightswitch HTML项目(How to publish multiple Lightswitch HTML projects using the same data source)

如何使用相同的数据源发布多个Lightswitch HTML项目(How to publish multiple Lightswitch HTML projects using the same data source)

我在2012 Server上使用IIS 8.5，在同一台机器上使用Visual Studio和SQL Server。
我已经构建并发布了一个Lightswitch HTML客户端，它在Web浏览器中运行良好。 它是一个内部应用程序，可以在http：// servername / htmlclient上的域计算机上访问/工作。 这是Lightswitch发布HTML内容的默认位置。
我还构建了第二个LS HTML项目。 它完全独立但使用相同的SQL数据源。 我似乎无法成功地将这个项目发布到网上。 老实说，我不确定它是否是一个Visual Studio / Lightswitch问题，一个IIS问题...我有点迷失为什么它不能“正常工作”，就像我发布的第一个应用程序一样。 即使考虑到我在尝试发布时遇到的错误，我也不确定如何解决问题。
对于新项目生成web.config文件似乎存在问题，或者可能与使用相同数据源的两个项目有关。 这是我在尝试在Web浏览器中查看第二个项目的内容时遇到的错误...
错误页面

I am using IIS 8.5 on a 2012 Server, with Visual Studio and SQL Server on the same machine.
I have built and published one Lightswitch HTML Client, and it is working fine from web browsers. It is an internal application and is accessible/working on domain computers at http://servername/htmlclient. This is the default location where Lightswitch publishes the HTML content.
I have also built a second LS HTML project. It is completely separate but uses the same SQL data source. I cannot seem to successfully publish this project to the web, at all. I am honestly not sure if it is a Visual Studio/Lightswitch issue, an IIS issue... I am kind of lost as to why it doesn't 'just work', like the first application I published. Even given the error I am seeing when I try to publish, I am not sure how to fix the issue.
It appears to be a problem with generating a web.config file for the new project, or maybe something to do with both projects using the same data source. This is the error I get when trying to view the content of the second project in a web browser...
Error page

原文：https://stackoverflow.com/questions/34291912

更新时间：2021-09-21 07:09

最满意答案

 在第一个代码示例中，每次迭代都会创建一个新的SqlCommand ：  
SqlCommand command = new SqlCommand(insertQuery, connection);
 
 在第二个中，所有迭代都修改相同的命令，添加越来越多的参数。 只有第一个调用具有正确数量的参数，下一个调用具有太多参数。  
 在没有值的循环之前添加参数，然后在循环中设置值并执行命令  
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertBets";

command.Parameters.Add("@FixtureId", SqlDbType.Int);
// add the other paramters

foreach (Bet bet in bets)
{
    command.Parameters["@FixtureId"].Value = bet.FixtureId;
    // set the other parameters
    command.ExecuteNonQuery();
}

In the first code sample a new SqlCommand is created in every iteration: 
SqlCommand command = new SqlCommand(insertQuery, connection);
 
In the 2nd one, all iterations modify the same command, adding more and more parameters. Only the first call will have the correct number of parameters, the next ones have too many. 
Add the parameters before the loop without values, then in the loop set the values and execute the command 
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertBets";

command.Parameters.Add("@FixtureId", SqlDbType.Int);
// add the other paramters

foreach (Bet bet in bets)
{
    command.Parameters["@FixtureId"].Value = bet.FixtureId;
    // set the other parameters
    command.ExecuteNonQuery();
}

如何使用相同的数据源发布多个Lightswitch HTML项目(How to publish multiple Lightswitch HTML projects using the same data source)

最满意答案

相关问答

为什么foreach循环不适用于C＃中的datagridview选定行？(Why foreach loop does not work with datagridview selected rows in C#?)[2022-11-11]

只有foreach循环中的第一个存储过程才有效，但内联查询会是什么？(Only the first stored procedure in foreach loop will work, but an inline query will? C#)[2024-01-22]

内联查询和存储过程的相同查询的不同执行(Different execution of the same query for Inline query and a stored procedure)[2021-06-12]

C＃ - 循环foreach直到真(C# - Loop foreach until true)[2023-01-20]

在c＃中使用存储过程(Use stored procedure in c# ef)[2023-11-10]

存储过程循环(Stored Procedure Loop)[2022-12-09]

实体框架在循环中执行存储过程(Entity Framework execute stored procedure in a loop)[2021-12-04]

在foreach循环中使用sql查询进行foreach循环(foreach loop with sql query in foreach loop)[2023-07-28]

C＃运行临时存储过程(C# running temporary stored procedure)[2022-03-21]

MySQL存储过程循环问题(MySQL Stored Procedure Loop Problem)[2022-06-28]

相关文章

最新问答