Text format ,from DB (where the XML is Already done in DB)

Question

Please tell how to get result in simple Text Format. ,O'm already getting the XML from DB done By FOR XML AUTO , So now i just need the raw text which is XML from DB

Nilesh Shah · Answer

once you have XML from DB, you can get values from node using Linq for XML. always post some code with question

Laxmidhar Sahoo · Answer

the entity frame work could not map to temperary table and xml so retrive the data from xml in sql and insert into a table .then Retrive the data from the table using ado.net

Hemanth DJ · Answer

Thank you all for the reply ,Im using ADO.net Entity Frame Work , I have my StoredProcedure called into the Entity FrameWork. But when i call the Store Procedure i GEt method i get error in browser and I'm running in localhost And Get method returns only XML and JSON i need plain text. I have attached my ScreeknShots please go through and suggest. PS : I have the XML created in DB itself by FOR XML type , i have saved that query as a StoredPRocedure and calling it in my WebApi Get method.

Laxmidhar Sahoo · Answer

whethjer you are use linq or ado

Text format ,from DB (where the XML is Already done in DB)

Answers (4)