Yugeen Klimenko
Feb 18, 2011
(0 votes)

The EPiServer Pages and Properties From the Database Point Of View.

The database diagram describing relations between EPiServer pages and their properties is given below.image

As you can see the tables tblPage and tblWorkPage are connected with “one – to - many ” relation. The main record about the page is stored in tblPage and the page  versions records are saved in the tblWorkPage. The query getting all the versions for the page with id = 49 looks this way:

select * from tblPage p
join tblPageType pt on p.fkPageTypeID = pt.pkID
join tblWorkPage wp on wp.fkPageID = p.pkID
where p.pkID = 49

When you create new page new record is added to the tblPage table. Everytime you publish  new version of the page the correspondent record is inserted into the tblWorkPage. Information about the page current version is stored in tblPageLanguage.PublishedVersion field which can  contain one of the tblWorkPage.pkID values.

Evidently, if you need to get the properties values for the given page version ( f.e.130)  you should execute

select * from tblWorkProperty where fkWorkPageID = 130,

where fkWorkPageID is a foreign key to tblWorkPage. So in much the same way the tblWorkProperty table keeps the history of properties values and tblProperty contains just a single record about given property – the value when created.

Feb 18, 2011


senthil Kumar
senthil Kumar Dec 20, 2011 05:48 PM

Hi Yugeen, Thanks a lot, very useful information for a beginner like me.

Oct 21, 2014 09:54 AM

If I want to change a parent of a particular page from node1 to node2, which tables shall I look at?
Right now I have used the query below
update tblpage
set fkparentid = [new parent id]
where pkid = [id of the page]
This does change the node, but when I use the GetParents, it still points to the old node


Sofia 'Sonya'
Sofia 'Sonya' Feb 26, 2020 07:54 PM

Thank you, Yugeen! This has been very helpul.

I noticed that in Episerver version 10.10,  tblPage, as well as other tables you mentioned, are actually a Views in a database.



Please login to comment.
Latest blogs
Performance optimization – the hardcore series – part 2

Earlier we started a new series about performance optimization, here Performance optimization – the hardcore series – part 1 – Quan Mai’s blog...

Quan Mai | Oct 4, 2023 | Syndicated blog

Our first steps into local AI

After a consumer of tools like ChatGPT and CoPilot, we as developers like to dive deeper into it. How does it work? Where to start? Can I create my...

Chuhukon | Oct 4, 2023 | Syndicated blog

Update on .NET 8 support

With .NET 8 now in release candidate stage I want to share an update about our current thinking about .NET 8 support in Optimizely CMS and Customiz...

Magnus Rahl | Oct 3, 2023

Adding Block Specific JavaScript and CSS to the body and head of the page

A common requirement for CMS implementations includes the ability to embed third party content into a website as if it formed part of the website...

Mark Stott | Oct 3, 2023