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

SqlBulkCopy Tutorial - Knowledge Base (KB)

4 results in tag: dataset

Could managing errors with SqlBulkCopy be any more difficult?

Running very low on ideas here. I've got a case where I'm using SqlBulkCopy to pump data into a DB, and about halfway through I run into different exceptions (primary key violations, index violations, etc)....I've confirmed that the violations are in fact...
dataadapter dataset exception sqlbulkcopy
asked by David Catriel

Importing XML data into a SQL database using sqlBulkCopy

I'm having proplems with importing an XML file using ...SqlBulkCopy.... The XML file looks like this:... <root> <Automobiles> <Car Id="1" Name="SomeModel1"/> <Car Id="2" Name="SomeModel2"/> <Car Id="3" Name="SomeModel2"/> ...
.net dataset sqlbulkcopy xml xmldocument
asked by ilkin

Cut characters out of dataset before insert

I am running a sql query which stores results in dataset and then if dataset has rows it will run a query to insert into table. The problem is the data that is coming out is string and is saved as 001234 whereas I want the data to be stored in my table a...
c# dataset sql sqlbulkcopy
asked by Alexandria

How Transform OracleAdapter Dataset to SQL BulkCopy

I've successfully used the ...Oracle.ManagedDataAccess.Client... to fetch data from an Oracle server into a ...Dataset..., and used ...SqlBulkCopy... to insert that ...Dataset... into a SQL database where the tables have matching columns names (see below...
dataset oracle oracle-manageddataaccess sqlbulkcopy vb.net
asked by Wowdude

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...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!