我可以在 .NET Core 类库中做类似的事情吗？我在将 System.Data.SqlClient 的引用添加到我的 .NET Core 类库时遇到问题，我不知道要添加什么。

public static List<Person> GetByLastName(string lastName)
{
    List<Person> people = new List<Person>();

    SqlConnection connection = new SqlConnection("connectionString");
    SqlCommand cmd = new SqlCommand("usp_myStoredProcedure",connection);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@lastName",lastName);
    SqlDataReader dr = null;

    try
    {
        connection.Open();

        dr = cmd.ExecuteReader();

        while (dr.Read())
        {
            Person person = new Person();

            person.FirstName = dr["Person"].ToString();
            person.LastName = dr["LastName"].ToString();
            person.PersonID = (int)dr["PersonID"];

            people.Add(person);
        }
    }
    catch (Exception ex)
    {
        // Log Error
        throw ex;
    }
    finally
    {
        if (connection.State != ConnectionState.Closed)
            connection.Close();
        if (dr != null && !dr.IsClosed)
            dr.Close();
    }

    return people;
}