Connection String¶

Connection String Modifier¶

The DefaultConnectionStringModifier service is designed to modify database connection strings based on a tenant name. This is particularly useful in multi-tenant applications where each tenant has its own database.

The following connection strings for the specified database providers are supported;

• MsSQL
• MySQL
• Postgre
• Oracle
• Cosmos
• Firebird
• Sqlite

Installation¶

If you want to install connection string modifier;

• Add the GridLab.Abp.ConnectionString NuGet package to your project:

  Install-Package GridLab.Abp.ConnectionString

• Add the AbpConnectionStringModule to the dependency list of your module:

  [DependsOn(
      //...other dependencies
      typeof(AbpConnectionStringModule) // <-- Add module dependency like that
  )]
  public class YourModule : AbpModule
  {
  }
  

Using Connection String Modifier¶

The connection string is automatically generated for each customer based on the given connection string.

public class SomeService
{
    private readonly IDefaultConnectionStringModifier _connectionStringModifier;

    public SomeService(IDefaultConnectionStringModifier connectionStringModifier)
    {
        _connectionStringModifier = connectionStringModifier;
    }

    public void SomeMethod()
    {
        string originalConnectionString = "Data Source=myServer;Initial Catalog=myDB;Integrated Security=true;";
        string tenantName = "customer";

        string modifiedConnectionString = _connectionStringModifier.Modify(originalConnectionString, tenantName);

        // Use the modified connection string
    }
}