Can you use SQL Compact 3.5 with Unity?

Questions & Answers
1

I've been reading over the various SQL connectivity and dB question for the past week or so and have not seen any references to using SQL Compact. It seems that the preferred local dB is SQLLite. I'm trying to decide if I want to use an xml style dB or SQL Compact, and now I suppose SQLLite.

Has anyone used SQL Compact 3.5 with Unity? Is SQL Compact 3.5 compatible with Unity?

Link to SQL Compact 3.5 for those curious: http://www.microsoft.com/sqlserver/2005/en/us/compact.aspx

Thanks to everyone for taking a moment to review this question.

2

It's probably compatible with Unity standalones that run on Windows. It won't be compatible with Web players, and it won't work anywhere except for Windows. That much is sure.

As I'm pretty sure that SQL Compact provides a .NET API, you should be able to use it from Windows standalones, though. Just checked it ... "tightly integrated with [...] .NET Framework" ... good for you ;-) ... "ADO.NET" ... good for you ;-)