Updating Tables In Sequence With Primary Key And Foreign Key Relations

Hi all,

       In my project i will have the  data in a collection of objects, I need to update series of tables with foreign key relations

       Right now my code looks like this

       foreach(object obj in Objects){

       int accountId=Account.Insert(obj.accountOpenDate,obj.accountName);//this will update the accounts table and returns account id which is a Identity column in Acccounts table

       int DebtId=Debt.Insert(accountd,obj.debtamount,obj.debtbalance); this will update the Debts table and returns DebtId

       ///series of tables like above but all the relevant data comes from obj and in the Insert Methods i am using stored procedures to Insert the data into table

       }

      The no of objects varies from 1000 to 1 milliion,, with this approach its taking more time to update all the data. Please let me know if any alternative procedure to handle this kind of scenario.

 

Thanks

Regards

Prasad.