sitemaps.xml in asp.net mvc

Question

My website has dynamic content, new links are being created.

my db has a table which pretty much contains all the added urls.

So my question is how importnt is it for me to have sitemaps.xml, and also is there a simple way to build it so that when new links are generated i can tag it to the end of a sitemap.xml file?

SLaks · Accepted Answer · 2011-02-17 14:07:10Z

2

You can use LINQ to XML to create an XML sitemap from your database, then return the sitemap from an action by returning Content(document.ToString(), "text/xml").

answered Feb 17, 2011 at 14:07

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

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

10 Comments

raklos Over a year ago

the problem is how do i go about newly added urls, because i dont want it to have to loop through all the urls's everytime the crawler hits it.

SLaks Over a year ago

@raklos: You should loop through the URLs every time. There's nothing wrong with that.

SLaks Over a year ago

If you really want to, you can run code that writes the file to disk whenever the database is changed, but I wouldn't recommend it.

raklos Over a year ago

if i choose your way, would displaying just the previous weeks links be enough? - as in google will still have records of older links. also instead of linq to xml could i populate the xml within a razor view?

SLaks Over a year ago

@raklos: No; you should always list all links. There is no point in using Razor here; it would be easier to use LINQ to XML to generate a string. However, you can if you want to.

|

profanis · Accepted Answer · 2011-02-17 10:59:10Z

2

It is important for crawlers to be able to crawl your site quicker and with more accurate.

You can create a controller, say siteMapController and in Index add the following

 public ActionResult Index() {
        var xmlString =
            "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd\">";

        xmlString +=
                "<url>" +
               "<loc>Your site</loc>" +
               "<changefreq>weekly</changefreq>" +
               "<priority>0.6</priority>" +
             "</url>" +
           "<url>" +
                    "<loc>Static Link of you site</loc>" + //you can add as many you want
                       "<changefreq>weekly</changefreq>" +
                       "<priority>0.6</priority>" +
                    "</url>" +
                    "<url>";


           //Dynamic links
            xmlString += "<url>" +
                         "<loc>Link of new item"</loc>" +
                         "<lastmod>" + DateTime.Now.ToString("yyyy-MM-dd") + "</lastmod>" +
                         "<changefreq>daily</changefreq>" +
                         "<priority>0.8</priority>" +
                         "</url>";
        }
        xmlString += "</urlset>";
        ViewData["siteMap"] = xmlString;
        return View();
    }

save the xml on your server and post the sitemap via this link

https://www.google.com/webmasters/tools/home?hl=en

hope that helps

answered Feb 17, 2011 at 10:59

profanis

2,7513 gold badges39 silver badges51 bronze badges

2 Comments

Drew Noakes Over a year ago

What if you have 20,000 dynamically generated pages on your site? Should you include them all in the site map, or will Google disregard such a large entry. Also, you should generally avoid building XML via string concatenation. Either write directly to the response stream or use the XML APIs or a StringBuilder in the worst case.

raklos Over a year ago

okay so this will giveme an xml file at mysite.com/sitemap ? the problem is, when newly created links are added to the db will i have to rerender the entire xml file?

Collectives™ on Stack Overflow

sitemaps.xml in asp.net mvc

2 Answers 2

10 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related