How do I convert sqldatarerader to aysnc/awaits?

See more:

C#

asynchronous

SqlDataReader

hi
I have been trying to get SqlDataReader to work using Async/Awaits but without much success. I got IEnumerable, cannot convert Task to SqlDataReader and some other errors.

Here is basically my code and I must thank in advance to anybody who can really lend a hand to help out.

//App_Code class 

public class Customerslib
{
    public static SqlDataReader Customer_Select(Int32 Year, string Country, string Category)
    {

        SqlDataReader reader = null;
        var connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlConnection connection = new SqlConnection(connectionString);
        SqlCommand sqlcmd = new SqlCommand(Customer_Select,connection);
        sqlcmd.CommandType = CommandType.StoredProcedure;
        sqlcmd.Parameters.Add(new SqlParameter("@Year", SqlDbType.Int)).Value = Year;
        sqlcmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.VarChar,50)).Value = Country;
        sqlcmd.Parameters.Add(new SqlParameter("@Category", SqlDbType.NVarChar, 100)).Value = Category;
        sqlcmd.Connection = connection;
        connection.Open();
        reader = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);
        return reader;

    }

}


//ASPX page
 protected void Page_Load(object sender, EventArgs e)
    {   

        if (!IsPostBack)
        {
            using (SqlDataReader custreader = Customerslib.Customer_Select(Convert.ToInt16("2017"), "Thailand", "Manager")
            {
                rptCustomer.DataSource = custreader 
                rptCustomer.DataBind();
            }
        }
    }

What I have tried:

Have been trying these few links without much success due to the way I return my SQLDatareader.

c# - Return data from datareader asynchronously - Stack Overflow[^]

Async/Await Could Be Better[^]

c# - Using async / await with DataReader ? ( without middle buffers!) - Stack Overflow[^]