hi\n\nasp.net 2.0\n\nI have a database here containing 2 tables, Order and OrderLines. OrderLines \nhas a foreign key to Order...\n\nUntil know I have created an entity class for Order (public class Order, not \nusing DataSet), containing only the fields available in the Order table. \nBut now I often need to know how many OrderLines are linked to a specific \nOrder.\n\nSo I thought about adding a int Count field to the Order entity. So when I \nrun the stored procedure returning the Order, it has to do a count on \nOrderLines connected to this Order. But not sure that is best practice, \nbecause when I create a new Order I must set this value to 0. And also the \nCount field is not a real field in the Order table.\n\nMaybe there is an even better approach? Can I create a Order entity having \nlinks to OrderLines entity? Then maybe my Order entity could have a \nOrderLine collection property...?\n\nany suggestions? links to articles would be great.