Finbuckle.MultiTenant icon indicating copy to clipboard operation
Finbuckle.MultiTenant copied to clipboard

Adding support for read replicas with EF Core store

Open acasciani opened this issue 1 year ago • 1 comments

We currently have two connection strings with RDS Aurora for where our tenant data is stored. Connection string one is for our read/write database node and connection string two is for our read only database node. We plan to customize the EFCoreStore to take a second DB Context which is intended to be used only for read operations and update the methods that perform SELECTs to use this second context. Ideally, this would be contained within the Finbuckle EF Core code.

Would you consider adding support for a read replica DB Context within the EFCoreStore that ships with Finbuckle? We'd be happy to assist with this if it helps expedite this feature.

acasciani avatar Jul 25 '23 21:07 acasciani

Hi, sorry for the slow reply. I do not plan on adding this feature simply because I want to keep EFCoreStore as simple as possible to serve as an example. I do highly encourage you to customize as you see for your needs and if you get a good solution to update this issue with your approach to help others in the future.

Thanks!

AndrewTriesToCode avatar Aug 12 '23 19:08 AndrewTriesToCode