Switched from Sqlite.net-pcl to sqlite-net-pcl. Now child objects null on GetAllWithChildrenAsync

Hello

we had been using SQLite.net-pcl previously but had to make an abrupt switch because of encoding issues we uncovered which were echoed elsewhere by other teams.

When swapping to sqlite-net-pcl I was relieved to see this project had migrated its dependencies as well. We use it a lot :) The version we upgraded to is SQLiteNetExtensions.Async.2.0.0-alpha2

However, I am noticing the following no longer works for us.

We had classes declared that enforced generic inheritance like so:

public abstract class AbstractViewModel<T> : where T : AConcreteClass
{
public async Task Example()
{
     var con = db.AsyncConnection;

      var masterList = await con.GetAllWithChildrenAsync<T>(null, true);
}
}

When swapping base sqlite library to sqlite-net-pcl I notice the Generic arguments for db table queries, etc require inheriting from new(), where as before you could use class.

So I updated my class like so:

public abstract class AbstractViewModel<T> : where T : AConcreteClass, new()
{
public async Task Example()
{
     var con = db.AsyncConnection;

      var masterList = await con.GetAllWithChildrenAsync<T>(null, true);
}
}

And thankfully it compiles!

However now in the returned results all children are null. The only change to the models themselves were to swap out the namespace so our meta tags would compile (Table, Column, etc). The first code sample above was working before having to migrate the libraries.

Is our approach still viable with the new dependencies or is this just a bug? I would be happy to provide any additional info as this will force a major refactor if unable to get it working.

****UPDATE I tested this in a plain class and referenced the table directly, ie:

var masterList = await con.GetAllWithChildrenAsync<MyMasterClass>(null, true);

It still returns null unfortunately.

Thanks!

Comments (7)