Xamarin.Forms using SQLite.Net.Async (the NUGET part)

Question

I'm trying to make a connection to a SQLite database using Visual Studio 2015 the target platform is Android.

I've found this SO question but I can not get it to work. My problem is the part of installing packagde.

I want to have my database stuff placed in a Class Library so I've created a new Application, and added a Class Library to the solution.

To install SQLite I've written the following in the packagde manager console:

Install-Package SQLite.Net.Platform.XamarinAndroid -Version 2.3.0

But installs SQLLite into my application, not my Class Library.

My Class Library is very very simple:

    public class SQLiteDataService
    {
        private SQLiteAsyncConnection connectionFlexCheckDemo;
        private ISQLitePlatform sqlitePlatform;

        private string FlexCheckDBNameDemo = "FlexCheckDemo.db";

        private void Test()
        {
            var platform = new SQLitePlatformAndroid();            
        }    
    }

but it doesn't compile:

Error CS0234 The type or namespace name 'Net' does not exist in the namespace 'SQLite' (are you missing an assembly reference?) ...

What am I doing wrong? And more important how to make it work.

You need to install SQLLite-PCL Async to your class library and the specific platform projects. — Rohit Vipin Mathews
– Rohit Vipin Mathews, Commented Oct 27, 2015 at 8:50
Thankyou @Rohit you need to bee a little more specific because I cant find SQLLite-PCL in Nuget — Jens Borrisholt
– Jens Borrisholt, Commented Oct 27, 2015 at 8:54
I have added an answer with the link to the specific nuget, so that you don't have trouble finding it. :) — Rohit Vipin Mathews
– Rohit Vipin Mathews, Commented Oct 27, 2015 at 9:00

Rohit Vipin Mathews · Accepted Answer · 2015-10-27 09:00:02Z

1

You will have to install the Nuget or the dll to reference the SQLite-Async in your Shared or PCL project so that you can write your common code there like having common CRUD operations or having Unit Of Work coupled with Repository pattern. A simple example can be found here.

Then in your platform specific projects you need to have the nuget installed as well, which will get resolved and install the corresponding version based on your platform. I don't think there is a nuget available for WP, so you might have to look for other choices.

This is the nuget package for SQLite.Net.Async PCL

answered Oct 27, 2015 at 9:00

Rohit Vipin Mathews

11.8k15 gold badges60 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jens Borrisholt Over a year ago

Looks very promising :D

Rohit Vipin Mathews Over a year ago

@JensBorrisholt - Happy to help.

Collectives™ on Stack Overflow

Xamarin.Forms using SQLite.Net.Async (the NUGET part)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related