SqlBulkCopy Tutorial - Knowledge Base (KB)

The given value of type String from the data source cannot be converted to type int of the specified target column

I am trying to read values from xml file and then use the bulkcopy to insert the data into my database....I am using a custom class which is:...class Customer { public int CustomerID { get; set; } public string FirstName { get; set; } ...

XML string to Varbinary(MAX) using LinqToEntities

I have serialized a database values to XML and kept it inside the Apps debug folder. Now i want to deserialize it and insert to SQL database....Here is what i did:...XmlDocument XDoc = new XmlDocument(); XDoc.Load("Serialized.xml"); ...