Automatically background email in Asp .net MVC

Question

Hi All I wanted to send  Automatically background email in Asp .net MVC using database field date every day if data has inserted into database. We have already established a sending email for based on login , now we need to send based on all records inserted into DB,   Note : I am using Asp .net MVC(C#) and Asp .net core in my project.   Your help will be very appreciated .   Thanks

rajesh vs · Answer

@ Suraj Kumar Thnaks for your response . I wanted to send throug C# code from asp.net MVC.  My scenario is whatever  data has inserted  in my DB, I have to sent that data to users based on  daily or weekly basis

Suraj Kumar · Answer

@Sandhya I have already suggested to create either a sql server job or trigger and then suggested to create windows service. It is the choice of OP's what he will opt and what will be better for him/her.   Second if you will even create either sql server job or trigger in both cases a profile and mail enable is required in SQL Server agent.   Check the link if that service is not already enabled in your sql server otherwise it is optional and you can go for it.   Below is the sample code for sending mail using stored procedure USE msdb;   GO      EXEC  sp_send_dbmail      @recipients= 'mark@mark.com' ,     @subject= 'Client Report' ,     @body= 'Please find your latest report attached' ,     @file_attachments= 'D:\MyTable.csv' ;   Hope it will help both of you.

Sandhya Pothineni · Answer

Suraj Kumar   Can you tell me, how to implement that scenarioin in MVC without creating SQL Server job in db.

Suraj Kumar · Answer

You can create a SQL Server job for sending mail automatically using stored procedure.   To create a job in sql server look into this- https://www.c-sharpcorner.com/article/job-scheduling-in-sql-server/   Before this you need to enable sql server agen mail functionality for this you need to create a profile. If not already configure you need to look into this- https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/create-a-database-mail-profile?view=sql-server-2017   Alternatively you can also create a trigger for sending mail and you can also create a windows service for sending mail in C#.Net.