Setup SQL Server session state for a web farm

It takes a bit of digging around to get all the information needed to setup out-of-process session state for an ASP.NET web farm. There are a couple of decisions that you need to make and then you need to configure the database and the application. This post explains all this using a real-life project.

“Setup SQL Server session state for a web farm” verder lezen

Kentico Dutch Localization Pack on GitHub

Most of our clients are native Dutch speakers so we want to provide them with a proper Dutch user-interface in the Kentico adminstration site.

Unfortunately the Dutch Localization Pack available on the Kentico site is not up to date at the time of writing. This results in a quirky mix of Dutch and English in the Kentico UI.
We have already done translations for some sections in recent projects but we really want to consolidate those efforts.

Calling upon the Kentico community

Instead of keeping this to ourselves we believe inmaking the Kentico community stronger by sharing.

So, we’re now calling upon the Dutch-speaking Kentico community to collaborate with us. If we all do a bit of the work we can make a big improvement and make our Kentico customers even happier.

Contribute on GitHub

We’re looking forward to your pull-requests on Github : TrueLimeNL/Kentico.LanguagePack.NL

Kentico + MVC – Fix the split admin site

One of the options you have when using Kentico with MVC is to split the site into an administrative site and a public-facing site.
This is a nice separation of concerns so I would definitely reccommend this, if budget permits of course.
There’s a small snag with this though. By default a Kentico instance will show you the home page, but there is no content in an MVC site; it doesn’t have layouts and master pages defined in the CMS. Somehow that makes the site end up in an infinite redirection loop.

We’ve had to instruct editors to go to the /Admin url manually. This works but it’s an annoyance the customer doesn’t need.
“Kentico + MVC – Fix the split admin site” verder lezen

Kentico DataQuery API – Hydrating a datarow

When working with Kentico’s APIs you sometimes end up with a DataSet. A good example of this is the Search API. For use with transformations in the PortalEngine that’s usually not an issue. MVC however is very much geared towards dealing with strongly typed data. Fortunately you can easily go from a data row to a page or module class using the InfoDataSet class.
“Kentico DataQuery API – Hydrating a datarow” verder lezen

Kentico DataQuery API – Sub-selects

In lots of projects a requirement pops up to count the number of items in a sub set; the number of products in a category for example.

In SQL you’d probably solve this with a sub select or a Common Table Expression (CTE) for more complex scenario’s.

With the Kentico Data API you can do subselects as well.
“Kentico DataQuery API – Sub-selects” verder lezen

Kentico DataQuery API

In recent projects we’ve been making heavy use of the Kentico DataQuery API. This API was introduced in Kentico 8 to replace the provider-based data access methods.
It’s sort of like Linq but not quite the same, though you can mix it with Linq to some degree.

In upcoming posts I’ll dive into some of the gritty details and share some of the lessons learned while applying the Kentico DataQuery API in real life projects, both with the classic Portal engine and MVC.
“Kentico DataQuery API” verder lezen