Customization of the data provider allows you to implement your own database connector.
The customizations must be added as part of a new assembly, which you then need to register via the CMSDataProviderAssembly web.config key.
Custom data providers are not intended for accessing non-Microsoft SQL Server database engines. They only allow you to modify how queries are executed against the Microsoft SQL Server.
Customizing live site projects
Deploy the assembly containing the custom provider to your live site (MVC) application, in addition to the Xperience administration application. This ensures that the customization applies when loading or modifying data in the live site application.
Adding the custom data provider assembly
- Open your administration solution in Visual Studio.
- Add a new Class Library project to the solution, for example named CustomDataProvider.
- Add the Xperience API libraries to the new project:
- Right-click the solution in the Solution Explorer and select Manage NuGet Packages for Solution.
- Select the Kentico.Xperience.Libraries package.
- Install the package into the custom project (the version must match your MVC project's Kentico.Xperience.AspNet.Mvc5 package and the exact hotfix version of your Xperience administration project).
- Reference the CustomDataProvider project from the Xperience web project (CMSApp).
- Open your Xperience program files directory (by default C:\Program Files\Kentico\<version>) and expand the CodeSamples\CustomizationSamples\CustomDataProvider subfolder.
- Copy the following files into the CustomDataProvider directory in your web project:
- Include the new files into the CustomDataProvider project in Visual Studio:
- Expand the CustomDataProvider project in the Solution Explorer.
- Click Show all files at the top of the Solution Explorer.
- Select the new files while holding the Ctrl key.
- Right-click one of the files and select Include in Project.
- Edit the copied files and rename the namespaces to exactly match the assembly name of your custom project (CustomDataProvider in this example).
- Rebuild the solution.
The CustomDataProvider project is now integrated into your application. By default, the classes in the custom data provider are identical to the ones used by default, but you can modify them according to your own requirements.
Registering the custom data provider
- Edit your application's web.config file.
Add the following key to the configuration/appSettings section:
<add key="CMSDataProviderAssembly" value="CustomDataProvider"/>
The system loads the DataProvider class from the assembly specified as the value of the CMSDataProviderAssembly key.
Your application now uses the custom data provider for handling of database operations.
Was this page helpful?