哪个本地数据库适合我的情况？ [英] Which local database fits my situation?

问题描述

我将构建一组应用程序。这些应用程序之一是无人值守的应用程序（用VB6编写），它将从各种源接收的数据写入本地数据库。

I will be building a set of applications. One of these apps is unattended application (written in VB6) which will write data it receives from various sources to a local database. All the other applications (will be written in VS 2008/c# 3.0) will read this data for mostly reporting reasons.

我不想使用SQL Server / MySql / Sybase版本，因为这些应用程序（将用VS 2008 / c＃3.0编写）或甚至其表达版本，因为分发它是一个问题（例如，需要单独安装等）。我正在寻找一个本地数据库具有驱动程序VB6（所以可能是OLEDB，或ODBC如果我不得不解决它）和ADO.NET。这也将是很好，如果数据库支持ORM，如NHibernate或至少1对1映射器，像Subsonic，但这不是一个交易破坏者。但我的主要要求是，数据库应该是大规模的固体，这样我就不必浪费时间来搞定它，恢复丢失的数据等等。

I don't want SQL Server/MySql/Sybase or even its express editions, because distributing it is a problem (e.g. requires separate install, etc...). I am looking for a local database that has drivers for both VB6 (so probably OLEDB, or ODBC if I have to settle for it) and ADO.NET. It would also be nice, if the database had support for ORMs, like NHibernate or at least 1-to-1 mappers, like Subsonic, but that's not a deal breaker. But my main requirement is that the database should be massively solid, so that I don't have to waste time fiddling with it, recovering lost data, etc...

我有MS Access的经验，从后面的一天，没有太多的好回忆（也没有坏）。我听说过SQLite，SQL Server Compact Edition，VistaDB等等，但是他们没有经验，我不知道有谁实际使用它。

I have experience with MS Access from back in the day and don't have too many good recollections (nor was it bad either). I've heard of SQLite, SQL Server Compact Edition, VistaDB, etc... but have zero experience with them and I don't know anyone who has actually used it.

推荐答案

SQLite 可能只是适合账单。请务必查看所有可用的封装。

SQLite might just fit the bill. Make sure you check out all the available wrappers as well.

这篇关于哪个本地数据库适合我的情况？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！