OOP

[cdgregory]

Hi,

I would like some advice on how to create a class to represent a one to many relationship in C#.

i.e. I have a Customer and an Address table in my database. I also have a Customer class in my C# solution but how do I introduce the multiple address element? Do I have a separate Address class? Do I create a subclass in the Customer class or create a method in Customer called GetAddresses of type List which contains all of the relevant logic?

In my code I need to be able to return a customer with all associated addresses and I just cannot picture the best way to achieve this.

All help greatly appreciated.

Thanks
C

[kvprajapati]

You should try out Linq to SQL Inheritance. Have a look at following articles :

1. http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/10/01/linq-to-sql-inheritance.aspx
2. http://msdn.microsoft.com/en-us/library/bb384467.aspx
3. http://msdn.microsoft.com/en-us/library/bb399352.aspx

[cdgregory]

Thanks - that's great.