Loading

Transaction based approch in asp.net mvc5

Transaction based approch in asp.net mvc5

ejaz mirza

7y843.NET

My application is in N tier architechture i just want to make it as transaction based

should i add transaction globally

public ActionResult adddepartment(LbMsDepartment dt)
{
dt.CreatedBy = 1;
dt.CreatedOn = DateTime.Now;
dt.OS = ""+1;
dt.Browser = ""+1;
dt.DeptStat = true;
dt.IP = ""+1;
testingtranscationAdd(dt);
testingtranscationupdate(dt);
return View();
}
//in BLL Layer the two mthods splits like that in DLL also
public void testingtranscationAdd(LbMsDepartment dt)
{
dt.DeptName = "tested";
dt.DeptDesc = "transaction testing";
hms.LbMsDepartments.Add(dt);
int i = hms.SaveChanges();
}
public void testingtranscationupdate(LbMsDepartment dt)
{
dt.DeptName = "tested";
dt.DeptDesc = "transaction testing";
hms.LbMsDepartments.Add(dt);
int i = hms.SaveChanges();
}

In the above code i want apply transaction based approch .

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

ejaz mirza7y ago
my architechture doesn't support this when i will commit the transaction then if i follow c#EF6 usetransaction i just need to call in my action method to commit the transaction
explicitly create a method to commit the transaction

In the above example testingtranscationAdd and testingtranscationupdate the i will call the commit method is there anyway
0
Amit Mohanty7y ago
Hey check the below links.

https://www.c-sharpcorner.com/UploadFile/ff2f08/working-with-transaction-in-entity-framework-6-0/

https://www.dotnetcurry.com/entityframework/1170/transaction-scope-databases-adonet-entity-framework-aspnet-mvc
0
Chittaranjan Swain7y ago
Hi ejaz,

Refer below links,

https://www.c-sharpcorner.com/article/transaction-in-entity/
https://www.entityframeworktutorial.net/entityframework6/transaction-in-entity-framework.aspx
0