Entity Framework–Model First, Part 3 (Execute script to create database)

In previous step(Generate database schema), we successfully generated xxx.edmx.sql script file

 

Look at table definition, we can see what we did changes

1. The Max Length of Industry = 50

2. The Type of OrderDate & ShipToAddress, datetime & geography

The Primary Key constraints

The Foreign Key constraints

 

Now if everything is ok, we can then right-click to Execute the script

Make sure again we are connect to right destination, click Connect button for next step

Once done, we are able to see the successfully completed message

The final step, we can open Server Explorer to check the database and tables are all been created