I have a service that I pull in member data from a customer
There are @ 20 columns and usually @ 5,000 records.
Is it more efficient in the C# Service to read the data into a datatable
Then... pass it all in at one time to SQL Server with Structured Data type
The Stored procedure takes the paramater and parses it as a type Suer Defined Table
Just read one line at a time from the customer and pass it into SQL Server one record at a time?