Looking for xamarin cross platform sqlite provider try SQLite.Net-PCL


Hunting down the correct nuget packages that works for your Xamarin pcl (shared) project is not so easy. A library as common as sqlite can really squeeze some hours out of you.

A cross platform sqlite that i successfully used in my project as a shared xamarin project is :
SQLite.Net-PCL. The only catch to this is you have to install it on portable project, android target and ios target project.

The code below is only for demo purposes.

In your portable code, you probably have something like this.



In your android project, you need to add a reference to your shared project and initialize your platform specific sqlite.



In your IOS project, you need to add a reference to your shared project and you need to use the following code.







Comments

Post a Comment

Popular posts from this blog

The specified initialization vector (IV) does not match the block size for this algorithm

Image
If you're getting  exception when trying to assigned key to a symmetric key and getting error message below :- The specified initialization vector (IV) does not match the block size for this algorithm And your code probably look like something below :- Then you need to go into debug mode and start looking into the supported size for IV as shown in diagram below :- As you can see, IV is 16 bytes, so you need to provide 16 bytes. The same goes for Key field too, if you're adding anything to it. As long as you provide a valid key size, then we're good and you're code will be ready.
Read more