public async Task <bool> SaveAsync(ILogger log, SimpleLogEntity entity)
{
var sql = "INSERT INTO SimpleLog (Id, OurClientId, ApplicationId, LogLevel, Description, Json, Created) VALUES (@Id, @OurClientId, @ApplicationId, @LogLevel, @Description, @Json, @Created)";
try
{
using SqlConnection connection = new SqlConnection(this._connectionString);
using SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@Id", entity.Id);
command.Parameters.AddWithValue("@OurClientId", entity.OurClientId);
command.Parameters.AddWithValue("@ApplicationId", entity.ApplicationId);
command.Parameters.AddWithValue("@LogLevel", entity.LogLevel);
command.Parameters.AddWithValue("@Description", entity.Description);
command.Parameters.AddWithValue("@Json", entity.Json);
command.Parameters.AddWithValue("@Created", entity.Created);
await connection.OpenAsync();
return(await command.ExecuteNonQueryAsync() > 0);
}
catch (Exception ex)
{
log.LogError(ex, ex.Message);
return(false);
}
}
public async Task <bool> SaveAsync(ILogger log, SimpleLogEntity entity)
{
try
{
var database = this.GetMongoDatabase();
var collection = database
.GetCollection <SimpleLogEntity>(typeof(SimpleLogEntity).Name);
await collection.InsertOneAsync(entity);
return(true);
}
catch (Exception ex)
{
log.LogError(ex, ex.Message);
return(false);
}
}
