how to write error message to DB with EF when SaveChanges?

Question

With EF, any data value in Entity instance can be saved back to database by calling SaveChanges which can be overridden to add custom action.

So I try to override SaveChanges in following way:

public override int SaveChanges(System.Data.Objects.SaveOptions options)
       {          
           try
           {
               return base.SaveChanges(options);
           }
           catch (Exception ex)
           {
               //error log here  
               //write the error message to database table errorlog             
               throw ex;
           }
       }

when SaveChange failed, I want to grab the exception and save the error message to a table in same database. With about code, even save data to table errorlog, also should call SaveChanges. How to resolve this problem?

Eranga · Accepted Answer · 2012-01-20 03:58:47Z

2

Initialize a new context instance in your catch block and log the error.

   public override int SaveChanges(System.Data.Objects.SaveOptions options)
   {          
       try
       {
           return base.SaveChanges(options);
       }
       catch (Exception ex)
       {
           var context = new MyContext();

           // your log class instance populated with relevant details
           var error = new Error { Message = ex.Message; };

           context.Errors.AddObject(error);
           context.SaveChanges();

           throw;
       }
   }

answered Jan 20, 2012 at 3:58

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

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

1 Comment

kwingkwingko Over a year ago

This is not working for me... Any updates on this?.

Ladislav Mrnka · Accepted Answer · 2012-01-20 09:56:43Z

1

In addition to @Eranga's advice use separate context type just for error logging (it will map only Error entity). This new context type will not have overriden SaveChanges - that will avoid infinite loop in case of error fired during error saving.

answered Jan 20, 2012 at 9:56

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Collectives™ on Stack Overflow

how to write error message to DB with EF when SaveChanges?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related