I have a catalog database and a profile database about threenine.data

[Ratankalwa]

Thank you so much. You are a STAR. Best Regards Ratan Kalwa

…

On Thu, 29 Jul 2021 at 17:04, Gary Woodfine ***@***.***> wrote: Sure no worries I will sort that out now — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACTKOUVRW5VVMRPAPGDZSKDT2F32PANCNFSM5BFVOVVA> .

-- Ratan Kalwa 0044 + (0)7774072288

[garywoodfine]

Unfortunately at this moment in time, we have not implemented functionality to enable your requirement at present.

We do have the Dependency Injection at this moment to add multiple Db Contexts, but we have not implemented functionality within the repository layer to enable switching between them as of yet.

On our own projects we now try not to use this approach at all, primarily because we have preferred to use Microservice approach this solve this, so we have Microservices with their own databases and contexts to facilitate.

s

[Ratankalwa]

Thank you very much for your reply. I have tried to sign up to your support and it gave me multiple errors and it charged me multiple times. Could you please refund all my monies Best Regards Ratan Kalwa

…

On Thu, 29 Jul 2021 at 11:00, Gary Woodfine ***@***.***> wrote: Unfortunately at this moment in time, we have not implemented functionality to enable your requirement at present. We do have the Dependency Injection at this moment to add multiple Db Contexts, but we have not implemented functionality within the repository layer to enable switching between them as of yet. On our own projects we now try not to use this approach at all, primarily because we have preferred to use Microservice approach this solve this, so we have Microservices with their own databases and contexts to facilitate. s — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACTKOUX5EJW6C6YQZPE6253T2ERCHANCNFSM5BFVOVVA> .

-- Ratan Kalwa 0044 + (0)7774072288

[garywoodfine]

Sure no worries I will sort that out now

[cjabbour]

I was able to inject 2 units of work into the same service using the IUnitOfWork<ExampleContextA> and IUnitOfWork<ExampleContextB> and they both worked fine.

[Ratankalwa]

Dear Chuck Thank you very much. Would you be able to send the sample code? and how easy is it to change the connectionstring on the fly. I look forward to hearing from you. Thank you Best Regards Ratan Kalwa

…

On Wed, 26 Jan 2022 at 17:27, Chuck Jabbour ***@***.***> wrote: I was able to inject 2 units of work into the same service using the IUnitOfWork<*ExampleContextA*> and IUnitOfWork<*ExampleContextB*> and they both worked fine. — Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACTKOUT3JEWKRBBKNDD2UULUYAVITANCNFSM5BFVOVVA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Ratan Kalwa 0044 + (0)7774072288

[cjabbour]

Hi Ratan

For now, I'm not changing any connectionstrings on the fly. During startup, I'm initializing my 2 DbContexts with something like this:
services.AddDbContext<CoreDbContext>(options => options.UseSqlServer(coreConnString)).AddUnitOfWork<CoreDbContext>();
services.AddDbContext<AuxDbContext>(options => options.UseSqlServer(auxConnString)).AddUnitOfWork<AuxDbContext>();

and then in a query handler in my data layer - separate from my biz layer - I'm injecting the UOW like this
private readonly IUnitOfWork<CoreDbContext> _coreUnitOfWork;
private readonly IUnitOfWork<AuxContext> _auxUnitOfWork;

I haven't noticed any issues with those UOWs yet - however, I'm still in kind of a proof-of-concept stage with this project.

I hope this helps. Would love to hear some feedback if you end up trying it.

@garywoodfine is there anything that seems wrong to you with this approach?

[Ratankalwa]

Thank you for your email. I will try over the weekend and get back to you Have a wonderful weekend Best Regards Ratan Kalwa

…

On Thu, Jan 27, 2022, 2:00 PM Chuck Jabbour ***@***.***> wrote: Hi Ratan For now, I'm not changing any connectionstrings on the fly. During startup, I'm initializing my 2 DbContexts with something like this: services.AddDbContext<CoreDbContext>(options => options.UseSqlServer(coreConnString)).AddUnitOfWork<CoreDbContext>(); services.AddDbContext<AuxDbContext>(options => options.UseSqlServer(auxConnString)).AddUnitOfWork<AuxDbContext>(); and then in a query handler in my data layer - separate from my biz layer - I'm injecting the UOW like this private readonly IUnitOfWork<CoreDbContext> _coreUnitOfWork; private readonly IUnitOfWork<AuxContext> _auxUnitOfWork; I haven't noticed any issues with those UOWs yet - however, I'm still in kind of a proof-of-concept stage with this project. I hope this helps. Would love to hear some feedback if you end up trying it. — Reply to this email directly, view it on GitHub <#38 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACTKOUQDPTHNIK5WVDVFKNLUYFFXPANCNFSM5BFVOVVA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>