public void GetTests() { using(var connection = new NpgsqlConnection(_appSettings.ConnectionString)) { var rs = connection.QueryAsync(""); } }
public static async Task<EventStream> GetLatestStreamCreated() { using (var connection = new NpgsqlConnection(GetConnectionStringBuilder())) { await connection .OpenAsync() .ConfigureAwait(false); var query = await connection .QueryAsync<EventStream>(SelectLatestStreamSql) .ConfigureAwait(false); return query.Any() ? query.Single() : default(EventStream); } }
public static async Task<IEnumerable<StoredEvent>> GetStreamEvents(Guid streamId) { using (var connection = new NpgsqlConnection(GetConnectionStringBuilder())) { await connection .OpenAsync() .ConfigureAwait(false); var query = await connection .QueryAsync<StoredEvent>(SelectStreamEventsSql) .ConfigureAwait(false); return query.ToList(); } }