C#

public SortedList<Animal, Zoo> map = new SortedList<Animal, Zoo>();
...
...
...
//and linq
zoo.animals = (from animal in animalList   
            where map[animal].Id == zoo.Id
            select animal).ToList();
}

public SortedList<int, int> map = new SortedList<int, int>();
...
...
...
//fill the sortedList from the DReader
//and linq
zoo.animals = (from animal in animalList   
            where map[animal.Id] == zoo.Id
            select animal).ToList();

class Animal{
   public int Id{get;set;}
   public string Name{get;set;}
}

class Zoo{
   public int Id{get;set;}
   public string Name{get;set;}
}

//and a sortedList or a class that represnts the AnimalZoo jonction table, but why bother to implement
//IComparable, IEqutable ... when you already have it.
SortedList<int,int> animalZooJonction = new SortedList<int, int>();
//the animalI.Id is key and zoo.Id is value

//Now when he wants to get the animals for a given zoo:

var animalsInSpecifiedZoo = (from rec in animals
                             where animalZooJonction[rec.Id] == zoo//zoo specified as a param
                             select rec).ToList();

[System.ComponentModel.DefaultValue("My Default value")]
public string MyProperty{
    set{
        //	Some set code
    }
}

Anticast wrote:

However, the complier won’t let me set the DefaultValue to DateTime.Now (or any other DateTime object) and I’ve had no luck finding an answer on the net.

Anticast wrote:

Is there a way to stop the designer from trying to “figure out” what my control would look like and just set its placement?

[DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
new public ComboBox.ObjectCollection Items
{
    get
    {
        return base.Items;
    }
}

SqlTransaction trans = null;
cmd.Connection = cn;

if(cn.HasTransaction)
{
  trans = cn.Transaction;
}
else
{
  trans = cn.BeginTransaction();
}

cmd.Transaction = trans;