Multi Primary Keys not allowed ?

[markusalbrecht-procam]

A question regardin the Table creation as in Standard SQLite it is possible to create tables contining multiple PRIMARY KEYs like e.g.:

CREATE TABLE something ( column1, column2, column3, PRIMARY KEY (column1, column2) );

When doing this via sqlite-net by using classes like this:

It always returns an Error: table "TB_TechnicalAttribute" has more than one primary key

Is there a way top achieve this ?

[markusalbrecht-procam]

DB.Execute allows it:

but I cannot use the internal models and need to use a string query what I actually try to avoid wherever I can. In case tablemodels get extended later on we always nee to also check the Execute strings.

[mwa-corey]

looks like its probably not going to happen. Open issue for years. https://github.com/praeclarum/sqlite-net/issues/280