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