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

问题描述

我将建立一个集的应用程序。其中一个应用程序是无人值守的应用程序（写在VB6），将它写入从各种渠道接收到本地数据库的数据。所有其他应用程序（将被写在VS 2008 / C＃3.0）将读取这些数据主要是报告的原因。

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甚至它的速成版，因为发行这是一个问题（如需要单独安装，等...）。我要寻找一个具有驱动两种VB6（所以大概OLEDB，或ODBC如果我要解决它）和ADO.NET本地数据库。这也将是不错，如果数据库有对运筹学和管理学的支持，像NHibernate的或至少是1对1的映射器，亚音速一样，但是这不是一个大忌。但我的主要要求是，数据库应该是大量固体，这样我就不用浪费时间与它摆弄，恢复丢失的数据，等等...

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精简版，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.

什么是那里最适合我的情况？

What's out there that best fits my situation?

推荐答案

的 SQLite的可能只适合该法案。请务必检查了所有可用的包装的为好。

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

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