Great explanation on creating Database resource in azure and retrieving database connection strings. Think I would prefer working on database locally and then pushing the database to Azure using SSMS task Deploy Database to Microsoft Azure SQL Database 😀
You didn't have to install Azure CLI locally? And what if you didn't want to have your password and user-id visible in your connection string? Is it better to use a user managed identity or a system managed identity? I had to use a UMI and run a script in my database to give it permissions? How is it that you didn't have to do that? Is it because you're using user-id and password?
ZetBits can you do a video on using EF core for a multi-tenant database per tenant using azure SQL databases? Not much content regarding this. I'm trying to learn the logic of how things would work. I understand you'd have a master database, where you store all of your tenants info like connection strings so on. Then maybe using ARM templates you can create database for each tenant when they sign up? And then using EF core you would run initial migrations for each tenants database. But its so complex and I can't wrap my head around it. Im guessing you would need multiple Dbcontexts, as well what about changing the connection strings dynamically as each query would be sent towards the tenants database. Please would love to learn this!
Great explanation on creating Database resource in azure and retrieving database connection strings. Think I would prefer working on database locally and then pushing the database to Azure using SSMS task Deploy Database to Microsoft Azure SQL Database 😀
That would also be the best solution I think if you don't want to make the changes directly in production like this video does 😄
Support by hitting 2 buttons! Like and Subscribe 👏
how will other team member access this same database for collaboration in dotnet project
You didn't have to install Azure CLI locally? And what if you didn't want to have your password and user-id visible in your connection string? Is it better to use a user managed identity or a system managed identity? I had to use a UMI and run a script in my database to give it permissions? How is it that you didn't have to do that? Is it because you're using user-id and password?
Best tutorial. what should i do if i already have a database?
Thanks! And i actually dont know. Could be an idea for a new video! 💪
ZetBits can you do a video on using EF core for a multi-tenant database per tenant using azure SQL databases? Not much content regarding this. I'm trying to learn the logic of how things would work. I understand you'd have a master database, where you store all of your tenants info like connection strings so on. Then maybe using ARM templates you can create database for each tenant when they sign up? And then using EF core you would run initial migrations for each tenants database. But its so complex and I can't wrap my head around it. Im guessing you would need multiple Dbcontexts, as well what about changing the connection strings dynamically as each query would be sent towards the tenants database. Please would love to learn this!