Last post Oct 02, 2020 11:25 AM by mgebhard
Oct 02, 2020 08:20 AM|mark1961|LINK
I am working on an ASP.NET application of framework version 2.0 and need to read in a CSV file, store the row data and do checks against database records for each row. File can contain up to 20,000 rows of data.
What would be the best approach to use for storing this data as i would also like it to also persist for the session and be as efficient as possible perhaps using the BackgroundWorker class?
Oct 02, 2020 11:25 AM|mgebhard|LINK
The standard approach is importing the data using standard tools found in SQL server. That's what databases tools are for.