CRUD Operations In .NET Core 3.0 With Visual Studio 2019

CREATE TABLE [dbo].[Job](  
    [JobID] [int] IDENTITY(1,1) NOT NULL,  
    [JobTitle] [nchar](250) NULL,  
    [JobImage] [nvarchar](max) NULL,  
    [CityId] [int] NULL,  
    [IsActive] [bit] NULL,  
    [CreatedBY] [nvarchar](50) NULL,  
    [CreatedDateTime] [datetime] NULL,  
    [UpdatedBY] [nvarchar](50) NULL,  
    [UpdatedDateTime] [datetime] NULL,  
 CONSTRAINT [PK_Job] PRIMARY KEY CLUSTERED   
(  
    [JobID] ASC  
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE PROCEDURE [dbo].[SP_Add_Job]      
    @JobTitle NVARCHAR(250) ,      
    @JobImage NVARCHAR(Max) ,      
    @CityId int ,      
    @IsActive BIT ,      
    @CreatedBY NVARCHAR(50) ,      
    @CreatedDateTime DATETIME ,      
    @UpdatedBY NVARCHAR(50),    
    @UpdatedDateTime DATETIME    
        
AS      
    BEGIN      
 DECLARE @JobId as BIGINT    
        INSERT  INTO [Job]      
                (JobTitle ,      
                 JobImage ,      
                 CityId ,      
                 IsActive ,      
                 CreatedBY ,      
                 CreatedDateTime ,      
                 UpdatedBY ,      
                 UpdatedDateTime    
             )      
        VALUES  ( @JobTitle ,      
                  @JobImage ,      
                  @CityId ,      
                  @IsActive ,      
                  @CreatedBY ,        
                  @CreatedDateTime ,     
                  @UpdatedBY ,      
                  @UpdatedDateTime                      
                      
             );     
        SET @JobId = SCOPE_IDENTITY();     
        SELECT  @JobId AS JobId;      
    END;

1. Helper
2. Interface

In the Interface folder, add a new interface namely “IDapperHelper” and copy the below code and paste in that class.

using Dapper;  
using System;  
using System.Collections.Generic;  
using System.Data;  
using System.Data.Common;  
using System.Linq;  
using System.Linq.Expressions;  
using System.Threading.Tasks;  
  
namespace CoreDemo_3_0.Interfaces  
{  
    public interface IDapperHelper : IDisposable  
    {  
        DbConnection GetConnection();  
        T Get<T>(string sp, DynamicParameters parms, CommandType commandType = CommandType.StoredProcedure);  
        List<T> GetAll<T>(string sp, DynamicParameters parms, CommandType commandType = CommandType.StoredProcedure);  
        int Execute(string sp, DynamicParameters parms, CommandType commandType = CommandType.StoredProcedure);  
        T Insert<T>(string sp, DynamicParameters parms, CommandType commandType = CommandType.StoredProcedure);  
        T Update<T>(string sp, DynamicParameters parms, CommandType commandType = CommandType.StoredProcedure);  
    }  
}