/// <summary>
        /// Update the student details
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        public async Task <ResponseDto> UpdateStudentAsync(StudentDto dto)
        {
            IDbConnection connection = Connection;

            dto.UpdateModifiedAuditFields();
            string sql = string.Format("UPDATE StudentManagement SET FirstName = '{0}', LastName = '{1}', Age = {2}, Gpa = {3}, LastUpdatedDate = '{4}' Where Id = {5}",
                                       dto.FirstName, dto.LastName, dto.Age, dto.Gpa, dto.LastUpdatedDate, dto.Id);
            int rows = await connection.ExecuteAsync(sql, null, transaction : Transaction);

            return(new ResponseDto()
            {
                ResponseCode = ResponseCode.SUCCESS
            });
        }