/// <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
});
}