hello,

i'm trying to design a 3 tier architecture but have come on a few problems.

i want the DAL layer and the BO layer to communicate via objects.

every object has a unique id.

for example an object task has an id that is generated by the database.

i want the DAL layer to set the id of this field when performing save for the first time.

i don't want the BO layer to be able to set this field.

how can this be done?

thanks,

TaLz

In SQL Server Books Online, read into the use of the IDENTITY option on columns. When a row is inserted, the value of the identity column will assigned an incremented integer value.