Naresh Babu Gopavaram

Naresh Babu Gopavaram

  • 1.5k
  • 248
  • 249.3k

How to insert xml file in sqlserver Table XML type column

Jul 18 2011 1:40 AM
hi i am generate xml(serialization) file from location object .and i need to store it in Sqlserver xml datatype column with fluent nhibernate, but when i am trying to inser it gives the following error 



could not insert: [VAM.DealFoundry.Entities.BusinessEntity][SQL: INSERT INTO DealFoundry.BUSINESS_ENTITY_BEN (ID_OFR_BEN, CODE_BEN, DESCRIPTION_BEN, DETAILS_XML_BEN, CREATED_BY_BEN, MODIFIED_BY_BEN, CREATED_DATE_BEN, MODIFIED_DATE_BEN, ID_PARENT_BEN) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()]


Any one help me please .........


Answers (1)