3

I want to manage multiple database connection in my application.I am using ASP.NET Core & linq2db. For my first database connection i have create below configuration and its working fine.

public class DatabaseXSettings : ILinqToDBSettings
{
    public IEnumerable<IDataProviderSettings> DataProviders
    {
        get { yield break; }
    }

    public string DefaultConfiguration => "Oracle.Managed";
    public string DefaultDataProvider => "Oracle.Managed";

    public string ConnectionString { get; set; }

    public DatabaseXSettings(string connectionString)
    {
        ConnectionString = connectionString;
    }

    public IEnumerable<IConnectionStringSettings> ConnectionStrings
    {
        get
        {
            yield return
            new ConnectionStringSettings
            {
                Name = "DatabaseX",
                ProviderName = "Oracle.Managed",
                ConnectionString = ConnectionString
            };
        }
    }
}

public static class DatabaseXStartup
{
    private static bool _started;
    public static void Init(string connectionString)
    {
        if (!_started)
        {
            DataConnection.DefaultSettings = new DatabaseXSettings(connectionString);
           _started = true;
        }
    }
}

public class DatabaseX : DataConnection
{
    public DatabaseX() : base("DatabaseX") { }
}

For My Second Database

For my second database connection i create a similar configuration like this. But this not working. 

public class DatabaseYSettings : ILinqToDBSettings
{
    ....... 
}

public static class DatabaseYStartup
{
    .......
}


public class DatabaseY : DataConnection
{
    public DatabaseY() : base("DatabaseY") { }
}

My appsettings.json

  {
"Logging": {
    "LogLevel": {
        "Default": "Warning"
    }
},
"AllowedHosts": "*",
"ConnectionStrings": {
    "DatabaseX": "Data Source=..........",
    "DatabaseY": "Data Source=.........."
}

}

LinqToDB.LinqToDBException: 'Configuration 'DatabaseY' is not defined.'

Is there any other way to do that.

Muhammad Azim
  • 329
  • 1
  • 2
  • 14

1 Answers1

4

Edit: added example

You don't need two ILinqToDBSettings instances. You should move second database settings to first settings class, so ConnectionStrings will return both connection strings.

public class DatabaseSettings : ILinqToDBSettings
{
    public IEnumerable<IDataProviderSettings> DataProviders
    {
        get { yield break; }
    }

    public string DefaultConfiguration => "Oracle.Managed";
    public string DefaultDataProvider => "Oracle.Managed";

    private readonly IConnectionStringSettings[] _connectionStrings;

    public DatabaseSettings(IConnectionStringSettings[] connectionStrings)
    {
        _connectionStrings = connectionStrings;
    }

    public IEnumerable<IConnectionStringSettings> ConnectionStrings => _connectionStrings;
}

public static class DatabaseSetup
{
    // just call it on application startup
    public static void Init()
    {
        // create connectionStrings collection with both connection strings from appsettings.json

        DataConnection.DefaultSettings = new DatabaseSettings(connectionStrings);
    }
}