Click here to Skip to main content
15,880,392 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
My requirement is to expose a new operation contact in WCF service which has capability to process and save a batch of around 3000 to 5000 records in database and return uniqueId(database id) of each and every record in the batch?


Can anyone tell me the approch or sample for this functionality?
Posted

1 solution

Depending on the average size of a single record, you may not be able to pass that much info to a service.

If it were me, I'd write a web method that accepted 1-to-n "records", so I can adjust the load in my code. Make the max possible records you can pass at any given time 100 (or whatever number you're comfortable with), and start hitting the method (in a test environment) to see what happens.

I'm not sure why you'd want to actually return the ID's that were generated when the records were inserted, but hey, I'v had stranger requests. Just return them in a XML string.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900