public static Query Map(this EventMSSQLServer eventMSSQLServer)
{
if (eventMSSQLServer == null)
{
return(null);
}
return(new Query
{
TimeStamp = eventMSSQLServer.TimeStamp,
AttachActivityId = eventMSSQLServer.AttachActivityId,
EventName = eventMSSQLServer.EventName,
PackageName = eventMSSQLServer.PackageName,
ClientHn = eventMSSQLServer.ClientHn,
ClientAppName = eventMSSQLServer.ClientAppName,
NtUserName = eventMSSQLServer.NtUserName,
DatabaseId = eventMSSQLServer.DatabaseId,
DatabaseName = eventMSSQLServer.DatabaseName,
Statement = eventMSSQLServer.Statement,
Duration = eventMSSQLServer.Duration,
CpuTime = eventMSSQLServer.CpuTime,
PhysicalReads = eventMSSQLServer.PhysicalReads,
LogicalReads = eventMSSQLServer.LogicalReads,
Writes = eventMSSQLServer.Writes,
RowCount = eventMSSQLServer.RowCount,
SqlText = eventMSSQLServer.SqlText
});
}
// Отправляем параметром время
public List <EventMSSQLServer> GetNewHistoryQueriesSQLServer(string procedureName, DateTime timeToAsk)
{
List <DbParameter> parameterList = new List <DbParameter>();
List <EventMSSQLServer> EventMSSQLServers = new List <EventMSSQLServer>();
EventMSSQLServer EventMSSQLServerItem = null;
parameterList.Add(GetParameter("timeToAsk", timeToAsk));
//procedureName = "GiveRequestsOnTime"
using (DbDataReader dataReader = GetDataReader(procedureName, parameterList, CommandType.StoredProcedure))
{
if (dataReader != null && dataReader.HasRows)
{
while (dataReader.Read())
{
EventMSSQLServerItem = new EventMSSQLServer();
EventMSSQLServerItem.TimeStamp = (DateTime)dataReader["TimeStamp"];
EventMSSQLServerItem.AttachActivityId = (string)dataReader["AttachActivityId"];
EventMSSQLServerItem.EventName = (string)dataReader["EventName"];
EventMSSQLServerItem.PackageName = (string)dataReader["PackageName"];
EventMSSQLServerItem.ClientHn = (string)dataReader["ClientHn"];
EventMSSQLServerItem.ClientAppName = (string)dataReader["ClientAppName"];
EventMSSQLServerItem.NtUserName = (string)dataReader["NtUserName"];
EventMSSQLServerItem.DatabaseId = (int)dataReader["DatabaseId"];
EventMSSQLServerItem.DatabaseName = (string)dataReader["DatabaseName"];
EventMSSQLServerItem.Statement = (string)dataReader["Statement"];
EventMSSQLServerItem.Duration = (decimal)dataReader["Duration"];
EventMSSQLServerItem.CpuTime = (long)dataReader["CpuTime"];
EventMSSQLServerItem.PhysicalReads = (long)dataReader["PhysicalReads"];
EventMSSQLServerItem.LogicalReads = (long)dataReader["LogicalReads"];
EventMSSQLServerItem.Writes = (long)dataReader["Writes"];
EventMSSQLServerItem.Writes = (long)dataReader["RowCount"];
EventMSSQLServerItem.SqlText = (string)dataReader["SqlText"];
EventMSSQLServers.Add(EventMSSQLServerItem);
}
}
}
return(EventMSSQLServers);
}
