public static async Task <int> InsertLogEntryAsync(this LogDbContext context, EventLog eventLog)
{
object[] parameters = InsertEventlogContextParameters(
eventLog.TimeStamp, eventLog.Level, eventLog.Logger, eventLog.Address, eventLog.MachineName, eventLog.WindowsId,
eventLog.CallerSide, eventLog.LineNumber, eventLog.ThreadId, eventLog.StackTrace,
eventLog.Message, eventLog.Exception, eventLog.Json);
return(await context.Database.ExecuteSqlCommandAsync(_uspInsertEventlogContextQuery, parameters));
}
/// <example>
/// var result = await context.GetLogEntry(11).FirstOrDefaultAsync();
/// </example>
/// <remarks>Returned object due to internal structure is not reusable.</remarks>
public static DbRawSqlQuery <EventLog> GetLogEntryQuery(this LogDbContext context, Nullable <int> id)
{
SqlParameter paramater = new SqlParameter("@id", SqlDbType.Int)
{
Value = id.Value
};
return(context.Database.SqlQuery <EventLog>("SELECT * FROM Log.fn_select_eventlog_context(@id)", paramater));
}
public static async Task <int> InsertLogEntryAsync(
this LogDbContext context, DateTime timeStamp, byte level, string logger,
string address, string machineName, string windowsId, string callerSide, int lineNumber,
int?threadId, string stackTrace, string message, string exception, string jsonObject)
{
object[] parameters = InsertEventlogContextParameters(
timeStamp, level, logger, address, machineName, windowsId, callerSide, lineNumber,
threadId, stackTrace, message, exception, jsonObject);
return(await context.Database.ExecuteSqlCommandAsync(_uspInsertEventlogContextQuery, parameters));
}
