public async Task <IEnumerable <Account> > Read(Guid id) { await using var connection = new NpgsqlConnection(_databaseOptions.ToString()); var queryResult = await connection.QueryMultipleAsync("SELECT * FROM \"Accounts\" WHERE \"Owner\" = @id", new { id }); var result = queryResult.Read <Account>(); return(result); }
public async Task <bool> Create(Payment item) { await using var connection = new NpgsqlConnection(_databaseOptions.ToString()); return(await connection.ExecuteAsync("INSERT INTO \"Transactions\" VALUES (nextval('\"TransactionsAutoIncrement\"'::regclass), @FromAccount, @ToAccount, @Amount, @When, @Type)", new { item.FromAccount, item.ToAccount, item.Amount, item.When, Type = (short)item.Type }) > 0); }
public async Task <User> Read(Guid id) { await using var connection = new NpgsqlConnection(_databaseOptions.ToString()); return(await connection.QueryFirstOrDefaultAsync <User>("SELECT * FROM \"Users\" WHERE \"Id\" = @id", new { id })); }