sqlite not recognizing generic list

Question

On a windows store app project i get a JSON from a webservice that looks like this:http://paste2.org/jfMJ2AGA

and i have these 2 classes

public class media
{
    public string id { get; set; }
    public string type { get; set; }
    public string image { get; set; }
    public string video { get; set; }
    public string snapshot { get; set; }
    public string url { get; set; }
    public string snapshot_url { get; set; }
}

public class artigos
{
    public string menu { get; set; }
    public string submenu { get; set; }
    public string title { get; set; }
    public string subtitle { get; set; }
    public string description { get; set; }
    public List<media> media { get; set; }
}

and im creating a sqlite database with:

dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "Database.sqlite");

//start dB
using (var db = new SQLite.SQLiteConnection(dbPath))
{
    db.CreateTable<artigos>();
}

but i get this error:

Don't know about System.Collections.Generic.List`1[xxxxx.media]

Am i doing anything wrong?

it has been a while, but if i recall i think i saved a json string with media objects ids, something like [ "1234","5678","9012","3456" ] — Thought
– Thought, Commented May 27, 2016 at 9:24

ohlmar · Accepted Answer · 2014-02-17 16:11:01Z

4

Sqllite does not support lists. This means that you can´t have

public List<media> media { get; set; }

edited Feb 17, 2014 at 16:11

answered Feb 17, 2014 at 16:05

ohlmar

9548 silver badges17 bronze badges

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

Comments

Jerry Nixon · Accepted Answer · 2016-12-21 21:14:47Z

0

I had the same problem with an int[] and I did this:

[Table(nameof(Folder))]
public class Folder
{
    public Folder()
    {
        // for SQLite
    }
    internal Folder(Json.Folder folder)
    {
        Id = folder.id;
        Title = folder.title;
        Lists = string.Join(",", folder.list_ids);
    }

    [PrimaryKey]
    public int Id { get; set; }
    public string Title { get; set; }
    public string Lists { get; set; }
    public int[] ListsArray => Lists.Split(',').Select(x => int.Parse(x)).ToArray();
}

answered Dec 21, 2016 at 21:14

Jerry Nixon

32k15 gold badges124 silver badges238 bronze badges

Collectives™ on Stack Overflow

sqlite not recognizing generic list

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related