Loading

dont use foreach loop to write xml in controller in mvc..

dont use foreach loop to write xml in controller in mvc..

sourabh choubey

10y944.NET

I don't want to use foreach loop to write the contents in xml.is there any other way so that we

can not use foreach loop inside the controller to write xml content..

Here is my code..

var blog = _api.GetAllBlogCategory().ToList();

StreamWriter writer = new StreamWriter(Server.MapPath("~/XmlFiles/BlogCategory.xml"));

writer.WriteLine(@"");

writer.WriteLine("");

foreach(var blogitems in blog)

{

writer.WriteLine("");

writer.WriteLine("");

}

writer.WriteLine("");

writer.Close();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sourabh choubey10y ago
hey manas i am using entityframework and mvc 3.this is my database sp
USE [CorpoHours]
GO
/****** Object: StoredProcedure [dbo].[sp_blogcategory] Script Date: 26-07-2016 16:03:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[sp_blogcategory]
as
begin
SELECT * from dbo.BlogCategory
FOR XML RAW ('CategoryBlog'), ROOT ('CategoriesBlog');
end
now it return sp now how to save it as xml.
Manas Mohapatra10y ago
You need to use LINQ to XML for creating XML content and store in text file:
XElement xmlfromdb = new XElement("CategoriesBlog",
from a in blog
select
new XElement("CategoryBlog", new XAttribute("ID", a.ID),
new XAttribute("Name", a.Name),
new XAttribute("ParentId", a.ParentID)
new XAttribute("Seo_Discription", a.seo_Discription)
new XAttribute("Seo_KeyWords", a.seo_keywords)));

xmlfromdb.Save(@"e:\\a.xml");
Console.WriteLine("File Saved");
Note: You may need to change the property blog object.