Get SQL from transaction before commit

Question

I am developing a project in C# with a SQL Server database.

I want to save some information in the database when a query has any conditions, so my idea was have a generic method that launches the commit of the transaction and, if the commit has the conditions required, saves the information.

My question: is there any way to obtain the SQL code of the transaction just before the .commit()?

For example, something like that:

public void insertInfo(object)
{
     using (Context context = new Context())
     {
         [Do an insert]
         [Do a second insert]
         [Do an update]     

         context.Save()
     }
} 

// In the Context
public void Save()
{
    [Here I want to get the SQL statement(s) that will be affected by the "transaction.Commit()"]
   transaction.Commit();
}

Tab Alleman · Accepted Answer · 2018-05-09 18:29:46Z

2

No there is no built-in command or function that gets the current code of the transaction.

You could build it yourself, by creating a string variable, and every time you execute a command in the function you add it to the variable, and then read the variable when you commit the transaction.

answered May 9, 2018 at 18:29

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get SQL from transaction before commit

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related