System.Data.SQLite

 AND... how can I create a sqlite database including the table structure of another sqlite database ?

System.IO.File.Copy(oldDatabase, newDatabase)

 I am trying to make sqlite create a fully working dbase if there is no db file for whatever reason. However the following statement gives errors about the auto increment part.

CREATE TABLE Actor ([Actor_ID] bigint PRIMARY KEY NOT NULL AUTO_INCREMENT, [Last_Name] NVARCHAR(50) NOT NULL, [First_Name] NVARCHAR(50) COLLATE NULL

 Do i actually need the autoincrement or is that done automatically. in normal sql create statements i see either the auto increment of the identity parameter but that also gave an error.

I just noticed something i don't really get. I added a new record to the table Actor (i'm making a personal movieDB) and i used the auto generation of the ID to make a new unique ID. This was the first record in the table so naturally it was given the value 0. If i however try to delete the record using that ID nothing happens. It is as if the value in the database is not really a normal 0 and thus the ID's don't match up.

The table itself is very basic. ID(bigint), Last_Name(nvarchar), First_Name(nvarchar)

Using this statement to get the value of an ID it returns the value '0' 

SELECT     Actor_ID
FROM         Actor
WHERE     (Last_Name = 'test')

Therefor i input the value in the next query and every time i get the message '0 rows affected by last query'

DELETE FROM Actor
WHERE     (Actor_ID = '0')

 I tried adding a record with ID 0 manually and there was no poblem whatso ever deleting it.

What am i missing here?

 never mind i found it. something went wrong with the adding of a record and the value wasn't really '0' but instead it was 'NULL'