Solved

.Net Saving Class data efficiently

Posted on 2014-02-18
1
311 Views
Last Modified: 2014-02-21
Hi

I have created a number of .Net classes (based on a JSON string)

What is the fastest way to save my set of .Net classes to the DB.

Should I create a dataset filled with data tables for each class and save the data this way.

I need the save to be as fast as possible. We are dealing with a lot of data.

Kind Regards
0
Comment
Question by:dfincham28
1 Comment
 
LVL 7

Accepted Solution

by:
Kishan Zunjare earned 500 total points
Comment Utility
You can use datatable and for insertion you can use property of BulkCopy

http://www.codeproject.com/Articles/16922/SQL-Bulk-Copy-with-C-Net


Hope this helps
-Kishan
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video discusses moving either the default database or any database to a new volume.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now