Entity Framework 6.1.3 Log SQL queries only if exception occurred On DBContext.SaveChanges()

Question

I am using Entity Framework 6.1.3. I want to log SQL queries with parameters after only if an exception occurred in the catch block. Is there any way to log queries in this way?

try
{
   base.SaveChangesAsync();
}
catch(Exception ex)
{
  // I want to log SQL queries here.
}

why not just let .Log write to a memory stream and just dump this stream to a log file if you enter the exception block? — DevilSuichiro
– DevilSuichiro, Commented Jan 14, 2020 at 13:01

Suraj Kumar · Accepted Answer · 2020-01-14 15:38:23Z

1

You can use any of the below logging libraries as shown below described here.

Log4net (Logging in text file + logging in SQL database)
Nlog (Logging in text file + logging in SQL database)
Serilog (Logging in text file + logging in SQL database)
Elmah (logging in SQL database)

Alternatively you can create a procedure to track and insert the log/issue in the database manually as below.

try    
 { 
   //Your code here.
 }    
 catch (Exception ex)    
 {        
   ExceptionLogging.SendExcepToDB(ex);    
   Label1.Text = "Some Technical Error occurred,Please visit after some time";     
 }

You can get the details from here.

edited Jan 14, 2020 at 15:38

answered Jan 14, 2020 at 6:37

Suraj Kumar

5,6748 gold badges24 silver badges45 bronze badges

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

1 Comment

Suraj Kumar Over a year ago

@MaheshBhosale You are welcome and I had already said there are various way to log the exception both from the application and in database side also.

Mahesh Bhosale · Accepted Answer · 2020-01-17 08:31:56Z

0

Logged the log into the memory stream and if the exception has occurred the log is added to the file.

answered Jan 17, 2020 at 8:31

Mahesh Bhosale

571 silver badge10 bronze badges

Collectives™ on Stack Overflow

Entity Framework 6.1.3 Log SQL queries only if exception occurred On DBContext.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