Hi Yang,
Most designers are lacking a bit inside the dev environments. You could use the sqlite command-line tool available from the
downloads page at
http://sqlite.org/
or indeed any of the DB Management GUIs out there for SQLite such as these:
http://www.sqliteexpert.com/
http://www.rifin.co.za/software/sqlc/
Note: Only the Command-line facility is officially supported, for support with the others you will need to contact their own
lists/proprietors/etc.
Alternately, you can simply directly execute some SQL to create your tables via
the API, such as:
CREATE TABLE SomeTableName (
IDKey INTEGER PRIMARY KEY AUTOINCREMENT /* Item ID */,
ColX TEXT NOT NULL /* Some column */,
ColY TEXT NOT NULL /* Some other column */,
ColZ TEXT NOT NULL /* Some more columns etc. */
);
Which will do what you need.
Good luck!
On 2014/04/21 22:13, Yang Hong wrote:
Hello, all:
I am using VS2013 + sqlite.net for 4.5.1 with 32 bit. I have question for a
primary key with auto increment. I can't figure out how to do it in C#. when
I use sqlite datasource designer in VS2013. It has option to add identity
checking, however, this feature doesn't work even I check this option. Do
you have anybody to help me out?
Regards,
yh
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users