独立应用程序Winforms使用哪个数据库 [英] which Database to use for standalone application Winforms

问题描述

我需要使用Visual Studio在WinForms中开发一个简单的会计应用程序，例如客户，供应商和会计资料(借方/贷方)等.

I need to develop a simple accounting application, like customers, suppliers and accounting stuff (debit/credit) etc. in WinForms using Visual Studio.

我从未使用数据库开发过独立的应用程序，我一直在开发服务器端应用程序(现有的SQL Server等)...

I have never developped a standalone appliation with Database, I've always developped a server side application (existing SQL server etc)...

我喜欢用DB开发一个独立的应用程序.我的意思是:创建一个安装项目(setup.exe/setup.msi)并发送给客户，他/她应该在他的Windows pc上安装

I like to develop a standalone application with DB. I mean: creating a setup project (setup.exe/setup.msi) and sent to the customer and he/she should install on his windows pc

具有以下技术: VS 2012专业版 带有LINQ的实体框架 Windows窗体.

with following technologies: VS 2012 Pro Entity Framework with LINQ Windows Forms.

我有一个问题: 我需要使用哪个数据库?这些客户没有SQL Server或其他任何服务器.只是一个简单的Windows 7/8系统.所以我在为选择哪个数据库而苦苦挣扎.我不能为每个客户在他的PC上安装一个sql服务器.因此需要自动化.

The question I have: Which Database do I need to use? these customers don't have SQL server or whatever. Just a simple Windows 7/8 system. So I'm struggling with which Database to choose. I can't install for every customer a sql server on his pc. so need away with automation.

我将定期向他们发送更新，例如setup.msi/setup.exe文件，以更新应用程序.

I will sent them regularly update like setup.msi/setup.exe file to update the application.

由于我将使用LINQ/实体框架，所以我不担心要使用哪个数据库.

Since I will use LINQ/ Entity Framework, I'm not worried which which DB to use.

有人可以建议我使用哪个数据库，并告诉我需要涵盖的棘手问题吗?

Can someone advice me which DB to use and tell me the tricky points which I need to cover?

实际上，Winforms应用程序应在具有X数据库(MDB，MDF，mysql或其他任何版本)的独立Windows PC上运行.

so in fact the Winforms application should run on a standalone Windows PC with X database (MDB, MDF, mysql or whatever).

请建议如何桥接数据库部分.

Please advice how to bridge the Database part.

谢谢

推荐答案

考虑Microsoft SQL Compact Edition ；这是在您的应用程序中运行的嵌入式数据库.它不包括触发器和过程扩展之类的某些功能，但是它比SQLite之类的DBMS使用起来简单得多，并且不需要用户进行管理.

Consider Microsoft SQL Compact Edition; this is an embedded database that runs in your application. It does not include some features like triggers and procedural extensions, but it is much simpler to use than DBMSes like SQLite, and requires no administration from users.

此外，Visual Studio 2010附带了用于构建和部署CE数据库的工具.您不需要安装任何东西.

Also, Visual Studio 2010 comes with tools for building and deploying CE databases; you don't need to install anything.

这篇关于独立应用程序Winforms使用哪个数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！