zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

7 results for: in tag: c#-4.0

sqlbulkcopy batch sizing in relation to number of rows in datatable

Do i need to ensure that each batch is completely full? ie if i had a datatable with 12028 rows, could i just use a batch size of 10k and it would automatically create 2 batches, 1 with 10k in and 1 with 2028 in?...Thanks.
c# c#-4.0 sqlbulkcopy
asked by Hans Rudel

sqlbulkcopy with notifyafter and transactions

I have the following code, which im trying to use to test out if its possible to have transactions and a notifyAfter property used to raise an event(i have already tried substituting the event for one i create/raise myself but it only gets raised after al...
c# c#-4.0 sql sqlbulkcopy
asked by Hans Rudel

SQLBulkCopy with Identity Insert in destination table

I am trying to insert a Generic list to SQL Server with SQLBulkCopy,...And i have trouble wit Identity Field...I wan t my destination table to generate identity field How should i handle this, here is my code...using (var bulkCopy = new SqlBulkCopy(Config...
c#-4.0 sqlbulkcopy sql-server-2008
asked by HaBo

C# Bulk Insert SQLBulkCopy - Update if Exists

Possible Duplicate:...Any way to SQLBulkCopy “insert or update if exists”?...I am using ...SQLBulkCopy... to insert Bulk records...How can I perform on update (rather than an insert) on records that already exist? Is this possible with ...SQLBulkCopy...?....
bulkinsert c#-4.0 sqlbulkcopy
asked by HaBo

Is it possible to do data type conversion on SQLBulkUpload from IDataReader?

I need to grab a large amount of data from one set of tables and SQLBulkInsert into another set...unfortunately the source tables are ALL varchar(max) and I would like the destination to be the correct type. Some tables are in the millions of rows...and ...
c#-4.0 mapping sqlbulkcopy
asked by BlueChippy

Weird "OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].Value' error

Software used: Windows 7 64 bit Ultimate, .Net 4, SQL Server 2008 R2....select @@version returns:...Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows...
c#-4.0 sqlbulkcopy sql-server-2008-r2
asked by costa

How to add new column in SQL Server using SqlBulkCopy which is not present in Excel using asp.net

I am creating an application which will upload data from Excel to SQL Server using ASP.NET. I know how to upload Excel data using ...SqlBulkCopy.... But I am trying to upload some extra data for the table column (...addeddate..., ...addedby......etc) whic...
asp.net c#-4.0 sqlbulkcopy sql-server
asked by Kishor Kulkarni

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...