private int GetMessagesCount()
{
var sql = new SqlCommandWrapper(config.SourceEventStoreConnectionString);
return(sql.ExecuteReader(@"
select count(*) as RwCnt
from MessageLog.Messages
", r => r.SafeGetInt32(0))
.FirstOrDefault());
}
private static void UpdateResourceTypeMapAsync(SqlCommandWrapper sqlCommandWrapper)
{
sqlCommandWrapper.CommandText = "SELECT ResourceTypeId, Name FROM dbo.ResourceType";
using (SqlDataReader sqlDataReader = sqlCommandWrapper.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (sqlDataReader.Read())
{
ResourceTypeIdToTypeNameMap.TryAdd((short)sqlDataReader["ResourceTypeId"], (string)sqlDataReader["Name"]);
}
}
}
private int GetEventsCount()
{
string connectionString;
using (var context = this.storeContextFactory.Invoke())
{
connectionString = context.Database.Connection.ConnectionString;
}
var sql = new SqlCommandWrapper(connectionString);
return(sql.ExecuteReader(@"
select count(*) as RwCnt
from EventStore.Events
", r => r.SafeGetInt32(0))
.FirstOrDefault());
}
protected IEnumerable <TEntity> ExecuteReader(string spName, Func <SqlDataReader, TEntity> callback, SqlParameter[] parameters = null)
{
var result = _sqlWrapper.ExecuteReader(spName, parameters, callback);
return((IEnumerable <TEntity>)result);
}
