Each database created in MSSQL Server (Whatever version, Express, Enterprise etc.) consists of two files. On that holds the definition of the tables and the data and the other that holds the activity of the users used the database. The mdf file is associated
with the data and the definition of tables.
Hence there isn't any disadvantage or advantage. mdf files are core part of a database in the environment of MSSQL server.
Member
2 Points
11 Posts
Why and when to use .mdf file in asp.net c#
Oct 22, 2014 03:38 AM|waqasAli786|LINK
Why and when to use .mdf file in asp.net c#.
What is the advantages and disadvantages of .mdf file and What is difference between .mdf file and orignal sqlserver database?
All-Star
52683 Points
15720 Posts
Re: Why and when to use .mdf file in asp.net c#
Oct 22, 2014 04:04 AM|oned_gk|LINK
AFAIK, in Visual Studio with Sql Express feature allow you to use .mdf (sql database) localy.
With or without having SQL Server installed, you still can work with sql database in Visual Studio.
But, sql express don't have many features like sql server, such as you can't access from remote pc.
It's local database with limited features
Suwandi - Non Graduate Programmer
Participant
1882 Points
290 Posts
Re: Why and when to use .mdf file in asp.net c#
Mar 06, 2015 03:41 AM|Sherwin Zhao|LINK
Hi,
Thanks for your post.
Each database created in MSSQL Server (Whatever version, Express, Enterprise etc.) consists of two files. On that holds the definition of the tables and the data and the other that holds the activity of the users used the database. The mdf file is associated with the data and the definition of tables.
Hence there isn't any disadvantage or advantage. mdf files are core part of a database in the environment of MSSQL server.
Hope this can be helpful to you.
Sherwin Zhao
Best Regards