Xamarin forms SQLite for Android

Question

so i have already made one app that was a test app and it worked just fine using sqlite-net-pcl and i an now making an actual app and i am getting this weird error and i cant figure out why. i found the exact same question already asked on here but it didnt provide any real answer and it was over a year ago.

System.Exception: Something went wrong in the build configuration. This is the bait assembly, which is for referencing by portable libraries, and should never end up part of the app. Reference the appropriate platform assembly instead.

public SQLite.SQLiteConnection GetConnection()
    {
        var sqliteFilename = "TestDB.db3";
        string documentsPath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal); // Documents folder
        var path = Path.Combine(documentsPath, sqliteFilename);
        // Create the connection
        var conn = new SQLite.SQLiteConnection(path);//HERE IS WHERE IT THROWS THE EXCEPTION
        // Return the database connection
        return conn;
    }

the app works for every other platform i have tried except android and my test app that worked just fine is using the exact same references and same class as well i just cant figure it out. i have tried referencing the sqlite-net-pcl and made a new class still doesnt work. any help would be greatly appreciated thank you very much

do you have the SQLite package installed in BOTH your shared project and your individual platform projects? — Jason
yes i double checked and i have uninstalled and reinstalled multiple times — hartk1213
Did you try a clean and rebuild of your project and solution? Maybe some old/wrong DLL got cached in there — Gerald Versluis

Bonelol Bonelol · Accepted Answer · 2016-09-16T03:27:22

Here is the one I am using https://github.com/oysteinkrog/SQLite.Net-PCL

Check you referenced SQLite.Net.Platform.XamarinAndroid in your Android project.

Here is the code which is working fine for me (I also included SQLite.Net.Async-PCL)

public SQLiteAsyncConnection GetConnection()
        {
            // database name
            const string SQLITE_FILENAME = "MyDB.db3";

            // Get app folder
            string documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); 
            string path = Path.Combine(documentsPath, SQLITE_FILENAME);

            var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid();
            var sqliteConnection = new SQLiteConnectionWithLock(plat, new SQLiteConnectionString(path, true)){BusyTimeout = TimeSpan.FromSeconds(5)};
            var conn = new SQLiteAsyncConnection(() => sqliteConnection,
                TaskScheduler.FromCurrentSynchronizationContext());

            // Return the database connection 
            return conn;
        }

Guess this should work:

public SQLiteConnection GetConnection()
        {
            // database name
            const string SQLITE_FILENAME = "MySIT.db3";

            // Get app folder
            string documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); 
            var plat = new SQLite.Net.Platform.XamarinAndroid.SQLitePlatformAndroid(); //important!
            string path = Path.Combine(documentsPath, SQLITE_FILENAME);            
            var conn = new SQLiteConnection(plat, path); 

            // Return the database connection 
            return conn;
        }

Xamarin forms SQLite for Android

1 Answers