I'd like to use composite primary key in many-to-many table relationship. The obj class to create table is:
[Table("relationsip_tab")]
class HtmlSrcFileRelationship {
[Column("src_fk"),PrimaryKey]
public string srcFk { get; set; }
[Column("file_fk"), PrimaryKey]
public string fileFk { get; set; }
}
It gave me an error EXCEPTION: SQLite.Net.SQLiteException: table "relationsip_tab" has more than one primary key
I am using Sqlite for Universal Windows Platform,SQLite.Net-PCL and System.Data.SQLite as references. Is there a way to do it?