public void SetTableAutoIncrementStartTest() { using (var ds = new SQLiteDatastore()) { ds.Execute("CREATE TABLE tbl (id INTEGER PRIMARY KEY AUTOINCREMENT);"); ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(0); ds.Execute("INSERT INTO tbl DEFAULT VALUES;"); ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(1); ds.SetTableAutoIncrementStart("tbl", 100); ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(1); ds.Execute("INSERT INTO tbl DEFAULT VALUES;"); ds.ExecuteScalar <int>("SELECT max(id) FROM tbl;").Should().Be(101); } }