Avatar of Larry Brister
Larry Brister
Flag for United States of America

asked on 

MS SQL Server 2008, C# and User Defined Tables

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?
Microsoft SQL ServerC#.NET Programming

Avatar of undefined
Last Comment
Larry Brister

8/22/2022 - Mon