Databases
StackOverflow2013
Postsdbo
POIs there an automatic way to generate a rollback script when inserting data with LINQ2SQL?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs there an automatic way to generate a rollback script when inserting data with LINQ2SQL?
    primarykey
    data
    text
    <p>Let's assume we have a bunch of LINQ2SQL <code>InsertOnSubmit</code> statements against a given <code>DataContext</code>. If the <code>SubmitChanges</code> call is successful, is there any way to automatically generate a list of SQL commands (or even LINQ2SQL statements) that could <strong>undo</strong> everything that was submitted at a later time? It's like executing a rollback even though everything worked as expected.</p> <p>Note: The destination database will either be Oracle or SQL Server, so if there is specific functionality for both databases that will achieve this, I'm happy to use that as well.</p> <p><strong>Clarification:</strong> I do not want the "rollback" to happen automatically as soon as the inserts have succesfully completed. I want to have the ability to "undo" the INSERT statements via DELETE (or some other means) up to 24 hours (for example) after the original program finished inserting data. We can ignore any possible referential integrity issues that may come up.</p> <p>Assume a Table A with two columns: <code>Id</code> (autogenerated unique id) and <code>Value</code> (string)</p> <p>If the LINQ2SQL code performs two inserts</p> <pre><code> INSERT INTO Table A VALUES('a') // Creates new row with Id = 1 INSERT INTO Table A VALUES('z') // Creates new row with Id = 2 &lt;&lt; time passes&gt;&gt; </code></pre> <p>At some point later I would want to be able "undo" this by executing</p> <pre><code> DELETE FROM A Where Id = 1 DELETE FROM A Where Id = 2 </code></pre> <p>or something similar. I want to be able to generate the <code>DELETE</code> statements to match the <code>INSERT</code> ones. Or use some functionality that would let me capture a transaction and perform a rollback later.</p> <p>We cannot just 'reset the database' to a certain point in time either as other changes not initiated by our program could have taken place since.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJedidja
    1. USJedidja
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIs there an automatic way to generate a rollback script when inserting data with LINQ2SQL?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhen you say "...at a later point in time..." are you thinking of seconds, years or something in-between? Would the delete be triggered from the same session of the calling application, or potentially from other sessions (or other applications)? A bit more context might be helpful.
      singulars
      1. POIs there an automatic way to generate a rollback script when inserting data with LINQ2SQL?
      1. USEd Harper
    2. COI am thinking of "minutes to hours" as a "later point in time". It would not be triggered from the same context of the calling application, or even the same session. It would be executed from a different program (or even through some IDE like Management Studio if SQL undo code was available).
      singulars
      1. POIs there an automatic way to generate a rollback script when inserting data with LINQ2SQL?
      1. USJedidja
    3. CODon't forget to flag your favorite answer.
      singulars
      1. POIs there an automatic way to generate a rollback script when inserting data with LINQ2SQL?
      1. USSteven
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload