public void SaveLog(LogEntry logEntry)
{
DbConnection connection = DbConnectionProvider.GetDbConnection(ActiveAppEnvironment.GetConfig(AppEnvironment.KeyValues.Data.LogDbConnectionstring, defaultValueOnNotFoundProvider: () => ActiveAppEnvironment.GetConfig <string>("AppConnectionstring")), rollbackOnScopeStatusFailure: false);
using (DbCommand command = connection.CreateCommand())
{
command.Transaction = DbConnectionProvider.GetDbTransaction(connection);
command.CommandText = @"INSERT INTO [dbo].[Logs] ([Contents]) VALUES (@contents)";
command.AddParameterWithValue("@contents", Formatter.Serialize(logEntry.ToDictionary()));
command.ExecuteNonQuery();
}
}
public virtual async Task SaveLogAsync(LogEntry logEntry)
{
using (SqlConnection connection = new SqlConnection(ActiveAppEnvironment.GetConfig <string>("AppConnectionstring")))
{
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = @"INSERT INTO [dbo].[Logs] ([Contents]) VALUES (@contents)";
command.Parameters.AddWithValue("@contents", Formatter.Serialize(logEntry));
await connection.OpenAsync().ConfigureAwait(false);
await command.ExecuteNonQueryAsync().ConfigureAwait(false);
}
}
}
public void SaveLog(LogEntry logEntry)
{
using (SqlConnection connection = new SqlConnection(ActiveAppEnvironment.GetConfig("LogDbConnectionstring", defaultValueOnNotFoundProvider: () => ActiveAppEnvironment.GetConfig <string>("AppConnectionstring"))))
{
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = @"INSERT INTO [dbo].[Logs] ([Contents]) VALUES (@contents)";
command.Parameters.AddWithValue("@contents", Formatter.Serialize(logEntry.ToDictionary()));
connection.Open();
command.ExecuteNonQuery();
}
}
}
public virtual async Task SaveLogAsync(LogEntry logEntry)
{
if (logEntry == null)
{
throw new ArgumentNullException(nameof(logEntry));
}
DbConnection connection = await DbConnectionProvider.GetDbConnectionAsync(ActiveAppEnvironment.GetConfig(AppEnvironment.KeyValues.Data.LogDbConnectionstring, defaultValueOnNotFoundProvider : () => ActiveAppEnvironment.GetConfig <string>("AppConnectionstring")) ?? throw new InvalidOperationException($"{nameof(AppEnvironment.KeyValues.Data.LogDbConnectionstring)} is null."), rollbackOnScopeStatusFailure : false, cancellationToken : CancellationToken.None).ConfigureAwait(false);
await using (DbCommand command = connection.CreateCommand())
{
command.Transaction = DbConnectionProvider.GetDbTransaction(connection);
command.CommandText = @"INSERT INTO [dbo].[Logs] ([Contents]) VALUES (@contents)";
command.AddParameterWithValue("@contents", ContentFormatter.Serialize(logEntry.ToDictionary()));
await command.ExecuteNonQueryAsync().ConfigureAwait(false);
}
}