7

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.

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.

starblue
  • 55,348
  • 14
  • 97
  • 151
Leahn Novash
  • 2,861
  • 2
  • 20
  • 18

3 Answers3

2

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

Joel Lucsy
  • 8,520
  • 1
  • 29
  • 35
  • One process or one thread? It is a single application accessing the file so I don't think it would be a problem. – Leahn Novash May 22 '09 at 23:56
  • I'm fairly certain its just a one process limitation. It requires exclusive access to the file. But I think multiple threads should be fine. I never tried myself. – Joel Lucsy May 23 '09 at 01:08
  • Just found this information at http://download.microsoft.com/download/e/8/8/e8859616-e95d-41fe-9f81-ff88388d772b/SQLServer%202008CompareComapctExpress.pdf It seems it doesn't have views, triggers, or stored procedures. Of course, sqlite doesn't have stored procedures either, but it does the other two. – Joel Lucsy May 23 '09 at 01:11
  • there is no mdf in sql compact, it is sdf as far as i know. – iTSrAVIE Feb 05 '11 at 11:05
1

Access was MDB (I believe it's changed for recent versions) - SQL Server full version defaults to MDF.

I confess I decided though that compact was just too much hassle from the docs so went with SQLite.

eftpotrm
  • 2,241
  • 1
  • 20
  • 24
0

I do not SQL Server compact edition. It is a accessible by single thread , does not have any good features. you have to write query every time for everything. moreover as far as i know it is not indexed. correct me, if i am wrong on this point. But, at the end it is very slow for any desktop task.

SQL Server Compact will run under medium trust under ASP.NET 4, and supports both x64 and x86 platforms. It is limited to max 256 concurrent connections. It is file based, and not quite as robust as SQL Server, and does not support recovery to a point in time.

iTSrAVIE
  • 846
  • 3
  • 12
  • 26