Back in august of last year I published a post with a small coding example on how to make a Page Provider for the classic Northwind Database. Since it has turned out to be quite popular as a demo for Page Providers (I guess geeks get nostalgic over a thing like Northwind) I’ve re-implemented the sample to be based on the Mapped Page Provider (which took around 30 min). In the new sample there is even support for editing both product and category names.
Requirements: EPiServer CMS 5 R2 SP1, Enterprise License, “Public Templates” installed (the default website when you install an EPiServer) or at least a pagetype called “[Public] Standard page” with a “MainBody” XHTML property.
In order to get it to work on your EPiServer CMS, follow this guide:
- Install the northwind database (http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en)
- Put the assemblies from the zip in your local bin folder
- Create a page in your EPiServer CMS where you want to attach the Northwind products, make a note of the Page ID.
- Register it in web.config (change the entryPoint to your newly created page):
<pageProvider>
<providers>
<add name="NorthWind" type="EPiServer.Research.PageProviders.NorthwindProvider,NorthWindDemo" entryPoint="33" capabilities="Edit"/>
</providers>
</pageProvider> - In ConnectionStrings.config, add a connectionstring to your Northwind DB – call it “NorthwindConnectionString”.
You should be good to go!
Enjoy :-)
Recent posts