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 question correctly. For now, I'll assume you can modify the CREATE TABLE statement itself. In that case, you can make use of the PRIMARY KEY clause on one of the column definitions, such as: CREATE TABLE t1(x TEXT PRIMARY KEY, y TEXT); -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users