public static void BulkWriteToDatabase <TEntity>(IPostgreSQLCopyHelper <TEntity> bulkPostgreSqlCopyHelper, IEnumerable <TEntity> entities) { using (NpgsqlConnection dbConnection = new NpgsqlConnection(PostgreSqlConnectionString)) { dbConnection.Open(); bulkPostgreSqlCopyHelper.SaveAll(dbConnection, entities); } }
private async Task InsertItemsAsync <T>(IEnumerable <T> items, IPostgreSQLCopyHelper <T> copyHelper) { using (var connection = new NpgsqlConnection(_connectionString)) { await connection.OpenAsync(); copyHelper.SaveAll(connection, items); } }
private void InternalWrite(IEnumerable <LocalWeatherData> measurements) { if (measurements == null) { return; } using (var connection = new NpgsqlConnection(connectionString)) { // Open the Connection: connection.Open(); processor.SaveAll(connection, measurements); } }