Hi,
How to use multiple database on multiple db context ? DbContextA - DatabaseA DbContextB - DatabaseB
I'm using ASP.Net MVC 5 + Angularjs 1.x
Please help
14 Answer(s)
-
0
Hi,
You can check this sample <a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate-samples/tree/master/MultipleDbContextDemo">https://github.com/aspnetboilerplate/as ... ontextDemo</a>.
-
0
Hi,
It require MSDTC. Azure doesn't support MSDTC. can you provide other solution to use multiple database and multiple dbcontet using this: <a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate/issues/1706">https://github.com/aspnetboilerplate/as ... ssues/1706</a>
Thanks
-
0
Any help ??
-
0
Hi,
Can you configure IEfTransactionStrategy as explained here <a class="postlink" href="https://aspnetboilerplate.com/Pages/Documents/EntityFramework-Integration#transaction-management">https://aspnetboilerplate.com/Pages/Doc ... management</a>.
-
0
Hi,
Is that for multiple dbcontext with single database or multiple dbcontext with multiple database ?
-
0
Hi @Verrrrrrrrrrrrrdi,
It is for single DbContext as far as I know. Did you have a chance to try ?
-
0
Are you using Azure SQL? We are using multiple DB Contexts in Azure SQL. I think they recently released support for this. You may be hitting some other type of DB that isn't supported but just in case:
<a class="postlink" href="https://azure.microsoft.com/en-us/blog/elastic-database-transactions-with-azure-sql-database/">https://azure.microsoft.com/en-us/blog/ ... -database/</a>
In our app, we have separate contexts for the Host database and tenant databases. Transactions for sure work between the two. Anyway, this may not help but thought I would post it.
-
0
hi @ismcagdas,
Yes, i have try it. I has implemented new EF Transaction Strategy using this link: <a class="postlink" href="https://github.com/aspnetboilerplate/as">https://github.com/aspnetboilerplate/as</a> ... ssues/1706
But as you know my case is different. I have multiple databases and multiple db context. not a single database. can you provide other solution to solve this case ?
can you give me a sample solution?
please help me..
-
0
Hi @Verrrrrrrrrrrrrdi,
Would you like to use both dbContexes in the same transaction ? As far as I know, it is not possible because they are pointing to different databases.
-
0
Hi @ismcagdas,
Yes i want to use both dbContext in same transaction (UOW). So you mean the way to solve this case is using MSDTC ?
Do you have sample implementation with multiple database using ASP.NET Core + Angular template? this sample <a class="postlink" href="https://github.com/aspnetboilerplate/as">https://github.com/aspnetboilerplate/as</a> ... ontextDemo is for ASP.NET MVC 5 + Angular js 1.x
-
0
Hi @Verrrrrrrrrrrrrdi,
Yes i want to use both dbContext in same transaction (UOW). So you mean the way to solve this case is using MSDTC ?
As far as I know, Azure doesn't support it but it can be achieved in a dedicated server using MSDTC (I'm not %100 sure). We don't have a sample for EntityFramework Core. Did you have a problem ? We can try to help.
-
0
Hi @ismcagdas,
OK i wil take your solution using on premise server and enable MSDTC. I have enable MSDTC in my dedicated server but when i use both dbContext in same transaction it show error:
The specified transaction is not associated with the current connection. Only transactions associated with the current connection may be used.
If i add the constructor :
public DbContextB() : base("ConnStringB") { } public DbContextB(string nameOrConnectionString) : base(nameOrConnectionString) { } public DbContextB(DbConnection existingConnection) : base(existingConnection, false) { } public DbContextB(DbConnection existingConnection, bool contextOwnsConnection) : base(existingConnection, contextOwnsConnection) { }it show error
Invalid Object Name dbo.TableB
because it always use "Default" connection string and TableB is belong to DatabaseB which use DbContextB. can you help me?
-
0
Hi @ismcagdas,
It solved. Thanks for your help
-
0
@Verrrrrrrrrrrrrdi, Great :)
