Create new database from another database whenever new entry insert in mssql??

Question

I have a one master Database in this database all other database name and password and other fields are present in one table so i create the connection string and other things from this table.
Now we want when we insert a new record in master table then automatically new database create from the backup file.

Answer 1

I hope I do understand your question.

Because it looks like a lot of overhead to create a new database when adding just a record.

Please look in the links below:
How to create a database from C# code.
https://support.microsoft.com/en-us/help/307283/how-to-create-a-sql-server-database-programmatically-by-using-ado-net

https://www.codeproject.com/Articles/10213/Create-an-SQL-Server-Database-Using-Csharp

https://www.c-sharpcorner.com/article/create-a-sql-server-database-dynamically-in-C-Sharp/