To the uninitiated (whereas Carlos seems to already be using dataset nomenclature) ...

Visual Studio 2005 does relationship-aware data encapsulation out of the box with datasets. Datasets are strongly-typed schema declarations persisted as XML but compiled as managed code. You can use the diagram designer to drag-and-drop relationships between tables just like the diagram designer in SQL Server Enterprise Manager (except that here the relationships are persisted locally, not on SQL Server). To get started, use the Server Explorer to connect through the SalesLogix OLE-DB provider to your database. You can then create a dataset directly from the tables in this connection.

Datasets are instantiable as objects, almost like strongly-typed recordsets, and can also be used to data-bind forms and controls. Keep in mind, though, that datasets are strictly schema declarations (wrapper "classes") for persisted data. They are not true object models. But when instantiated (and filled) they are certainly strongly-typed objects.

There are caveats with datasets, of course. First of all, you won't want to do this with all the tables unless you want Visual Studio running like mollasses. Secondly, you'll need to keep track of your connection context. (You're on your own there.) Third, you will definitely need to validate your relationships because the relations don't really exist in SalesLogix from a SQL Server / OLE-DB perspective, but strictly through the SalesLogix JOINDATA (and perhaps RESYNCTABLEDEFS and other metadata) tables.

Account myAccount = Account.GetAccount(accID); // singular is always by ID

AccountList myAccounts = Account.GetAccounts("Status='Active'"); // multiple is always by WHERE clause, or overloaded with no params

OpportunityList myOpportunities = Account.GetAccount(accID).Opportunities;

OpportunityList myOppGroup = Opportunity.GetOpportunities("ACCOUNTID in (" + Account.GetAccounts("Status = 'Inactive'") + ")");

ContactList myContacts = Contact.GetContacts("ADDRESSID in (" + Address.GetAddresses("City = 'Austin' and State = 'TX'") + ")");

class AccountList : List<Account>
{
    public AccountList() : base() { }
    // ...
    public override ToString() {
        // return the IDs here
    }
}