Xamarin Form Sqlite Connection : Method not found: int SQLite.SQLiteConnection.CreateTable<!0>(SQLite.CreateFlags)

Question

The build is success but when it comes to this method, it throws exception. This happened when I updated new packages at NuGet Packages.

public static string checkToken()
        {
            string token1 = "";
            try
            {
                SQLiteConnection db = DependencyService.Get<SQLiteInterface>().GetConnection();
                db.CreateTable<Token>();
            Token t = db.Table<Token>().FirstOrDefault();
            if (t != null)
            {
                DateTime dt = t.timeCreated;
                DateTime tmp = DateTime.Now;

                double diff = (tmp - dt).TotalMinutes;
                if (diff > 60.0 || App.IsUserLoggedIn == false)
                {
                    token1 = "expired";
                    db.Delete(t);
                }
                else
                {
                    token1 = t.token;
                }
            }
        }
        catch (Exception e)
        {
            e.ToString();
        }
        return token1;
    }

Here is the image.

UPDATED:

This packages from .Droid

This package from Portable

Can you add a list of the SQLite nuget packages you are using? — Janwilx72
– Janwilx72, Commented Jan 10, 2020 at 8:00
Depends where you're using it. Some of the older SQLite packages gives lots of errors. I essentially removed all packages referring to sqlite in all projects and then used sqlite-net-pcl in the shared project. That means you also don't ave to interface out to create your SQLite db. It works in the shared project — Janwilx72
– Janwilx72, Commented Jan 10, 2020 at 8:03

Janwilx72 · Accepted Answer · 2020-01-10 08:50:16Z

It's annoying, but there's a very good chance you're going to have to delete all of those packages and reinstall them. Try to remove them and add the following packages

SQLitePCLRaw.bundle_green Version 1.1.2 in your native projects (Not in PCL)

SQLitePCLRaw.core Version 1.1.2 in your native projects (Not in PCL)

SQLitePCLRaw.lib.e_sqlite3.android Version 1.1.2

SQLitePCLRaw.provider.e_sqlite3.android Version 1.1.2

SQLitePCLRaw.provider.sqlite3.ios_unified Version 1.1.2

and then when you create the database, initialise it using the following code as the path:

string path = System.IO.Path.Combine(System.Environment
            .GetFolderPath(System.Environment.SpecialFolder.Personal), "localstore.db");

OR

If that doesn't work, remove all of them and only add the following one all of your projects

https://www.nuget.org/packages/sqlite-net-pcl/

I hope this helps

Cherry Bu - MSFT · Accepted Answer · 2020-01-10 09:08:46Z

1

As Janwilx72 said that you need to install sqlite-net-pcl package by Nuget for Pcl and Platforms. Don't need the package that you provided.

Then you can use SQLiteConnection.CreateTable() and have no issue.

I do one sample for Android at github, that you can take a look:

https://github.com/CherryBu/sqliteapp

If you want to do this in ios or other platform, you can take a look this article:

https://dzone.com/articles/register-and-login-using-sqlite-in-xamarinforms

https://learn.microsoft.com/en-us/archive/msdn-magazine/2016/july/xamarin-working-with-local-databases-in-xamarin-forms-using-sqlite

answered Jan 10, 2020 at 9:08

Cherry Bu - MSFT

10.3k1 gold badge12 silver badges17 bronze badges

1 Comment

Cherry Bu - MSFT Over a year ago

@Ticherhaz, if my reply help you, please remember to mark my reply as answer, thanks.

Collectives™ on Stack Overflow

Xamarin Form Sqlite Connection : Method not found: int SQLite.SQLiteConnection.CreateTable<!0>(SQLite.CreateFlags)

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related