为什么以及何时使用.mdf文件是asp.net c＃ [英] Why and when to use .mdf file is asp.net c#

问题描述

为什么以及何时使用.mdf文件是asp.net c＃。.mdf文件的优点和缺点是什么？.mdf文件和orignal sqlserver数据库有什么区别？

Why and when to use .mdf file is asp.net c#.What is the advantages and disadvantages of .mdf file and What is difference between .mdf file and orignal sqlserver database?

推荐答案

MDF是所有SQL数据库文件的扩展名，无论是附加到某个远程SQL服务器还是本地（甚至是嵌入式）服务器都无关紧要......

当您将应用程序直接附加到某个本地MDF文件时，您使用的是嵌入式版本的SQL Server引擎（有一些限制）。这种用法适用于小型数据库，在这种情况下，您不希望用户安装整个SQL服务器包，但在安装过程中为您提供嵌入式版本...

MDF is the extension for all SQL database files, it does not matter if it attached to some remote SQL server or you have it locally (or even embedded)...
When you directly attach your application to some local MDF file you are using an embedded version of the SQL server engine (that have some limitations). This kind of usage is good for small databases, in which case you do not want the user to install the whole SQL server pack, but you provide him with an embedded version during installation...

这篇关于为什么以及何时使用.mdf文件是asp.net c＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！