Saving XML file in a database along with other fields to SQL Server using Entity Framework [duplicate]

Question

I have the PersonDetails table in the database whose fields are given below :

ID    AutoGenerated field

PersonName  Int Not null

FailureDetails  XML not null

I have an xml file in my local drive D:\personFailureDetails.xml which needs to be saved in PersonDetails table along with other fields.

I am using entity framework to retieve and insert data to database.

Which is the best way to insert values into “PersonDetails” entity?

Which datatype is available to get the xml file to be stored in entity to be inserted into the “PersonDetails” table?

Pawel · Accepted Answer · 2013-10-11 05:15:42Z

2

EntityFramework does not support Xml properties so you will have to create a string property which you will save the xml as a string to when saving changes or load an xml document from after querying. I don't remember from the top of my head if you can insert strings to Xml columns directly - if not you may need to create a stored proc for saving the string as Xml in your db.

answered Oct 11, 2013 at 5:15

Pawel

31.7k4 gold badges76 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving XML file in a database along with other fields to SQL Server using Entity Framework [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related