SQLite.NET和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.