No, that's not supported yet, I'm planning to do some work on compound operations like that in 2.0, which is probably starting in earnest around the end of the year.
In the meantime, stored procs are my catch-all work-around recommendation. 😊
Sent from Windows Mail
From: Gavin Osborn
Sent: 08 November 2012 19:27
Subject: Complex Delete Scenarios
Does Simple.Data support the following style query?
DELETE FROM Users
WHERE locationId IN
SELECT locationid FROM Location WHERE continent = Europe
I've tried a few examples including:
It's not throwing exceptions, but the SQL Server Profiler also tells me that it isn't executing any SQL either.
How would I best achieve this in Simple.Data?