private static async Task DoBulkInsertIntoTempTableAsync([NotNull] DemoDbContext ctx, [NotNull] List <Guid> customerIds) { var tempTableQuery = await ctx.BulkInsertValuesIntoTempTableAsync(customerIds); var customers = await ctx.Customers.Join(tempTableQuery, c => c.Id, t => t.Column1, (c, t) => c).ToListAsync(); Console.WriteLine($"Found customers: {String.Join(", ", customers.Select(c => c.Id))}"); }