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

SqlBulkCopy Tutorial - Knowledge Base (KB)

3 results in tag: mapping

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

sqlbulkcopycolumnmapping import csv to table issue

I am at a loss. I am trying to import columns from a csv into an existing data table. I believe the best way to do this is through column mapping using sqlbulkcopy but i just cant wrap my head around this. Im using the script below with the out-datatable ...
mapping sql sqlbulkcopy sql-server
asked by user2402045

Set constant value to some columns in SqlBulkCopy

I'm trying transfer data from ..."csv"... file to SQL Database. Is it possible to map some fields by default vale which not exsits in ..."csv"... file? Something like shown below: ...bulkCopy.ColumnMappings.Add("Destenition_column_name", "constant_value")...
c# csv mapping sqlbulkcopy
asked by user3818229

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!