database - Inserting data to same table through multiple threads -

database - Inserting data to same table through multiple threads -

let's have 2 related tables, business relationship , user, user holds foreign key account. have 2,000 accounts, , need re-create 10,000 users 1 business relationship other 1,999 accounts. info goes user table. i've queried 10,000 users needs copied. have insert them in user table. that's count of (10000 x 1999 =) 199,90,000 rows.

i'm planning utilize multiple threads insert operation. need know how sql server handles concurrent request -

does uses multiple connections, 1 each thread? how insert info same table multiple threads provide them concurrently? since user table has identity column, insert operation can never concurrent. can approach of using multiple threads client end accomplish performance gain @ all? what improve scalable , faster way perform operation?

thanks in advance.

edit : i'm using entity framework 4.0, doesn't have back upwards mass re-create :(

database multithreading c#-4.0 entity-framework-4 concurrency