C# How to add in DB SQLite a list<string>

Question

It's the first time I work with SQLite DB, I'm trying to add a List in my table.

This is my class :

public DbF(string title, string content, bool myfavoris, int partner, List<string> tags)

I add like that :

obj.Insert(new DbFavoris(title, content, true, partner, tags));

I got this error :

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

I realized after searching, we can't add directly a List but I don't know how to do because I retrieved my tags with a JSON I put the data immediately in a List.

I'm not very familiar with SQLite in C#, but typically when you have an object that contains a list of other objects (which would have its own DB table), you'd insert the base object first, then insert all the aggregated objects after (referring to the owner by foreign key). If the DBMS supports it, you might be able to insert all these tags at once. Otherwise you'd have to iterate through them and insert one by one (in which case you'd probably want to wrap the whole thing in a transaction in case one fails, you can undo the whole operation). — Kat
– Kat, Commented Apr 8, 2015 at 3:18

Community · Accepted Answer · 2017-05-23 12:18:01Z

1

SQLLite does not support lists. Which means you can't use List<string> tags. Similar question was also asked here. Perhaps, you can try storing your tags as pipe separated strings like 'Tag1|Tag2|Tag3' and manipulate it during retrieval. Or you can try changing you schema.

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Apr 8, 2015 at 3:40

Ebad Masood

2,38728 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

C# How to add in DB SQLite a list<string>

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related