Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

2014-04-01 Thread Joe Mistachkin
Benedikt Neuhold wrote: > > we are building an App for Windows 8 and want to use sqlite as local DB. We > want to separate our Models from our DB Engine. So we need a way to set the > Primary Key without DataAnnotation. Is there a way? > I'm trying to figure out if I'm understanding your

Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

2014-04-01 Thread Doug McDonald
We achieved something similar by doing the following: Creating a seperate assembly for our entities Define the primary key attribute in that assembly, but inside the SQLite namespace. Comment out the primary key attribute in the SQLite/net project to avoid re-defining it. We were then able to

Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

2014-04-01 Thread Paul
If I understood you right... 1) Create teable without primary key. 2) Separately create unique index on the column you want to be primary key. > Hi, > > > > we are building an App for Windows 8 and want to use sqlite as local DB. We > want to separate our Models from our DB Engine. So we need

[sqlite] Primary Key without DataAnnotation for Windows Runtime

2014-04-01 Thread Benedikt Neuhold
Hi, we are building an App for Windows 8 and want to use sqlite as local DB. We want to separate our Models from our DB Engine. So we need a way to set the Primary Key without DataAnnotation. Is there a way? Thanks a lot! ___ sqlite-users