SQL Bulk insert bit column

Question

I have a column in the table Person

IsApproved bit NULL,

I have a class Person with below property

bool? IsApproved { get; set; }

When I try to bulk insert values in Person table with Person.IsApproved value set to null, it gives the below exception.

cannot change datatype of a column once it has data.

Please help me how to store NULL value in the IsApproved column using bulk insert.

Code: SqlBulkCopyHelper.BulkInsert(_db, persons). Where persons are the List — Aamir, Apr 11 '17 at 13:45

score -2 · Answer 1 · edited Apr 11 '17 at 07:35

-2

Set Person.IsApproved from null to System.DBNull.Value in visual studio.

edited Apr 11 '17 at 07:35

Draken

answered Apr 10 '17 at 20:53

user7847194

You can't set a Boolean, even a nullable one, to `System.DBNull.Value`. – mallan1121 Apr 10 '17 at 21:07
1

IsApproved is a bool? field. Assigning DBNull.Value gives "cannot implicitly convert type system.dbnull to bool?" error – Aamir Apr 10 '17 at 21:09

1 Answers1