Hi, I am testing a trial version of LinqConnect.
I have a bunch of databases which all have the same table structures.
In EF Core, I can create one DbContext and easily switch between the databases using ChangeDatabase:
MyDbContext.Database.GetDbConnection().ChangeDatabase(<MyDatabase>);
And I can do this using a single connection.
With LinqConnect I have not found a method similar to ChangeDatabase.
When testing with LinqConnect I can create one DataContext, and switch between databases using:
MyDataContext.Connection.Close();
MyDataContext.Connection.ConnectionString = <new database connectionstring>;
MyDataContext.Connection.Open()
This works but it creates a new connection each time a switch database.
Is there a way to make the switch to another database at runtime and use a single connection like I can with EF Core?
Thanks,
Thom