[mono-android] Would you recommend Android.Database.Sqlite or Mono.Data.Sqlite?

[Jonathan Pryor]

On Feb 28, 2012, at 12:53 PM, Miroslav Pomšár wrote:
> Sorry to jump in, but what is the reason Mono.Data.Sqlite is not supported on Android 2.1?

Because it broke when I tried to use it on the Android 2.1 emulator. ;-)

More specifically, it's because the libsqlite.so that's included with Android 2.1 and earlier lack many of the exports that Mono.Data.Sqlite requires. Android 2.2+ isn't perfect here either -- see https://bugzilla.xamarin.com/show_bug.cgi?id=2128 -- but at least with Android 2.2+ you can actually use a SqliteCommand. Trying the SanityTests SQLite tests failed on 2.1, which is why I say that it doesn't work there. :-)

	https://github.com/xamarin/monodroid-samples/blob/master/SanityTests/Hello.cs#L101
	https://github.com/xamarin/monodroid-samples/blob/master/SanityTests/Hello.cs#L152
	https://github.com/xamarin/monodroid-samples/blob/master/SanityTests/Hello.cs#L585

 - Jon