C# copy data between databases -

what fastest method copying data between databases in c#? want create c# database procedure accepts query string parameter , inserts data database (sql query , destination table have same columns).

i use sqlbulkcopy right causes problems.

i know you've asked c# in post, might want consider couple of other methods, using stored procedure create. of below in stored procedure itself.

have considered t-sql approach using openrowset() way, never have pull data on c# , send on sql server. find recommendations microsoft here , here the specific link using openrowset()

if want use c# still, can use ssis, has ability copy data in bulk mode between servers, , can call c# using appropriate package you'd have create (visual workflow). please see this thread details.