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); } }