Business logic layer, multiple tables, relationship

Question

In the business logic we map, Tables to Objects and fields of this table to properties. What to do in one-to many relationship? Just an example: I have Table, Products and Categories. I need to drag all products and instead of Category_ID (Products table) need to display actual Category name wich is stored in Category table.

What is propal way of doing it? In similar situations?

Answer 1

You can have a property on the Products Entity that is of type Category Entity. Check this link out from the EntitySpaces (an ORM for .Net) documentation for ideas: link text

Also, you may want to look into using an ORM.

Answer 2

Hey,

Either use an ORM like LINQ to SQL or ADO.NET Entity Framework or strongly-typed datasets. But if you want to custom code your business layer, your Category class could have a Products collection property which contains those products, loaded from the DB, which you could infer the name.

HTH.