Delete data from multiple tables at a time RRS feed

  • Question

  • Hi,

    I want to insert, update or delete data from multiple tables in a single db call in entity framework


    delete from emp where deptid=1

    delete from dept where deptid=1

    i want to do this transactions in a single call and also 

    i want to rollback if the second transaction fails means if both queries executed successfully then only commit otherwise it have to roll back first table deleted data also

    thanks in advance

    Thursday, May 21, 2015 3:56 PM


  • >i dont want to use sql queries in code. 

    Then just use SaveChanges(), it will introduce a transaction to ensure that all the pending changes are either completed successfully or rolled back.  It will result in multiple SQL queries, though.


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Fred Bao Monday, June 1, 2015 9:24 AM
    Tuesday, May 26, 2015 1:52 PM

All replies