web.Config配置文件数据库连接代码
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<connectionStrings>
<add name="SqlConn" connectionString="Data Source=.;User ID=sa;PWD=User@123;DataBase=KvdpContext" providerName="System.Data.SqlClient"/>
<clear />
<add name="Com.Gm.Kvdp.Dao.Frameworks.KvdpContextImpl" connectionString="Server=.;Database=KvdpContext;User Id=sa;Password=User@123" providerName="System.Data.SqlClient" />
</connectionStrings>
C#数据库访问层代码
public sealed partial class SqlHelper
{
#region private utility methods & constructors
// Since this class provides only static methods, make the default constructor private to prevent
// instances from being created with "new SqlHelper()"
// private SqlHelper() { }
static SqlHelper() { }
public static string ConnectionString = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString;
}
