public void TestSimpleRegistry()
{
string spName = "GetUserInfo"; // 存储过程名称
DbParameterRegistry registry = new DbParameterRegistry(spName);
registry["@ID"] = DbType.Int32;
registry["@Title"] = DbType.String;
Assert.IsTrue(registry.ContainsKey("@ID"));
Assert.IsFalse(registry.ContainsKey("@Unknown"));
Assert.AreEqual <DbType>(DbType.String, registry["@Title"]);
}
private static DbParameterRegistry DiscoverDbParameters(DbCommand command)
{
// 访问数据库并获得command指定存储的相关DbParameter[]的类型信息
// 更新参数注册表
string key = CreateRegistryKey(command);
DbParameterRegistry registry = new DbParameterRegistry(key);
foreach (DbParameter parameter in command.Parameters)
{
registry[parameter.ParameterName] = parameter.DbType;
}
registries.Add(key, registry);
return(registry);
}
