谁能提供EnterpriseLibrary June 2005 里 DAAB ParameterCache的用法实例！！

[nutpp]

一直没有找到使用的方法，文档里好像也没有

[yanlixin4csdn]

不是带 Quickstart 吗?
不够该不会是让我把 Quickstart 发给你吧.
Quickstart讲的已经可以了.还要什么例子?

///*************************///
这两年来慢慢习惯了光说不练
///*************************///

[yanlixin4csdn]

TestCache testCache = new TestCache();
testCache.FillParameters(storedProcedure, ':');

DBCommandWrapper storedProcDuplicate = db.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI", null);
storedProcDuplicate.Command.Connection = connection;
testCache.FillParameters(storedProcDuplicate, ':');

Assert.IsTrue(testCache.CacheUsed, "Cache is not used");

///*************************///
这两年来慢慢习惯了光说不练
///*************************///

[nutpp]

拜托！如果Quickstart里有，我还发什么帖子？

[yanlixin4csdn]

public void CanGetParametersForStoredProcedure()
{
cache.FillParameters(storedProcedure, '@');
Assert.AreEqual(2, storedProcedure.Command.Parameters.Count);
Assert.AreEqual("@RETURN_VALUE", ((IDataParameter)storedProcedure.Command.Parameters["@RETURN_VALUE"]).ParameterName);
Assert.AreEqual("@CustomerID", ((IDataParameter)storedProcedure.Command.Parameters["@CustomerId"]).ParameterName);
}

///*************************///
这两年来慢慢习惯了光说不练
///*************************///

[yanlixin4csdn]

源代码里代的单元测试是很好的例子.

///*************************///
这两年来慢慢习惯了光说不练
///*************************///

[yanlixin4csdn]

我感觉我贴的还是不够细.:-)


//===============================================================================
// Microsoft patterns & practices Enterprise Library
// Data Access Application Block
//===============================================================================
// Copyright ?Microsoft Corporation. All rights reserved.
// THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY
// OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT
// LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
// FITNESS FOR A PARTICULAR PURPOSE.
//===============================================================================

#if UNIT_TESTS
using System;
using System.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Tests;
using NUnit.Framework;

namespace Microsoft.Practices.EnterpriseLibrary.Data.Sql.Tests
{
[TestFixture]
public class SqlParameterDiscoveryFixture : ParameterDiscoveryFixture
{
[SetUp]
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
this.db = factory.CreateDefaultDatabase();
storedProcedure = db.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
connection = db.GetConnection();
connection.Open();
storedProcedure.Command.Connection = connection;
cache = new ParameterCache();
}

[Test]
public void CanGetParametersForStoredProcedure()
{
cache.FillParameters(storedProcedure, '@');
Assert.AreEqual(2, storedProcedure.Command.Parameters.Count);
Assert.AreEqual("@RETURN_VALUE", ((IDataParameter)storedProcedure.Command.Parameters["@RETURN_VALUE"]).ParameterName);
Assert.AreEqual("@CustomerID", ((IDataParameter)storedProcedure.Command.Parameters["@CustomerId"]).ParameterName);
}

[Test]
public void UseParameterCachingWithPersistSecurityInfoFalse()
{
try
{
DeleteUser();
CreateUser();

DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
Database dbsec = factory.CreateDatabase("NorthwindPersistFalse");
connection = dbsec.GetConnection();
connection.Open();

DBCommandWrapper storedProc1 = dbsec.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
storedProc1.Command.Connection = connection;
TestCache testCache = new TestCache();
testCache.FillParameters(storedProc1, '@');

DBCommandWrapper storedProc2 = dbsec.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
storedProc2.Command.Connection = connection;
testCache.FillParameters(storedProc2, '@');

Assert.IsTrue(testCache.CacheUsed);
}
finally
{
DeleteUser();
}

}

private void CreateUser()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
Database adminDb = factory.CreateDefaultDatabase();
connection = adminDb.GetConnection();
connection.Open();
string query;
DBCommandWrapper addUser;
try
{
query = string.Format("exec sp_addlogin '{0}', '{1}', 'Northwind'", TestConfigurationContext.NorthwindDummyUser, TestConfigurationContext.NorthwindDummyPassword);
addUser = adminDb.GetSqlStringCommandWrapper(query);
adminDb.ExecuteNonQuery(addUser);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
try
{
query = string.Format("exec sp_grantdbaccess '{0}', '{0}'", TestConfigurationContext.NorthwindDummyUser);
addUser = adminDb.GetSqlStringCommandWrapper(query);
adminDb.ExecuteNonQuery(addUser);
}
catch
{
}
try
{
query = string.Format("exec sp_addrolemember N'db_owner', N'{0}'", TestConfigurationContext.NorthwindDummyUser);
addUser = adminDb.GetSqlStringCommandWrapper(query);
adminDb.ExecuteNonQuery(addUser);
}
catch
{
}
}

private void DeleteUser()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
Database adminDb = factory.CreateDefaultDatabase();
connection = adminDb.GetConnection();
connection.Open();
string query;
DBCommandWrapper dropUser;
try
{
query = string.Format("exec sp_revokedbaccess '{0}'", TestConfigurationContext.NorthwindDummyUser);
dropUser = adminDb.GetSqlStringCommandWrapper(query);
adminDb.ExecuteNonQuery(dropUser);
}
catch
{
}
try
{
query = string.Format("exec sp_droplogin '{0}'", TestConfigurationContext.NorthwindDummyUser);
dropUser = adminDb.GetSqlStringCommandWrapper(query);
adminDb.ExecuteNonQuery(dropUser);
}
catch
{
}
}

[Test]
public void IsCacheUsed()
{
TestCache testCache = new TestCache();
testCache.FillParameters(storedProcedure, '@');

DBCommandWrapper storedProcDuplicate = db.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
storedProcDuplicate.Command.Connection = connection;
testCache.FillParameters(storedProcDuplicate, '@');

Assert.IsTrue(testCache.CacheUsed, "Cache is not used");
}

[Test]
public void CanDiscoverFeaturesWhileInsideTransaction()
{
using (IDbConnection connection = db.GetConnection())
{
connection.Open();
IDbTransaction transaction = connection.BeginTransaction();
DBCommandWrapper storedProcedure = db.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
storedProcedure.Command.Connection = transaction.Connection;
storedProcedure.Command.Transaction = transaction;

storedProcedure.DiscoverParameters('@');

Assert.AreEqual(2, storedProcedure.Command.Parameters.Count);
}
}
}
}

#endif




///*************************///
这两年来慢慢习惯了光说不练
///*************************///