How to perform rollback in Entity Framework 5, .Net Framework 4?
Do I have to call db.SaveChanges();
under //commit
or is db.usp_UpdateRoleUser
suffice?
What code should be under //rollback
?
public static bool UpdateRoleUser(int component_type, string oldRole, string oldUser, string oldAuth_value, string newRole, string newUser, string newAuth_value)
{
using (var db = new VMIEntities())
{
int recordAffected = db.usp_UpdateRoleUser(newRole, newUser, newAuth_value, oldRole, oldUser, oldAuth_value, component_type);
if (recordAffected == 1)
{
//commit
return true;
}
else
{
//rollback
return false;
}
}
}