Vendr is now Umbraco Commerce

Vendr is now part of Umbraco HQ and is being replaced by Umbraco Commerce. Click here to jump to the Umbraco Commerce documentation.

Configuring SQLite support

How-To Guide to configure SQLite support for Vendr, the eCommerce solution for Umbraco

Out of the box Vendr v3+ only supports SQL Server based databases as this is the recomended database platform for live environments. To aid testing and rapid prototyping however, Vendr can be configured to use a SQLite database.

Whilst Vendr does support SQLite for testing, we do not recommend using it in a live environment. Due to the high levels of active connections required to manage concurrent shopping carts, this is not something SQLite handles well at all.

Installing the SQLite dependencies

To add SQLite support, you'll need to install the SQLite persistence layer NuGet package for Vendr.

PM> dotnet add package Vendr.Persistence.Sqlite

Once the NuGet package is installed, you'll then need to register SQLite support with Vendr via the IVendrBuilder interface.

.AddVendr(vendrBuilder => {

If you have setup Umbraco to use SQLite, this should be all you need to do as Vendr will use the same database connection string as Umbraco, but if you wish to install Vendr into it's own SQLite database you can configure it's own connection string like so.

    "ConnectionStrings": {
        "umbracoDbDSN": "Data Source=|DataDirectory|/Umbraco.sqlite.db;Cache=Shared;Foreign Keys=True;Pooling=True",
        "umbracoDbDSN_ProviderName": "Microsoft.Data.SQLite",
        "vendrDbDSN": "Data Source=|DataDirectory|/Vendr.sqlite.db;Mode=ReadWrite;Foreign Keys=True;Pooling=True;Cache=Shared",
        "vendrDbDSN_ProviderName": "Microsoft.Data.SQLite"

Edit this page on GitHub

Site + logo design © 2024 Outfield Digital Ltd. Content contributions licensed under MIT.
Vendr® is a Registered Trademark of Outfield Digital Ltd.