用于Windows应用程序（WPF）的独立数据库 [英] Stand alone database for Windows Application (WPF)
问题描述
我创建了一个简单的（商业）WPF应用程序，并希望将其与可以安装在客户的本地计算机上的数据库一起分发。
I have created a simple (commercial) WPF application and want to distribute it with a database that can be installed on the local machine of a customer.
最好使用什么数据库？
What database is the best to use ?
我正在考虑SQL Server Epress Edition 2008.我知道10 GB的限制，但是这是足够的，是没有问题。
I was considering SQL Server Epress Edition 2008. I know the limitations of 10 GB, but that's more than enough and is no issue.
我没有为Express选择100％的唯一原因是我不知道如何让我的客户备份数据库。
The only thing I'm not choosing 100% for Express is that I don't know how to let my customer backup the database.
我的同事一直告诉我使用MS Access，但我不知道这是一个很好的选择，因为我想使用存储过程和视图。
My collegues keep telling me to use MS Access, but I don't know if that's a good option because I want to use stored procedures and views.
请让我知道你在使用什么，或者你可以建议我...
Please let me know what you are using or you can advise me...
推荐答案
的数据？
对于小数据库SQLite可能是一个不错的选择 - 它轻巧，快速，开源，不需要额外的软件。它甚至支持加密，如果你需要。
For small databases SQLite may be an good choice - it is light, fast, opensource and needs no additionally software. It even supports encryption, if you need that.
备份是尽可能容易，因为SQLite数据库由一个单一的文件。
Backup is as easy as it could be, as the SQLite-database consists of a single file.
Ruutert：数据库大小高达500 mb：
Ruutert: database-size up to 500 mb:
这个大小对SQLite没有问题。我们使用高达几GB的数据库。只有大数据库的问题，真空（像reorg / compress未使用的空间）需要更长的数据库（但是对于其他数据库类型相同）
That size should be no problem for SQLite. We use databases up to several GB. Only problem on big databases is, that vacuum (like reorg / compress unused space) takes as longer as bigger the database is (but that is the same for other database-types)
Ruutert：SQLite的缺点？
Ruutert: disadvantages of SQLite?
可能会遇到高并发（大量并行数据库访问）的问题。如果你的工作负载是这样，你考虑将你的数据库管理器移动到另一个服务器 - 从应用服务器分离，我会考虑一个面向客户端服务器的数据库管理器。
You could get problems with High Concurrency (lots of parallel database-access). Also I would consider an client-server oriented database-manager if your workload is so heava that you think about moving your database-manager to another server - splitted from application-server.
但是当你考虑使用SQL Server Express或MS-Access，它们的功能也有限，这不应该是问题。另一方面，你有一个优点，你只需要一个小dll（或将它静态编译为你自己的一个），而不是安装一个完整的数据库管理器。
But as you considered using SQL Server Express or MS-Access, which have limited functionality too, that should not be the problem. On the other side you have the advantage that you need just an small dll (or compile it static into one of you own) instead of installing an complete database-manager.
这篇关于用于Windows应用程序（WPF）的独立数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
