C#•9mo ago

single-tenant

I need some help, please. I know it is a long shot. I need every hotel to be its own db, but not to create a new db. At the moment when I create a new hotel, it creates the same database. Is there a way to do it properly? I would love some guidance or ideas. I appreciate any help you can provide.

Single-Tenant Architecture
Data Isolation: Each hotel has its own database, ensuring that its data is completely separated from others.
Security: Reduced risk of data leakage between tenants.
Customization: Customize the database schema or settings for each hotel without affecting others.

Jimmacle•4/9/25, 4:03 PM

I need every hotel to be its own db, but not to create a new db.I need every hotel to be its own db, but not to create a new db.
this sentence contradicts itself, what do you want the end result to be?

Jimmacle•4/9/25, 4:03 PM

where did you get stuck when we left off the last time you asked about this?

Jimmacle•4/9/25, 4:05 PM

this is also seems to be the exact opposite of single-tenant, this is multi-tenant

Georgi YOP•4/9/25, 4:22 PM

@Jimmacle Hi sorry, I know it is confusing, yes, this is multi-tenant I have started it that way, but I realize it should not be that way, so now I am trying to re-factor it to single-tenant

Jimmacle•4/9/25, 4:33 PM

but these 2 things don't make sense to say at the same time

Jimmacle•4/9/25, 4:34 PM

every bullet point you put under "single-tenant architecture" is a quality of a multi-tenant architecture

Georgi YOP•4/9/25, 4:40 PM

sorry for the confusion, I meant it was a multi-tenant, and I want to re-factor it to single-tenant architecture

Jimmacle•4/9/25, 4:41 PM

so what are you currently having a problem changing?

Georgi YOP•4/9/25, 4:56 PM

Yes, currently, trying to understand how to change it basically,

Georgi YOP•4/9/25, 4:57 PM

the way I have started is totally wrong

Georgi YOP•4/9/25, 4:59 PM

I am out of ideas already

Jimmacle•4/9/25, 5:01 PM

without detail about what currently happens and what the desired behavior is i can't offer much advice

Jimmacle•4/9/25, 5:01 PM

if you're creating a db per hotel and don't want to do that, the solution is essentially "don't do that"

Georgi YOP•4/9/25, 5:06 PM

Right, yes, it is a bit confusing to me, because it is creating new db, however it is exaclty the same as previous one, and when I edit the new db e.g new hotel, all hotels are changing event if it is new db which is confusing, not sure if I can post the hotel controller and hotel service, just advice how I can re-factor it ?

Georgi YOP•4/9/25, 5:33 PM

maybe the claryfying quesiton would do I still need to create the MDF file

ACiDCA7•4/9/25, 5:45 PM

kinda sounds like you are having troubles with auto migration of EF?

ACiDCA7•4/9/25, 5:45 PM

but this is just a long shot

ACiDCA7•4/9/25, 5:46 PM

how do we know how to help you if you dont give us anything to work with

Georgi YOP•4/9/25, 6:02 PM

sorry about that, not sure what to share, as it is quite a lot, is ok to share the github repo, or just, the Hotel Service and Hotel controller where the methods are ?

AACiDCA7 how do we know how to help you if you dont give us anything to work with

Georgi YOP•4/9/25, 6:02 PM

sorry about that, not sure what to share, as it is quite a lot, is ok to share the github repo, or just, the Hotel Service and Hotel controller where the methods are ?

Georgi YOP•4/9/25, 6:05 PM

HotelDashboardController.txt5.48KB

HotelService.txt7.31KB

Georgi YOP•4/9/25, 6:06 PM

Here are the Hotel Services, and HotelController

Georgi YOP•4/9/25, 6:07 PM

Configuration.cs.txt984B

Georgi YOP•4/9/25, 6:07 PM

and configuration, file form Migrations folder

Georgi YOP•4/9/25, 6:07 PM

public Configuration()
{
AutomaticMigrationsEnabled = true;
AutomaticMigrationDataLossAllowed = true;
}

Georgi YOP•4/9/25, 6:11 PM

If you could point me to how to refactor it, I would be very thankful, trying to re-factor it from weeks, but still no luck

ACiDCA7•4/9/25, 7:31 PM

yes but what behavior exactly do you want to change?

Georgi YOP•4/9/25, 7:39 PM

The best behavior for me is when a new hotel is created, to support single-tenancy so use one db for all hotels added, where each hotel is isolated, and when making changes, the changes are only on this hotel

Jimmacle•4/9/25, 7:41 PM

so just don't make additional dbs

Jimmacle•4/9/25, 7:41 PM

that's an intentional behavior you've put in your code

Jimmacle•4/9/25, 7:42 PM

the rest is just simple relational database management

Georgi YOP•4/9/25, 7:43 PM

yep, I did try it, however not sure how to do the relational dabase management,

Jimmacle•4/9/25, 8:08 PM

what specifically are you struggling with? we can only help with specific questions, vague problem statements don't get us anywhere

Georgi YOP•4/9/25, 8:26 PM

Yes, I realize that as well, just trying to figure it out

single-tenant

Similar Threads

Similar Threads

Similar Threads