thank you for the time you have taken to help me. It was a Friday that stuck with me to find out the solution. this Monday fresh morning, fresh mind gave an easy solution to my existing code.

all I have to use is "SelectData" instead of "ExecuteScalarAsync" that is returning multiple values as a tuple post SQL insert query.

return await dbHelper.SelectData<(int, string)>(sqlQuery.ToString(), paramSearch).ConfigureAwait(false);

Thanks