Last post Aug 12, 2010 02:13 AM by babpattanaik
Aug 10, 2010 09:04 AM|skm1837|LINK
I am searching for what are the standard best practice (for OOP) used to design classes for develop asp.net application? I am aware of most of the OOP concepts but confused with how to map object/classes.
Let's take example of Adventure works - 2005 database provided by Microsoft; it has five schemas Sales, Purchase, Person, Production, HR and DBO.
Should we consider Schemas as Namespace in Classes?
Now, Person schema has 5 tables, should we design classes based on tables?
i.e. Person schema has Address, AddressType, Contact, ContactType, CountryRegion & StateProvince tables. What are the classes we can consider?
What are the basic criteria to decide objects? What to do and how to design classes for tables like Purchase order detail, Product cost history, Product inventory, Product Category etc.
Please give your thoughts.
OOP Best Design Question
Begginer asp.net OOP concepts
Aug 10, 2010 10:07 AM|vinay13mar|LINK
plz check the link
Aug 11, 2010 10:01 AM|skm1837|LINK
Thank you, vinay13mar!
Links are good but I am looking for specific answer. Is anyone has solution how to map database table fields with class members effectively.
Aug 12, 2010 02:13 AM|babpattanaik|LINK
For mapping database table fields to Class members effectively, you need to design the classes, then create a data model which is mapping between your classes and database tables which is called object Relational Mapping (ORM).
Hope it will help you.