.net MVC 连接数据本地数据库三种方法总结

.net MVC 连接数据本地数据库三种方法

<appSettings> <add key="webpages:Version" value="2.0.0.0" /> <add key="webpages:Enabled" value="false" /> <add key="PreserveLoginUrl" value="true" /> <add key="ClientValidationEnabled" value="true" /> <add key="UnobtrusiveJavaScriptEnabled" value="true" /> <add key="con" value="server=.sqlexpress; user id = sa;password = a123456;database = xsgl1;max pool size=512;"/></appSettings><connectionStrings> <add name="conSql" connectionString="server=（local）sqlexpress; User Id = sa;password = a123456;database = xsgl1;max pool size=512;"/></connectionStrings> Configuration

public class HomeController : Controller { // // GET: /Home/public ActionResult Index（） { #region connect sql function one SqlConnectionStringBuilder one = new SqlConnectionStringBuilder（）; one.DataSource = "（local）\sqlexpress";one.InitialCatalog = "xsgl1"; one.UserID = "sa"; one.Password = "a123456"; one.MaxPoolSize = 512; SqlConnection sct = new SqlConnection（one.ConnectionString）; #endregion #region connect sql function two //string conn = ConfigurationManager.AppSettings["con"].ToString（）; //SqlConnection sct = new SqlConnection（conn）; #endregion #region connect sql function three //string conn = ConfigurationManager.ConnectionStrings["conSql"].ConnectionString; //SqlConnection sct = new SqlConnection（conn）; #endregion SqlCommand scm = new SqlCommand（）; scm.Connection = sct;scm.CommandType = CommandType.Text; scm.CommandText = "select 课程名 from kc where 课程号="A001""; sct.Open（）; SqlDataReader sdr = scm.ExecuteReader（）; if （sdr.Read（）） {ViewBag.hao = sdr["课程名"];}sdr.Close（）;return View（）;}public ActionResult About（）{return View（）; } }Controller

@{ViewBag.Title = "Index"; } @ViewBag.hao <h2>Index</h2>