How do I call the stored procedure in entity framework core to retrieve the data

Id = 18, Status = WaitingForActivation, Method = "{null}", Result = "{Not yet computed}"

var test = context.GetmessageAsync(int productId)

public async Task<List<Getmessage>> GetmessageAsync(int productId)
{
	// Initialization.  
	List<Getmessage> lst = new List<Getmessage>();

	try
	{
		// Settings.  
		SqlParameter usernameParam = new SqlParameter("@id", productId.ToString() ?? (object)DBNull.Value);

		// Processing.  
		string sqlQuery = "EXEC [dbo].[Getmessage] " +
						  "@id";

		lst = await this.Query<Getmessage>().FromSql(sqlQuery, usernameParam).ToListAsync();
	}
	catch (Exception ex)
	{
		throw ex;
	}
}