System.ArgumentException："不支持关键字："数据源"。

Question

我一直收到这个错误，并试图删除数据源，但这给了我另一个错误，还试图添加另一个连接字符串，但也不起作用。我该如何解决这个问题？https://ibb.co/4sVbnZt

DbsCarEntities1 dbs = new DbsCarEntities1();
string maincon = ConfigurationManager.ConnectionStrings["DbsCarEntities1"].ConnectionString;
public ActionResult Admin1()
{
return View();
}
[HttpPost]
public ActionResult Admin1(Admin x)
{
string maincon = ConfigurationManager.ConnectionStrings["DbsCarEntities1"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(maincon);
string sqlquery = "select UserName,Password from [dbo].[Admin] where UserName=@UserName and Password=@Password";
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand(sqlquery, sqlcon);
sqlcom.Parameters.AddWithValue("@UserName", x.UserName);
sqlcom.Parameters.AddWithValue("@Password", x.Password);
SqlDataReader sdr = sqlcom.ExecuteReader();
if (sdr.Read())
{
Session["UserName"] = x.UserName.ToString();
return RedirectToAction("Main2");
}
else
{
ViewData["Message"] = "Admin Login Details Does NOT match our data records!";
}
sqlcon.Close();
return View();
}

public ActionResult Main2()
{
return View(dbs.Cars.ToList());
}

Answer 1

您必须在连接中将提供程序名称从System.Data.EntityClient更改为System.Data.SqlClient。我认为这会解决你的问题。

<add name="DbsCarEntities1" 
connectionString="Data Source=(LocalDB)MSSQLLocalDB;
AttachDbFilename=C:UsershamzasourcereposCarSaleProjectUsingMVCandDataBaseCarSaleProjectUsingMVCandDataBaseApp_DataDbsCar.mdf;Integrated Security=True;" providerName="System.Data.SqlClient" />