Kentico CMS has its own data layer components that ensure unified access to the database. Each entity, such as “user", “site", “document", has its own “data class". The data class represents the data structure of the entity (using the XML schema) and SQL queries for INSERT, UPDATE, SELECT and DELETE operations. The data layer is currently working only with Microsoft SQL Server, but it’s designed for use with other data engines in future.
How it Works
When you need to create a new user record, you create a new instance of DataClass type and specify its class name as “cms.user", which is a code name of this entity. The system automatically creates a new DataRow based on the user entity XML Schema. Then you set the values of its attributes, such as UserName or FullName and call the Insert method. The system uses pre-defined INSERT query to insert the values into the appropriate table that is also stored in the definition of the cms.user entity.