IrowSetFastLoad use in C#

Posted on 2009-12-20
Last Modified: 2012-05-08
hi experts

i know that in C++ we can use oledb object called IrowSetFastLoad.
do we have it in C# also ? or we should use only the SQLXMLBULKLOADLib ?
from some reason my superior is convince that only in C++ we can do it.
can someone assist?


Question by:gudidi
    LVL 2

    Accepted Solution

    IrowSetFastLoad feature is not available with the current ADO.NET implementation.

    You might want to look at using the SQLXML toolkit (SQLXMLBULKLOADLib )... it has some bulk
    load features.

    Author Comment

    so if i work with SQLXMLBULK, and i did alredy such a program, is there a way
    to load the file in parts like the irowset?
    for example if i have file of 20000 records and i want to load it 100 after record: is it possible?
    or should i load all the file in C#?

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
    The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now