.net MVC怎么连接数据本地数据库

　　.net MVC怎么连接数据本地数据库?.net MVC连接数据本地数据库编程介绍。金顺软件园的小编告诉你.net MVC怎么连接数据本地数据库吧。更多最新IT资讯尽在金顺软件园http://www.jinshun168.com/

　　第一种：

  <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>

   金顺软件园小编推荐：

   随手记怎样备份恢复数据

   随手记数据怎么清空

以上，就是金顺软件园小编给大家带来的.net MVC怎么连接数据本地数据库全部内容，希望对大家有所帮助！