Hey guys,

I've got 2 tables...

Computer

Motherboard

now computer has a FK constraint from Motherboards PK so I can no longer do a simple insert without having the motherboard present. That all works correctly.

Now in my ADO I've got an insert statement on Computer which calls a stored proc. Should I pass all my variables to the Stored proc? and call internally other Stored procs from the main one?

Or should ADO be able to handle mapping? I'm confused how I can tell my ADO to insert into Motherboard first and then insert into Computer.

you can pass all values to same procedure and using the values for motherboard table first insert the record and declare a variable to store the identity of the motherboard table that will be used in the computer's table

e.g

insert into motherboard (col1, col2, col3, ......)
values (@Para1, @Para2, @Para3,....)

Declare @ID
SET @ID = @@SCOPE_IDENTITY

insert into computer (col1, col2, col3, .... , col_fk_motherboard)
values (@Para4, @Para5, @Para6, .... , @ID)


Regards,
Akaas Developer
http://www.questions-interviews.com/...hnologies.aspx