SQLite.NET和SQL Server Compact的优点和缺点 [英] Advantages and Disadvantages of SQLite.NET and SQL Server Compact

问题描述

我已经使用SQLite.NET多次。它总是工作正常，但我有一个朋友，真的很讨厌我，我应该使用SQL Server Compact，所以我完全呆在微软环境。

I have used SQLite.NET many times. It always worked fine but I have a friend that is really pestering me that I should use instead SQL Server Compact so I stayed fully in Microsoft environment.

现在，我从来没有工作过与Compact，他告诉我它对他很好，但看到.MDF扩展给我的爬行。没有开玩笑。我想要的是我的应用程序依赖于一个Access数据库。

Now, I never worked with Compact, and he tells me it works fine for him, but seeing that .MDF extension gives me the creeps. No kidding. Last thing I want is my application relying on an Access database.

因为我从来没有真正使用它，我在问这里有人知道它支持它，如果有人能告诉我他们之间的主要区别，主要是速度，文件大小，可靠性和功能。我知道这是很多问，但我会感激，如果有人可以帮助我。

Since I have never really worked with it, I am asking if someone here knows it to vouche for it, and if someone can tell me the main differences between them, mostly speed, file size, reliability, and features. I know it is a lot to ask but I'd appreciate if someone could help me.

推荐答案

服务器压缩只能有一个进程一次访问MDF。

One thing is that the SQL Server Compact can only have one process accessing the MDF at a time.

这篇关于SQLite.NET和SQL Server Compact的优点和缺点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！