sqlite-net-pcl SqliteAsyncConnection.CreateTableAsync<T> throws System.MissingMethodException

Question

I am trying to create a table using the latest version of sqlite-net-pcl nuget package

var db = new SQLiteAsyncConnection("data.db");
await db.CreateTableAsync<Site>();

The CreateTableAsync call throws the following exception:

System.MissingMethodException: 'Method not found: 'System.String SQLitePCL.raw.sqlite3_column_name(SQLitePCL.sqlite3_stmt, Int32)'.'

Here is the Site class

public class Site
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }

    public String Name;
    public String PriceCssSelector;
    public String URLRegex;

    public Site()
    {
    }
}

I tried downgrading to the latest stable version of sqlite-net-pcl package.

@jdweng Yes. When I downgrade the exception changes to FileLoadException: Could not load file or assembly 'SQLitePCLRaw.batteries_v2, Version=1.1.11.121, Culture=neutral, PublicKeyToken=8226ea5df37bcae9' or one of its dependencies. — JohnWick
– JohnWick, Commented Sep 1, 2019 at 9:57
I suspect the version is wrong. For testing create a simple new project just adding the sqllite library and see if you get the same error. You can then edit your .proj file and copy the version number from the test project .proj file. This usually works. — jdweng
– jdweng, Commented Sep 1, 2019 at 10:15

MariusKoch · Accepted Answer · 2020-02-21 21:18:24Z

6

In my case the problem was Microsoft.AppCenter and Microsoft.Appcenter.Distribute. Those packages bring in an incompatible SQLite version and downgrading/removing them solved the problem.

answered Feb 21, 2020 at 21:18

MariusKoch

611 silver badge4 bronze badges

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

Comments

JohnWick · Accepted Answer · 2019-09-01 10:33:40Z

0

Deleting the app.config file in my project seems to have solved the problem.

answered Sep 1, 2019 at 10:33

JohnWick

5,1399 gold badges43 silver badges79 bronze badges

Comments

Alex · Accepted Answer · 2019-10-31 21:32:14Z

0

I resolved this error, by creating a fresh new solution and manually copying over all the code & models, then let Visual Studio import all the needed references from Nuget.

Uninstalling, reinstalling or removing packages from Nuget in my old/previous solution/project did not help/work.

Apparently lingering or conflicting references from previous Nuget packages is the problem so starting fresh is the only thing that worked for me.

See this link as well:

similar StackOverFlow post for 'System.MissingMethodException: Method not found?'

edited Oct 31, 2019 at 21:32

answered Oct 31, 2019 at 19:36

Alex

2284 silver badges8 bronze badges

Comments

Alexei - check Codidact · Accepted Answer · 2020-05-31 15:54:01Z

0

I have stumbled across this error after installing sqlite-net-pcl (for toying with SQLite) and after that I have installed Microsoft.Azure.Mobile.Client.SQLiteStore.

My solution was to uninstall both NuGet packages and install Microsoft.Azure.Mobile.Client.SQLiteStore only which installed the appropriate sqlite-net-pcl version.

answered May 31, 2020 at 15:54

Alexei - check Codidact

23.2k22 gold badges159 silver badges179 bronze badges

Collectives™ on Stack Overflow

sqlite-net-pcl SqliteAsyncConnection.CreateTableAsync<T> throws System.MissingMethodException

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related