Re-discovering code snippets

SimpleSqlCode.cs

using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
    SqlCommand command = new SqlCommand("GetItems", connection);
    command.CommandType = CommandType.StoredProcedure;
    command.Parameters.AddWithValue("@author", "Jonas Folleso");

    using (command)
    {
        command.Connection.Open();
        using (SqlDataReader reader = command.ExecuteReader())
        {
            List<Item> items = new List<Item>();
            while (reader.Read())
            {
                Item item = new Item();
                item.ID = reader["id"] == null ? -1 : Convert.ToInt32(reader["id"]);
                item.Title = reader["title"] == null ? string.Empty : reader["title"] as string;
                items.Add(item);
            }
            reader.Close();
        }
        command.Connection.Close();
    }
}