Global exception handling in database in .net core

 step 1 :  Create global exception solution as below 

 step 2:Create common folder for recording parameters and create the LogEntryRequest.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace GlobalException.WebApi.Common

{

    public class LogEntryRequest

    {

        public DateTime TimeStamp { get; set; }

        public string RequestId { get; set; }

        public string Message { get; set; }

        public string Type { get; set; }

        public string Source { get; set; }

        public string StackTrace { get; set; }

        public string RequestPath { get; set; }

        public string Action { get; set; }

    }

}

Step 3:Create filter folder and create class as below,

using GlobalException.WebApi.Common;

using Microsoft.AspNetCore.Hosting;

using Microsoft.AspNetCore.Mvc.Filters;

//using Microsoft.Extensions.Hosting;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace GlobalException.WebApi.Filter

{

    public class DbExceptionFiltercs:ExceptionFilterAttribute

    {

        private readonly IExceptionLogService _iExceptionLogService;

        [Obsolete]

        private readonly IHostingEnvironment _iHostingEnvironment;

        [Obsolete]

        public DbExceptionFiltercs(IExceptionLogService iExceptionLogService,IHostingEnvironment iHostingEnvironment)

        {

           _iExceptionLogService = iExceptionLogService;

            _iHostingEnvironment = iHostingEnvironment;

        }

        public override void OnException(ExceptionContext context)

        {

            if (_iHostingEnvironment.IsDevelopment())

            {

                LogEntryRequest log = new LogEntryRequest

                {

                    TimeStamp = DateTime.Now,

                    Action = context.ActionDescriptor.DisplayName,

                    Message = context.Exception.Message,

                    RequestPath = context.HttpContext.Request.Path,

                    Source = context.Exception.Source,

                    StackTrace = context.Exception.StackTrace,

                    Type = context.Exception.GetType().ToString()

                };

               _iExceptionLogService.Add(log);   //using this line exception is recorded in database

            }

        }

    }

}

Step 4: for recording the data create the interface for recording the data in database

using GlobalException.WebApi.Common;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace GlobalException

{

    public interface IExceptionLogService

    {

        long Add(LogEntryRequest viewModel);

    }

}

now create the class to implement the interface

using GlobalException.WebApi.Common;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace GlobalException

{

    public class ExceptionLogService: IExceptionLogService

    {

        private readonly IExceptionLogRepository _iExceptionLogRepository;

        public ExceptionLogService()

        {

            _iExceptionLogRepository = repository;

        }

        public long Add(LogEntryRequest viewModel)

        {

            _iExceptionLogRepository.Add(viewModel);

            return res;

        }

    }

}

 Step5: now set the dependency in startup file.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using GlobalException.WebApi.Filter;

using Microsoft.AspNetCore.Builder;

using Microsoft.AspNetCore.Hosting;

using Microsoft.AspNetCore.Mvc;

using Microsoft.Extensions.Configuration;

using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Hosting;

using Microsoft.Extensions.Logging;

namespace GlobalException

{

    public class Startup

    {

        public Startup(IConfiguration configuration)

        {

            Configuration = configuration;

        }

        public IConfiguration Configuration { get; }

        // This method gets called by the runtime. Use this method to add services to the container.

        public void ConfigureServices(IServiceCollection services)

        {

            services.AddControllers();

            services.AddScoped<IExceptionLogService, ExceptionLogService>();

            services.AddScoped<DbExceptionFiltercs>();// for Error Log

        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.

        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)

        {

            if (env.IsDevelopment())

            {

                app.UseDeveloperExceptionPage();

            }

            app.UseRouting();

            app.UseAuthorization();

            app.UseEndpoints(endpoints =>

            {

                endpoints.MapControllers();

            });

        }

    }

}

step 6:now apply the global exception in controller

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using GlobalException.WebApi.Filter;

using Microsoft.AspNetCore.Mvc;

using Microsoft.Extensions.Logging;

namespace GlobalException.Controllers

{

    [ServiceFilter(typeof(DbExceptionFiltercs))]     calling exception on controller

    [ApiController]

    [Route("[controller]")]

    public class WeatherForecastController : ControllerBase

    {

        private static readonly string[] Summaries = new[]

        {

            "Freezing", "Bracing", "Chilly", "Cool", "Mild", "Warm", "Balmy", "Hot", "Sweltering", "Scorching"

        };

        private readonly ILogger<WeatherForecastController> _logger;

        public WeatherForecastController(ILogger<WeatherForecastController> logger)

        {

            _logger = logger;

        }

        [HttpGet]

        public IEnumerable<WeatherForecast> Get()

        {

            int a = 1;

            int b = 0;

            //int c = 0;

            int c = a / b;          knowingly generate exception

            //var t = 1 / 0;

            var rng = new Random();

            return Enumerable.Range(1, 5).Select(index => new WeatherForecast

            {

                Date = DateTime.Now.AddDays(index),

                TemperatureC = rng.Next(-20, 55),

                Summary = Summaries[rng.Next(Summaries.Length)]

            })

            .ToArray();

        }

    }

}