Alternative of Sql transactions, roll-back in entity framwork

Question

1.00/5 (1 vote)

See more:

Hi,

I have some tables in my database and want to insert records in these tables using Entity framework in MVC 4.0.
Insertion took place in this way that insertion of record in child table depends on the records in the master table.
This functionality could be achieve easily by Transaction and roll-back in the sql server. Where If record could not be insert in any of the table involved in the process then whole insertion process would roll-backed.

I want the alternative of this Transaction and roll-back with Entity framework in MVC 4.0.

Please provide some suggestions.

Thank you,

Regards,
Ashish

Posted 19-Sep-14 1:07am

Aashish vermaa

Add a Solution

Comments

Herman<T>.Instance 19-Sep-14 7:10am

what do you exactly mean by alternative?

Aashish vermaa 19-Sep-14 7:39am

I means how could we code in Entity framework to achieve facility like roll-back in case of any issue.

2 solutions

Solution 1

Literally the first result from Google for "Entity Framework Transaction":

http://msdn.microsoft.com/en-us/data/dn456843.aspx[^]

In all versions of Entity Framework, whenever you execute SaveChanges() to insert, update or delete on the database the framework will wrap that operation in a transaction. This transaction lasts only long enough to execute the operation and then completes. When you execute another such operation a new transaction is started.

Posted 19-Sep-14 2:24am

Richard Deeming

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10911231 · Accepted Answer · 2014-09-19T20:24:00

Using Transactions you can solve your problms

C#

using System.Transactions; /Inculde this Directory and Reference


using (TransactionScope trans = new TransactionScope())
            {
                try
                {

                    using (DBEntities en = new DBEntities())
                    {
                        /*


			Yours DML(S)



			*/
		    }


                    trans.Complete();//If Success

                    
                }

                catch (Exception ex)
                {
                    trans.Dispose();//If Not Success
                    
                }
}