Class Design Question

[msnews.microsoft.com]

What is the best solution for the following scenario:

I have a contacts database and I am creating the business layer obects to
access my data objects. (So the DB is invisible to the Business Layer
consumer)
Each contact can be of some type "Employee, Customer, Vendor, etc." . The
contact types are also stored in a table in the DB.

So in the business layer I am trying to a make a decision on how to model my
object flow. Here are some examples:
---------------------------------
Method One:
Contact objPerson = new Contact();
objPerson.Name = "Jose";
objPerson.Addre ss = "666 somewhere street";
objPerson.City = "somecity";
objPerson.Conta ctTypeID = 3; //Each
objPerson.Save( );

Problem:
If the ContactTypeID does not exist in the DB there will be an error thrown
by the DB. Also, when a user type objPerson.Conta ctType, I want it to
return a "ContactTyp e" object.

--------------------------------
Method Two:
Contact objPerson = new Contact();
..... Set Generic Properties ...
ContactType objContactType = objAppFactory.G etContactType(3 );
objPerson.Conta ctType = objContactType;

Problem:
This method allows me to throw an error as soon as the user tries to lookup
a nonexistent ContactTypeID before assigning to the Contact. However, I
have the extra round trip to the DB. Seems silly

-------------------------------

Method Three:
I can could provide to ways of setting the ContactType.
objPerson.Conta ctType = objApp.GetConta ctType(3);
or
objPerson.SetCo ntactTypeID(3);

Problem:
Seems dumb

------------------------------

Method Four:
ContactType objEmployee = new ContactType();
Contact objPerson = new Contact();
objPerson.Name = "Jose";
objPerson.Addre ss = "666 somewhere street";
objPerson.City = "somecity";
objEmployee.Add Contact(objPers on);

Problem:
If the user attempts objPerson.Save( ) before it has been added to a
"ContactTyp e" the DB will throw an error becuase it does not have a
"ContactTypeID" . I can Validate the object before I attempt to save to the
DB by checking to see if the ContactTypeID property has been set; if not, I
can throw and exception with something like: "A Contact must be first added
to a ContactType before it can be saved to the DB".
Also, when I add the Contact to objEmployee, does the objEmployee.Add Contact
method need to reoginize that objPerson has not been saved yet, and then
automatically save it to the DB?
Thanks. I am just trying to figure out a standard for accomplishing this so
I can replicate the concept into projects I am working on....
Josh

[Ignacio Machin]

Hi,

If the only different among the different kinds of contacts is the type,
and the type is not dynamic I would suggest you to use an enum:
public enum ContactKind { Employee, Customer, Vendor }

then you can declare ContactType of that type:
public ContactKind ContactType{
get {}
set {}
}

By default the enum is of type int, so at load type you can cast it back
from an int :

contacttype = (ContactKind )( Convert.ToInt32 ( reader["ContactKin d "]));
//reading from a datareader

and at save you can do the opposite:
com.Parameters. Add("@ContactKi nd ", SqlDbType.Int). Value =
(int)this.conta cttype ;
Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"msnews.microso ft.com" <aa***@yahoo.co m> wrote in message
news:ec******** ******@tk2msftn gp13.phx.gbl...

What is the best solution for the following scenario:

I have a contacts database and I am creating the business layer obects to
access my data objects. (So the DB is invisible to the Business Layer
consumer)
Each contact can be of some type "Employee, Customer, Vendor, etc." . The
contact types are also stored in a table in the DB.

So in the business layer I am trying to a make a decision on how to model my object flow. Here are some examples:
---------------------------------
Method One:
Contact objPerson = new Contact();
objPerson.Name = "Jose";
objPerson.Addre ss = "666 somewhere street";
objPerson.City = "somecity";
objPerson.Conta ctTypeID = 3; //Each
objPerson.Save( );

Problem:
If the ContactTypeID does not exist in the DB there will be an error thrown by the DB. Also, when a user type objPerson.Conta ctType, I want it to
return a "ContactTyp e" object.

--------------------------------
Method Two:
Contact objPerson = new Contact();
.... Set Generic Properties ...
ContactType objContactType = objAppFactory.G etContactType(3 );
objPerson.Conta ctType = objContactType;

Problem:
This method allows me to throw an error as soon as the user tries to lookup a nonexistent ContactTypeID before assigning to the Contact. However, I
have the extra round trip to the DB. Seems silly

-------------------------------

Method Three:
I can could provide to ways of setting the ContactType.
objPerson.Conta ctType = objApp.GetConta ctType(3);
or
objPerson.SetCo ntactTypeID(3);

Problem:
Seems dumb

------------------------------

Method Four:
ContactType objEmployee = new ContactType();
Contact objPerson = new Contact();
objPerson.Name = "Jose";
objPerson.Addre ss = "666 somewhere street";
objPerson.City = "somecity";
objEmployee.Add Contact(objPers on);

Problem:
If the user attempts objPerson.Save( ) before it has been added to a
"ContactTyp e" the DB will throw an error becuase it does not have a
"ContactTypeID" . I can Validate the object before I attempt to save to the DB by checking to see if the ContactTypeID property has been set; if not, I can throw and exception with something like: "A Contact must be first added to a ContactType before it can be saved to the DB".
Also, when I add the Contact to objEmployee, does the objEmployee.Add Contact method need to reoginize that objPerson has not been saved yet, and then
automatically save it to the DB?
Thanks. I am just trying to figure out a standard for accomplishing this so I can replicate the concept into projects I am working on....
Josh