Confused about creating mdf file

Asked Jun 15 '14 at 11:50

Active Jun 15 '14 at 12:28

Viewed 44 times

I have a window project. I am required to add Service based database. I have also added one.

After that I created a new table with few records. Visual studio prompted me where to store it. Then I saved it on the desktop.

But it's not a .mdf file, rather it's a SQL Server query file (.sql).

I was expecting a .mdf file.

What am I doing wrong? I am using SQL Server 2008 R2 Express.

edited Jun 15 '14 at 12:28

marc_s

asked Jun 15 '14 at 11:50

user3733078

1

What is inside the *.sql file? – RubberDuck Jun 15 '14 at 12:02
Can't reproduce - create new Winforms app, add new "Service-based database" -> causes a `database1.mdf` to be added to my project. – marc_s Jun 15 '14 at 14:32

0 Answers0