Book Image

Sitecore Cookbook for Developers

By : Yogesh Patel
Book Image

Sitecore Cookbook for Developers

By: Yogesh Patel

Overview of this book

This book will get you started on building rich websites, and customizing user interfaces by creating content management applications quickly. It will give you an insight into web designs and how to customize the Sitecore architecture as per your website's requirements using best practices. Packed with over 70 recipes to help you achieve and solve real-world common tasks, requirements, and the problems of content management, content delivery, and publishing instance environments. It also presents recipes on Sitecore’s backend processes of customizing pipelines, creating custom event handler and media handler, setting hooks and more. Other topics covered include creating a workflow action, publishing sublayouts and media files, securing your environment by customizing user profiles and access rights, boosting search capabilities, optimising performance, scalability and high-availability of Sitecore instances and much more. By the end of this book, you will have be able to add virtually limitless features to your websites by developing and deploying Sitecore efficiently.
Table of Contents (20 chapters)
Sitecore Cookbook for Developers
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

Using a wildcard item to integrate external content


You have learned different ways to render the Sitecore content, but sometimes, we may need to fetch some data from external systems such as an external database, feeds, and so on, and render them on Sitecore.

In this recipe, we will consider an example of pulling news from an external database. On requesting, http://sitecorecookbook/News/2015 will pull news details of the year 2015.

Getting ready

In this recipe, we are pulling news details from an external database. Create a News table, as shown in the following image:

How to do it…

We will see how a wildcard item can support any virtual request on Sitecore:

  1. In the SitecoreCookbook project, create a new controller NewsController class to fetch news details from an external database and register it in Sitecore:

    public class NewsController : Controller
    {
      public ActionResult NewsListing()
      {
        string year = WebUtil.GetUrlName(0);
        string strSQL = "SELECT * FROM News WHERE year(NewsDate)=...