Art of BI: Simple SubSonic Project Collection Retrieve

AccountsCollection obj1 = new AccountsCollection();
obj1.Load(q.ExecuteReader());
[/sourcecode]

Using only the Collection Object
[sourcecode language='csharp']
AccountsCollection obj1 = new AccountsCollection().Where("accountID", Comparison.Equals, accountID.value.ToString()).Load();
[/sourcecode]
 

Now, to loop through the Collection
Once the collection has been instantiated and the Load() method called a foreach() loop can take place to get the records.
[sourcecode language='csharp']
if (obj1.Count > 0)
{
   foreach (Accounts x in obj1)
   {
      Console.Write("My Account Name is {0}", x.AccountName);
   }
}
else
   Console.Write("There are no accounts in the collection");