Archivi tag: delete

MySQL Delete rows subquery You can’t specify target table ‘XXX’ for update in FROM clause

Today my colleague and I have received a gift from MySQL. Our goal was to delete some rows obtaining them using a subquery. Here is the query: And here the response of MySQL You can’t specify target table ‘ps_pack’ for … Continua a leggere

Pubblicato in SQL | Contrassegnato , , | Lascia un commento

Entity Framework update entity and childs entities, Bulk Delete part 2

In the previous post I’ve explained how to perform a single update, but what I’ve to do If I need to update a master entity and related child? As I’ve explained to update my model I use the 3rd method: … Continua a leggere

Pubblicato in c#, Entity Framework | Contrassegnato , , , | Lascia un commento