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

SqlBulkCopy Tutorial - Knowledge Base (KB)

4 results for: in tag: insert

How to insert null value for numeric field of a datatable in c#?

Consider My dynamically generated datatable contains the following fileds ...Id,Name,Mob1,Mob2...If my datatable has this it get inserted successfully,...Id Name Mob1 Mob2 1 acp 9994564564 9568848526 ...But when it is like this it gets failed sa...
c# insert null numeric sqlbulkcopy
asked by ACP

Fast inserts; BulkCopy with relational data

I have a large amount of constantly incoming data (roughly 10,000 a minute, and growing) that I want to insert into a database as efficiently as possible. At the moment I'm using prepared insert statements, but am thinking of using the SqlBulkCopy class t...
insert sql sqlbulkcopy sql-server
asked by Barguast

Copying data from table1 to table2, with slightly different datatypes, names and additional column

Im running a task where i need to copy data from ...table1... to ...table2.... ...table1... is generated from a very old application which has a tendency of creating unusual datatypes, such as decimal etc. (these are unnecessary). ...So the structures are...
insert mysql sql sqlbulkcopy
asked by JavaCake

Update / Insert to SQL table using datatable with column mappings

I'm wanting to do a bulk copy of data from one database to another. It needs to be dynamic enough so that when the users of the source database create new fields, there are minimal changes at the destination end(my end!). ...I've done this using the ...sq...
c# datatable insert sql sqlbulkcopy
asked by csharper

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...