Why and when to use .mdf file in asp.net c# RRS feed

  • Question

  • User414662344 posted

    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?

    Wednesday, October 22, 2014 3:38 AM

All replies

  • User-1716253493 posted

    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

    Wednesday, October 22, 2014 4:04 AM
  • User-2110585397 posted


    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

    Friday, March 6, 2015 3:41 AM