Asp.Net MVC数据库连接_MVC连接本地SQL数据库的三种方法

在平时工作中 MVC 肯定是经常使用到的、那么普遍的项目都是需要数据库的、自然连接数据库就成了必不可少的功课了、今天就给大家分享3种在 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> 

Controller代码

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();
    }
}

View代码

@{
    ViewBag.Title = "Index";
}

@ViewBag.hao
<h2>Index</h2>