Sqlite-net: Support for SQLitePCLRaw 2.0 version

[KalyanXamarin]

[rbev]

This is critical as other projects have moved on to the 2.0 version and there are breaking changes, this means either migrating away from this product or remaining version locked on everything else

[ericsink]

See the 1.7 beta package on nuget.

E

On Thu, Nov 7, 2019 at 9:31 PM Rhys Bevilaqua [e-mail]
wrote:

This is critical as other projects have moved on to the 2.0 version and
there are breaking changes, this means either migrating away from this
product or remaining version locked on everything else

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/praeclarum/sqlite-net/issues/865?email_source=notifications&email_token=AA5SRDOLGPDSJO6CNPP56QLQSTFO3A5CNFSM4IO25ED2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEDOQWPY#issuecomment-551357247,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AA5SRDPCFEG2GZ4X4MP5BGTQSTFO3ANCNFSM4IO25EDQ
.

[rbev]

While that will probably get me by temporarily there is a perceived risk within my organisation when publishing "beta" software into production.

[bcaceiro]

Any news on this subject?

[JKennedy24]

Just want to clarify. Does V1.7-beta support Sqlite.Core 2.0.2?

Asking as AppCenter has been updated to use Sqlite.Core 2.0.2 so there is more pressure to upgrade
ref: https://github.com/microsoft/appcenter-sdk-dotnet/issues/569#event-3058551270

[Brosten]

How stable could we consider the beta to be?

[nicolgit]

any news on support to 2.0.2?

[ericsink]

Lots of people are using the 1.7 "beta" with no problems. I don't think of it as a beta. I think of it as a shipping release with an unfortunate label.

[xhashimks]

@ericsink
I tried 1.7-beta and it worked. But i am facing issue while running this in iOS14 beta. Throwing below exception

{SQLite.SQLiteException: Row
at SQLite.SQLiteCommand.ExecuteNonQuery () [0x000ca] in :0
at SQLite.SQLiteConnection.Execute (System.String query, System.Object[] args) [0x00039] in :0
at SQLite.SQLiteConnection.SetKey (System.String key) [0x00026] in :0
at SQLite.SQLiteConnection..ctor (SQLite.SQLiteConnectionString connectionString) [0x0011a] in :0
at SQLite.SQLiteConnectionWithLock..ctor (SQLite.SQLiteConnectionString connectionString) [0x0000b] in :0
at SQLite.SQLiteConnectionPool+Entry.Connect () [0x0001c] in :0
at SQLite.SQLiteConnectionPool.GetConnection (SQLite.SQLiteConnectionString connectionString) [0x00048] in :0
at SQLite.SQLiteAsyncConnection.GetConnection () [0x00005] in :0
at SQLite.SQLiteAsyncConnection+<>c__DisplayClass32_01[T].<WriteAsync>b__0 () [0x00000] in <b2b209c20ae740d78774d0d2d1abab3c>:0 at System.Threading.Tasks.Task1[TResult].InnerInvoke () [0x0000f] in /Library/Frameworks/Xamarin.iOS.framework/Versions/Current/src/Xamarin.iOS/external/corert/src/System.Private.CoreLib/src/System/Threading/Tasks/Future.cs:534
at System.Threading.Tasks.Task.Execute () [0x00000] in /Library/Frameworks/Xamarin.iOS.framework/Versions/Current/src/Xamarin.iOS/external/corert/src/System.Private.CoreLib/src/System/Threading/Tasks/Task.cs:2319 }

var sqlConnectionOptions = new SQLiteConnectionString(dbPath, true, "TestKey");
database = new SQLiteAsyncConnection(sqlConnectionOptions);
database.CreateTableAsync<UserData>().Wait();  // Exception throwing in this line

public class UserData
    {
        [PrimaryKey]
        public string UserId { get; set; }
        public int RollNo { get; set; }
        public string Created { get; set; }
        public string Updated { get; set; }
        public bool IsActive { get; set; }
    }

[ericsink]

1.7 is out of beta, so you can use the released version

[xhashimks]

@ericsink

I tried the released one. But I am getting file is not database error. Because, in my previous app I was using the encrypted DB created using sqlite-net-pcl. But after upgrade, for encryption i have to use sqlite-net-sqlcipher. So when I upgrade from app using sqlite-net-pcl to app using sqlite-net-pclcipher, i am getting file is not a database error. Please help me. I am stuck here

[ericsink]

When you updated to SQLitePCLRaw 2.0, the version of sqlcipher was updated as well, from 3.x to 4.x. Version 4 does not work with 3.x databases by default. This may be the problem you are seeing.

I cannot provide much support for using SQLCipher. I usually recommend that people purchase SQLCipher builds/support from Zetetic.