How to insert xml file in sqlserver Table XML type column

Question

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 .........

Zoran Horvat · Answer

Do you have anything else but this error message? Is there an inner exception contained within this one? Can you post the CREATE TABLE script which regards the BUSINESS_ENTITY_BEN table. Also it would help if you could paste part of the C# code used to call the database which results in this error. Zoran