本地基于文件的SQL Server的 [英] Local file-based SQL Server
问题描述
我写它使用SQL Server作为其数据库为客户一个相当大的C＃WinForms应用程序。这最初是设计和内部其内部使用而开发。他们已经决定，他们想的这样的缩减版本，从授权给他们的客户，为藏汉内部使用的完整版。
I've written a fairly large C# Winforms application for a client which uses SQL Server for its database. This was initially designed and developed for their internal use in-house. They've decided that they'd like to licence out a cutdown version of this to their clients, aswell as using the full version internally.
虽然一些数据的的缩减版本，将存储将通过调用Web服务发送到我们的服务器，对于大部分数据被存储在本地的要求。
Whilst some of data that the cutdown version will store will be sent to our servers by calling a webservice, there is a requirement for most of the data to be stored locally.
我的大部分数据库经历了一直使用的是安装SQL Server的。然而，理想地在这种情况下，应该在一个本地的基于文件的数据库中存储的数据（没有它们具有安装和配置一个数据库服务器）。他们的客户是不太可能是技术上的头脑，他们将只是想将安装该软件的SETUP.EXE，这只是工作。
Most of my database experience has been using an install of SQL Server. However, ideally in this case, it should be storing data in a local file-based database (without them having to install and configure a database server). Their clients aren't likely to be technically minded, and they will just want an setup.exe that will install the software, and it just work.
我的大多数的。 .NET代码使用LINQ到SQL与数据库进行通信。
Most of my .NET code uses Linq-to-Sql to communicate with the database.
什么是在这种情况下，本地数据库，这应该允许我还是用我的最好的选择？现有的Linq代码
What are my best options for a local database in this case, which should allow me to still use the existing Linq code?
推荐答案
这是我的观点，看法-，你必须至少有两个选项：
From my point-of-view, you do have at least two options here:
- 使用的微软SQL Server精简版（CE）。
- 使用的 VistaDB的。
- Use Microsoft SQL Server Compact Edition (CE).
- Use VistaDB.
两者都是，你不必在目标系统上安装任何东西，而是简单地部署一个数据库（或更多）的DLL与应用程序。
Both are databases for which you do not have to install anything on the target system but simply deploy one (or more) DLLs with your application.
数据库是基于文件的。
我有几个现实世界的应用程序中运行VistaDB的非常好。
I have several real-world applications running VistaDB very well.
这是我的优点和缺点：
临SQL CE：
- 从微软自带
- 无成本
- T-SQL语法
- 似乎支持LINQ to SQL的
- Comes from Microsoft
- No costs
- T-SQL syntax
- Seems to support Linq to SQL
体质SQL CE：
- 无意见
- 几个DLL文件部署
临VistaDB的：
- SQL服务器兼容的语法
- 视图，存储过程等
- 100％受控，没有非托管代码
- 一个单个DLL部署
- 可以由多个用户使用（锁定）
- 似乎支持LINQ to SQL的（从不用它自己，虽然）
- SQL Server compatible syntax
- Views, Stored Procedures, etc.
- 100% Managed, no unmanaged code
- One single DLL to deploy
- Can be used by several users (locking)
- Seems to support Linq to SQL (never used it myself, though)
体质VistaDB的：
Con VistaDB:
- 的成本比如金钱
- 性能减微软访问 从网络驱动器运行时，
- 有点慢
- Costs money
- Less performance than e.g. Microsoft Access
- Somewhat slow when running from a Network drive
这篇关于本地基于文件的SQL Server的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
