Tony,

Thanks for the detailed explanation and the table structures...that definitely helped!

Ultimately, if you want a single row in a grid to display items from multiple tables there's really no way of getting around the requirement to create a business entity that contains all the columns from each table you want to display. The Business Layer Generator can generate entity objects from either views or stored procedures, but the choice is up to you. When it comes to updating, again, ADO.NET can't handle creating dynamic SQL to update multiple back end tables so it will require you to generate stored procedures for insert, update, and delete (the Business Layer Generator can help you out here too).

Ultimately you may have a Client object and a ClientAddress object. The Client Address object can provide an unnormalized view of the ClientBillingAddressLink table and the Address table. This is where you will need to pull the data from the database using a view/stored procedure and use stored procedures to update.

Best Regards,