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 .........
Loading
Zoran HorvatPosted Jul 21, 2011, 12:02 PM
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