Creation Of Database And MDF Files In SQL
In This Article , We Will Give You A Brief Idea About Creation Of Database And MDF Files Using Visual Studio
Step 1: Open the Microsoft Visual Studio Express Edition .
Click on file and select 'New Project' from that window.
Step 2: Now we are creating a web application , choose 'web' and ASP.NET Web Application from the corresponding window.Type the name and choose the location and finally click on 'OK'.
Step 3: Select 'Web API' as template and choose 'No Authentication' then click 'OK' to create.
Step 4: From the solution explorer , right click on the App_Data and choose 'Add' from that and again choose the 'New item' from that window.
Step 5: Now we are going to create new database, For that select 'Data' from the left side and SQL Server Database from the window and click on 'Add' button.
Step 6: Now the database is created as student.mdf and adding tables in to it by right clicking on the 'Table'.
Step 7: We can then add the feilds in to the table and kept the Is Identity as true.
Step 8: After adding all the feilds click on 'update'and then click on 'update database'.
Step 9: LikeWise we can add any no. of tables.
Step 10: Refresh the tables , we can see the tables that we created.