public async Task AddPermissionsToUserAsync(long userId, List <string> permissions) { var permissionIds = await SmartHomeAppDbContext.Query <Permission>() .Where(x => permissions.Contains(x.Name)) .Select(x => x.Id) .ToListAsync(); var entities = permissionIds.Select(x => new UserPermission() { UserId = userId, PermissionId = x }); await SmartHomeAppDbContext.AddRangeAsync(entities); }