c# - Microsoft SQL Server 2014 数据库错误

Question

下面是我将数据添加到数据库的代码。我使用 SQL Server 2014 和 Visual Studio 社区。我在服务器中创建了一个数据库WebPageMovies。我可以在服务器资源管理器窗口中看到数据库，但在解决方案资源管理器窗口中看不到。但是在运行时，它返回一个错误

Connection string "WebPagesMovies" was not found

代码:

@{    
var title = "";
var genre = "";
var year = "";

if (IsPost)
{
    title = Request.Form["title"];
    genre = Request.Form["genre"];
    year = Request.Form["year"];

    var db = Database.Open("WebPagesMovies");
    var insertCommand = "INSERT INTO Movies (Title, Genre, Year) Values(@0, @1, @2)";
    db.Execute(insertCommand, title, genre, year);
    Response.Redirect("~/Movies");
  } 
}

Answer 1

您可以通过多种方式添加它，即在 <appSettings></appSettings> 中标记甚至在 <connectionStrings></connectionStrings> 中标签

<appSettings>
<add key="WebPagesMovies" value="your database credentials"/>
<appSettings>

或

<connectionStrings>
<add name="WebPagesMovies" connectionString="your database credentials"/>
</connectionStrings>

完成此操作后，读取您访问数据库的 .cs 文件中的连接字符串。

private  readonly SqlConnection connectionString = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["WebPagesMovies"]);

或

 private  readonly SqlConnection connectionString = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["WebPagesMovies"]);

分别取决于您添加连接字符串的位置(<Appsettings> 或 <conncetionstrings>)。