In one interview, interviewer asked this question. I have one table in sql server database which contains the Title and its id(int). Now I want to retrieve those values from database and based on the title, I have to create sites under one root website. How many values are there, that many sites needs to be create.
Title ID
-----------------------------------
A 1
B 2
C 3
These are the values. Now I want to creata these three sites at a time. How to achieve it and if I change title of the site then it should update in the database as well. Any suggestions please