private DataSet SelectIdentity()
{
DBCommandWrapper cmd = userDb.GetSqlStringCommandWrapper("select * from Users where UserName = @name");
cmd.AddInParameter("name", DbType.String, userName);
return(userDb.ExecuteDataSet(cmd));
}
/// <summary>
/// Loads data from persistence store.
/// </summary>
/// <returns>Unfiltered hashtable of cache items loaded from persistence store.</returns>
protected override Hashtable LoadDataFromStore()
{
DBCommandWrapper loadDataCommand = database.GetStoredProcCommandWrapper("LoadItems");
loadDataCommand.AddInParameter("@partitionName", DbType.String, partitionName);
DataSet dataToLoad = database.ExecuteDataSet(loadDataCommand);
Hashtable dataToReturn = new Hashtable();
foreach (DataRow row in dataToLoad.Tables[0].Rows)
{
CacheItem cacheItem = CreateCacheItem(row);
dataToReturn.Add(cacheItem.Key, cacheItem);
}
return(dataToReturn);
}
public void LogToLoggingDatabase()
{
Data.Database loggingDb = DatabaseFactory.CreateDatabase("LoggingDb");
string sql = "delete [Log]";
DBCommandWrapper cmd = loggingDb.GetSqlStringCommandWrapper(sql);
loggingDb.ExecuteNonQuery(cmd);
Logger.Write("test message", "LoggingDbCategory");
sql = "select * from [Log]";
cmd = loggingDb.GetSqlStringCommandWrapper(sql);
DataSet ds = loggingDb.ExecuteDataSet(cmd);
Assert.AreEqual(1, ds.Tables[0].Rows.Count);
}