public async Task <List <Channel> > GetBotsByChannelId(string id) { var query = _context.QueryAsync <Channel>(id); var botQuery = new Amazon.DynamoDBv2.DocumentModel.QueryOperationConfig { IndexName = "BotId-ChannelId-index" }; botQuery.KeyExpression = new Amazon.DynamoDBv2.DocumentModel.Expression { ExpressionStatement = "BotId = :botId", ExpressionAttributeValues = new Dictionary <string, Amazon.DynamoDBv2.DocumentModel.DynamoDBEntry> { { ":botId", id } } }; var botresult = _context.FromQueryAsync <Channel>(botQuery); var data = await botresult.GetRemainingAsync(); var data2 = await query.GetRemainingAsync(); return(data.Union(data2).ToList()); }
public Task <List <User> > GetUsersByClientIdAsync(string id) { var userQuery = new Amazon.DynamoDBv2.DocumentModel.QueryOperationConfig { IndexName = "ClientId-index" }; userQuery.KeyExpression = new Amazon.DynamoDBv2.DocumentModel.Expression { ExpressionStatement = "ClientId = :clientId", ExpressionAttributeValues = new Dictionary <string, Amazon.DynamoDBv2.DocumentModel.DynamoDBEntry> { { ":clientId", id } } }; var botresult = _context.FromQueryAsync <User>(userQuery); return(botresult.GetRemainingAsync()); }