Larry Brister
asked on
C# and SQL Server with User Defined table
I have a C# Web Service that accepts inbound JSon Data
Uses newton soft to parse and a function to place into a .Net DataTable
I then pass that DataTable into SQL Server Stored procedure as a type Structured
My Stored proc accepts the TYPE
Inserts data into a table
Works clean and smooth
I have now learned that I will begin receiving the data instead of 5-10 records at a time (Dtatable is 10 columns)
But around 50K records.
So my question...
Will my service handle this ok?
Web Service and SQL Server instance are on the same server
Uses newton soft to parse and a function to place into a .Net DataTable
I then pass that DataTable into SQL Server Stored procedure as a type Structured
My Stored proc accepts the TYPE
Inserts data into a table
Works clean and smooth
I have now learned that I will begin receiving the data instead of 5-10 records at a time (Dtatable is 10 columns)
But around 50K records.
So my question...
Will my service handle this ok?
Web Service and SQL Server instance are on the same server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey guys,
I just learned that the data will come to me in batches with a max size of 1MB.
That seems very manageable?
The bulk copy would be an option if I were the one controlling the inbound data... but I am not.
SQL 2016 is at least a year away.
I just learned that the data will come to me in batches with a max size of 1MB.
That seems very manageable?
The bulk copy would be an option if I were the one controlling the inbound data... but I am not.
SQL 2016 is at least a year away.
ASKER
Thanks
This is my preferred method for importing large chunks of external data into a database. It has the added bonus of allowing me to write whatever business logic I need in C# to ensure the best data result.