可以密度纤维板作为嵌入式数据库？ [英] Can .mdf use as embedded database?

问题描述

我是新的C＃和SQL Server数据库，所以这可能是一个愚蠢的问题，但我很困惑。

I am new to C# and SQL Server databases, so this may be a stupid question but I am confused.

我想安装一个客户端上的嵌入式数据库机器时，他会自动安装我的应用程序。我知道SQL Server精简版是有，但也有在SQL Server CE这么多的限制。

I want to setup an embedded database on a client machine automatically when he installs my application. I know SQL Server Compact Edition is there but there are so many restrictions in SQL Server CE.

我可以使用密度纤维板文件作为嵌入式数据库？如果是的话那我怎么才能安装它的客户端计算机上自动？或是否有任何其他选项，以解决我的问题？

Can I use .mdf files as an embedded database? If yes then how can I setup it on client machine automatically? or is there any other option to solve my problem?

推荐答案

我会建议使用SQLite。它是容易部署。此外，SQL Server精简似乎停止。

I would recommended to use SQLite. It is simpler to deploy. Also, SQL Server Compact appears to be discontinued.

的是SQL Server精简从Visual Studio 2013停产？

您可以使用SQLite其中的没有按' ŧ要求在客户端计算机上的任何安装。

You can use SQLite which doesn't require any installation on the client machine.

SQLite的依赖于Visual C ++运行，但你并不需要在客户机上安装它。该 system.data.sqlite 下载页面包含几个静态套餐已包含的运行时间。

SQLite depends on the Visual C++ runtime, but you don't need to install it on the client machine. The system.data.sqlite download page contains several "static" packages that already contain the runtime.

所有的静态包包含在本机或混合模式组装
二进制代码静态链接到Visual
C ++运行时的相应版本。通常情况下，这些包的情况下使用，其中
客户机可能没有安装在Visual C ++
运行时的必要版本，它不能被安装由于有限
特权。

All the "static" packages contain either native or mixed-mode assembly binaries linked statically to the appropriate version of the Visual C++ runtime. Typically, these packages are used in cases where customer machines may not have the necessary version of the Visual C++ runtime installed and it cannot be installed due to limited privileges.

例如，我的机器上我运行Windows 8.1 x64的，所以我在预编译静态链接的二进制文件去了64位Windows（.NET Framework 4.0中）并下载sqlite-netFx40-static-binary-x64-2010-1.0.90.0.zip。

For example, on my machine I am running Windows 8.1 x64 so I went under Precompiled Statically-Linked Binaries for 64-bit Windows (.NET Framework 4.0) and downloaded sqlite-netFx40-static-binary-x64-2010-1.0.90.0.zip.

这个二进制软件包包含了所有的二进制文件$ b $ x64版本b中的System.Data.SQLite 1.0.90.0（3.8.2）封装。针对x64在Visual C ++ 2010
SP1运行时是静态链接。在.NET Framework 4.0是必需的

This binary package contains all the binaries for the x64 version of the System.Data.SQLite 1.0.90.0 (3.8.2) package. The Visual C++ 2010 SP1 runtime for x64 is statically linked. The .NET Framework 4.0 is required.

我再解压缩包就跑test.exe的，以确保一切正常。零安装所需。

I then unzipped the package and ran test.exe to make sure everything works. Zero installation required.

这篇关于可以密度纤维板作为嵌入式数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！