Can I use SQL Server Compact Edition CE on Mono?

问题:

Does anyone know if I can use SQL Server Compact Edition 3.5 on mono?

I'm hoping they are written as managed assemblies and will work ok..does anyone have any experience?

回答1:

All of the SQL Compact (except System.Data.SqlCe.dll obviously) are native libraries, so no they won't work under non-Windows platforms.

回答2:

Pretty replacement for SQL CE is SQLite

SQLite ADO.NET Provider is portable and exists on Microsoft.NET and Mono

http://sqlite.phxsoftware.com

http://www.mono-project.com/SQLite

native components is exists for most major platforms and source code also available

回答3:

(By 'on mono' I assume you mean running on Mono in Linux?)

No. I'm pretty sure none of the SQL Server versions are built on managed assemblies.