System.Data.SQLite

is it hard to implement property like: bool GetAutoincementPrimaryKeyValueFromDataSource (true/false) to the primary key column that after dataadapter.insert will get last_insert_rowid() and set this value to proper column in datatable? it would easy application developing, i think:) or maybe it is easy way to get aptodate values of ID column in e.g. datagridview after insert new records?

You can query table 'sqlite_.sequences' to find all tables which they have autoincrement PKs.

Then use connection.GetSchema("columns") to get all PKs.

You can call GetSchemaTable() on an open DbDataReader to get information about a particular query and whether or not a particular column in the query is an AutoIncrement column as well.

Robert