问题描述
我目前正在设计.NET中的小应用程序,过去我一直使用MSACCESS作为独立数据库,可以使用该程序. 但是我想知道,在这个时代,是否没有其他解决方案,很容易集成到.NET应用程序中,对用户来说是透明的,并且可以使用大量数据进行更佳性能?
?推荐答案
您的选项是:
- sqlite
- firebird
- SQL Server CE- dep dep dep dep depricated ,最新版本, 4.0 SP1 于2012年8月31日发布
- vistadb - 商业
- erse - 很难与.net
SQL CE和Firebird在需要多线程写入时要快得多,SQLite是单线访问或多线程读取的King. Vistadb管理100%,因此您可以将其运送到嵌入式设备上.
这些DB通常会为您提供更好的可靠性和访问性能.我强烈建议不要在网络共享上使用这些DB中的任何一个.
其他推荐答案
sqlite!这正是它的目的.
http://sqlite.phxsoftware.com/
其他推荐答案
是.我会推荐 system.data.data.sqlite ,这是一个aDo.net包装器, sqlite ,用C.
编写的流行嵌入式数据库问题描述
I'm currently designing a small application in .Net and in the past I've been using MSAccess as standalone database that I can ship with the program. But I was wondering if in this day and age there wasn't alternative solutions, as easy to integrate in a .Net app., as transparent for the user and maybe better performance with large amount of data?
推荐答案
Your options are:
- Sqlite
- Firebird
- Sql Server CE - depricated, latest version, 4.0 SP1 was released 8/31/2012
- VistaDB - commercial
- ESE - Which is hard to integrate with .Net
SQL CE and Firebird are a lot faster when you need multithreaded writes, sqlite is king for single threaded access, or multithreaded reads. VistaDb is 100% managed so you can ship it on embedded devices.
These DBs in general will give you better reliability and performance to access. I would strongly recommend against using any of these dbs over a network share.
其他推荐答案
SQLite! This is exactly what it was made for.
http://sqlite.phxsoftware.com/
其他推荐答案
Yes. I would recommend System.Data.SQLite, which is a ADO.NET wrapper around SQLite, a popular embedded database written in C.