Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Multi Primary Keys not allowed ? #1101

Open
markusalbrecht-procam opened this issue Feb 18, 2022 · 2 comments
Open

Multi Primary Keys not allowed ? #1101

markusalbrecht-procam opened this issue Feb 18, 2022 · 2 comments

Comments

@markusalbrecht-procam
Copy link

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:

image

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

Is there a way top achieve this ?

@markusalbrecht-procam
Copy link
Author

DB.Execute allows it:

image

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
Copy link

looks like its probably not going to happen. Open issue for years.
#280

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants