SqlBulkCopy Tutorial - Knowledge Base (KB)

SqlBulkCopy Cannot insert the value NULL into column

I am trying to Bulkinsert a certain list of custom objects into my database, using the fastmember (...Fastmember NuGet...) extension and sqlbulkcopy. However it gives me the following error:...An unhandled exception of type 'System.Data.SqlClient.SqlExcep...

Fastmember exception: Specified argument was out of the range of valid values. Parameter name: name

I've been encountering this error ...Specified argument was out of the range of valid values. Parameter name: name...When im almost just copying the example here ...https://code.google.com/p/fast-member/...The error happens on the bcp.WriteToServer(reade...

FastMember and nullable properties

i'm having an issue using fastmember, where by i have a public nullable property (datetime) for my class, but when i try and insert it into the db the column value is an empty string an not a null, which causes an exception to be thrown, any ideas on how ...

Trying to map a .NET string[] to a FastMember object but it's erroring/not mapping

I'm trying to insert a list of file names into a simple Sql Server table....I'm trying to leverage SqlBulkCopy and ...@markgravell's FastMember... library, as suggested by other SO answers....public async Task AddFileNamesAsync(string[] fileNames) { f...

SqlBulkCopy with ObjectReader - Failed to convert parameter value from a String to a Int32

I am using SqlBulkCopy (.NET) with ObjectReader (FastMember) to perform an import from XML based file. I have added the proper column mappings. ...At certain instances I get an error: Failed to convert parameter value from a String to a Int32. ...I'd like...

How do I Use FastMember to create a reader of an object with child object

We need to ...SQLBulkCopy... a collection that we have. And since we need an IDataReader to use SQLBulkCopy, I tried to use FastMember for that. As I understand, we can use ...FastMember... to create an ...IDataReader... from an IEnumerable....So my code ...