I'm currently in a situation where I should insert/update/delete information from various tables in one transaction using LINQ. For example in insert, I'm adding data to table A, retrieving it's row id (primary key) and using that ID to rest of the tables. Or in Update/Delete I should be able to delete information from various tables at once, or if something goes wrong, nothing gets updated/deleted (or inserted for that matter). The question goes, could someone provide examples how to accomplish
Read More...