SQLLite或MSAccess，哪个更好.net [英] SQLLite or MSAccess, Which is better with .net
问题描述
目前我正在使用.net和C＃开发基于Window的应用程序。
此应用程序适用于单个用户，它有5-6个表，每天将添加大约10-20行在两个或三个表中，其余都是主表。
以前我曾经在SQL Server上工作但是对于这个项目我认为SQL Server不会对这个项目有好处，因为它太重而且减慢了用户的速度系统。
所以基本上，我想问哪个数据库对我的项目更好
（我正在考虑SQLlite和MSAccess但不确定哪一个应该我选择。）
Currently I am working on a Window based application using .net and C#.
This application is for a single user, It has 5-6 Tables and approx 10-20 rows will be added daily in Two or Three table and rest are master Tables.
Previously i have worked on SQL Server but for this project I think SQL Server will not be good for this project as it is too heavy and slows down user's system.
So basically, I want to ask which database will be better for my project
(I am considering SQLlite and MSAccess but not sure which one should I choose.)
推荐答案
对于.NET， SQL Server紧凑型 [ ^ ]或 Microsoft Access [ ^ ]是更好的选择，原因很简单，这些数据库和.NET是Microsoft的产品，因此使用其他数据库有很多优点。
但 SQLite [ ^ ]是不错的选择，跨平台&许多人都在移动开发上使用。
For .NET, SQL Server Compact[^] or Microsoft Access[^] is better option, reason is simple both these databases & .NET are Microsoft products so there're many advantages using over other databases.
But SQLite[^] is nice option, cross platform & many people do use on Mobile development.
这两者之间没有真正的区别......实际上我看不出为什么不将MSSQL嵌入到应用程序中。我看不出它会如何减慢您的应用...
您可以在这里阅读：http://social.technet.microsoft.com/wiki/contents/articles/940.how-to-embed- sql-server-express-in-an-application.aspx [ ^ ]
There is no real difference between the two...In fact I can't see why not use MSSQL as embedded into the application. I can't see how it will slow down your app...
You may read here: http://social.technet.microsoft.com/wiki/contents/articles/940.how-to-embed-sql-server-express-in-an-application.aspx[^]
我想Mr.Kornfeld Eliyahu Peter 是正确的。我现在使用 MSSQL 3年，发现它比任何现有数据库更好。仍然是SQLLite V / S MSAccess的链接。
http://db-engines.com/en/system/Microsoft+Access%3BSQLite [ ^ ]
I think "Mr.Kornfeld Eliyahu Peter" is right. I am using MSSQL for 3 years now and found it better than any existing database. Still a link for "SQLLite V/S MSAccess".
http://db-engines.com/en/system/Microsoft+Access%3BSQLite[^]
这篇关于SQLLite或MSAccess，哪个更好.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
