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

SqlBulkCopy Tutorial - Knowledge Base (KB)

3 results in tag: null

In C#, how can I enter a null value for a datatable's numeric field?

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

SqlBulkCopy into table that Default column values fails when source DataTable row has DBNull.Value

Update: ...Here is my solution...I have a table defined as:...CREATE TABLE [dbo].[csvrf_References] ( [Ident] [int] IDENTITY(1,1) NOT NULL, [ReferenceID] [uniqueidentifier] NOT NULL DEFAULT (newsequentialid()), [Type] [nvarchar](255) NOT NULL,...
c# default-constraint null sqlbulkcopy sql-server
asked by James Nix

C# SQL Bulk Copy: Column returning "null" halfway

When I am using SQL Bulk Copy, my columns return "null" halfway through the insert... ...The only thing I can think of is because of special characters such as ".../..." and "...-...". Is it at all possible to escape chars in SQL bulk Copy?...I've tried l...
c# excel import null sqlbulkcopy
asked by Mokey

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!