Chloe
Chloe copied to clipboard
Delete range
Hi
Is there a possibility for a delete list of objects in single command/query?
List
new version: dbContext.Delete<Person>(a => !dbContext.Query<City>().IgnoreAllFilters().Select(a => a.Id).ToList().Contains(a.CityId)); /*
- DELETE FROM [Person] WHERE NOT ([Person].[CityId] IN (SELECT [City].[Id] AS [C] FROM [City] AS [City])) */