230问答网 > c#中三层架构的Framework(DAL)层与数据库连接的代码是什么？

c#中三层架构的Framework(DAL)层与数据库连接的代码是什么？

2025-01-25 05:16:09

推荐回答（4个）

回答1：

然后在代码里使用
//创建Database对象
Database db = DatabaseFactory.CreateDatabase();
//创建DbCommand对象
DbCommand dbCommand = db.GetStoredProcCommand("UP_APKeyHistory_Query");
//添加输入输出参数
db.AddInParameter(dbCommand, "@APID", DbType.String, apq.APID);
db.AddInParameter(dbCommand, "@CommunicationKey", DbType.String, apq.CommunicationKey);
db.AddInParameter(dbCommand, "@MaxEffectiveTime", DbType.DateTime, apq.MaxEffectiveTime);
db.AddInParameter(dbCommand, "@MinEffectiveTime", DbType.DateTime, apq.MinEffectiveTime);
db.AddInParameter(dbCommand, "@MaxExpiredTime", DbType.String, apq.MaxExpiredTime);
db.AddInParameter(dbCommand, "@MinExpiredTime", DbType.String, apq.MinExpiredTime);
db.AddInParameter(dbCommand, "@KeyStatus", DbType.String, apq.KeyStatus);

List APKeyList = new List();
//执行命令返回DataReader对象
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
while (dr.Read())
{
APKeyList.Add(CreateAPKeyHistoryInfo(dr));
}
}
return APKeyList;

回答2：

强烈建议使用微软企业库，而不要用什么SqlHelper之类的东东，在引用了Microsoft.Practices.EnterpriseLibrary.Data.dll和Microsoft.Practices.EnterpriseLibrary.Common.dll后，在webconfig里面配置节点

name="dataConfiguration"
type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings,
Microsoft.Practices.EnterpriseLibrary.Data,
Version=4.1.0.0,
Culture=neutral"
/>

defaultDatabase="KDSWDBConnection"
/>

name="KDSWDBConnection"
connectionString="server=10.192.56.112;
user
id=sa;
password
=sa;
database
=KDSW"
providerName="System.Data.SqlClient"
/>

然后在代码里使用
//创建Database对象
Database
db
=
DatabaseFactory.CreateDatabase();
//创建DbCommand对象
DbCommand
dbCommand
=
db.GetStoredProcCommand("UP_APKeyHistory_Query");
//添加输入输出参数
db.AddInParameter(dbCommand,
"@APID",
DbType.String,
apq.APID);
db.AddInParameter(dbCommand,
"@CommunicationKey",
DbType.String,
apq.CommunicationKey);
db.AddInParameter(dbCommand,
"@MaxEffectiveTime",
DbType.DateTime,
apq.MaxEffectiveTime);
db.AddInParameter(dbCommand,
"@MinEffectiveTime",
DbType.DateTime,
apq.MinEffectiveTime);
db.AddInParameter(dbCommand,
"@MaxExpiredTime",
DbType.String,
apq.MaxExpiredTime);
db.AddInParameter(dbCommand,
"@MinExpiredTime",
DbType.String,
apq.MinExpiredTime);
db.AddInParameter(dbCommand,
"@KeyStatus",
DbType.String,
apq.KeyStatus);
List
APKeyList
=
new
List();
//执行命令返回DataReader对象
using
(IDataReader
dr
=
db.ExecuteReader(dbCommand))
{
while
(dr.Read())
{
APKeyList.Add(CreateAPKeyHistoryInfo(dr));
}
}
return
APKeyList;

回答3：

webconfig里面

string connectionString = ConfigurationManager.AppSettings[configName];

回答4：

写在webconfig里面