Member Avatar for Acidburn

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 Storede 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.

  • 2 Contributors
  • 1 Reply
  • 94 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by lolafuertes
Member Avatar for lolafuertes

A stored procedure handling all necessary variables is a god solution to isolate he problem of inserting from your application.

Hope this helps

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.