Large INSERT SQL Server 2000/C#

[Oscar Thornell]

Hi,

I have a large structure of associated domain object instances...something
around 100.000 objects at the top level..
There are about 7-8 classes involved so we are totally looking at about
800.000 objects..

All these objects must be persisted to the db. I dont wan´t to call the db
100.000 times so I would like to do a batch/bulk insert of around 5.000
objects wrapped within one transaction and repeat that until I am done...

I need to have control of this in the Business layer (everything is user
initiated..the use case could not be started by back-office/functional
support). I will do this asynchronously with a worker thread from the thread
pool.

Some basic info:
The triggering application is an ASP.NET application...all logic will be
performed on the server in the Business and Access layer. I need to keep
track of each object and when everything is done retrive the result back to
the ASP.NET app (could be done in a number of ways..so this is not such a
big issue..).

Any toughts and ideas are more than welcomed!

Regards
/Oscar