IT:AD:EF:HowTo:Create a database from the Model
Process
HINT: Note that there is a Previous button…which is a means of getting some fine grain control over where it will build the Db. If you click it, you can edit the Connection string:
HINT: For portability between dev stations, always a good idea to choose ‘.’ as the local server name – let your final MSI package deal with rollout names at a later date.
But moving along, one can click Finish…and it goes off and creates your database for you:
Go take a peak in SQL Server Manager, and there it is:
Watch out…yes, the Db was created…but if you look a little deeper, you’ll notice that the Db is empty of all dbo objects:
There’s still a step to do. Notice that the full sql script was dumped into Visual Studio. You have to run it. The good news, it’s easy. Just right click it.
Notice that it also shows you the script in Visual Studio, which you can right click to run:
Which brings up the usual screen…
And a little moment later, you’re done.
