public void ParseOracle12Identity() { //arrange var table = new DatabaseSchema(null, SqlType.Oracle) .AddTable("Demo") .AddColumn("ID", DbType.Int32).AddPrimaryKey() .AddColumn("NAME").Table; var dataTable = new DataTable("Name") { Locale = CultureInfo.InvariantCulture }; dataTable.Columns.Add("TableName"); dataTable.Columns.Add("ColumnName"); dataTable.Columns.Add("IDENTITY_OPTIONS"); dataTable.Columns.Add("GENERATION_TYPE"); dataTable.Rows.Add(new object[] {"Demo", "ID", "START WITH: 1, INCREMENT BY: 1, MAX_VALUE: 9999999999999999999999999999, MIN_VALUE: 1, CYCLE_FLAG: N, CACHE_SIZE: 20, ORDER_FLAG: N", "BY DEFAULT"}); //act SchemaConstraintConverter.AddIdentity(dataTable, table); var id = table.FindColumn("ID"); //assert Assert.IsTrue(table.HasAutoNumberColumn); Assert.IsTrue(id.IsAutoNumber); Assert.AreEqual(1, id.IdentityDefinition.IdentitySeed); Assert.AreEqual(1, id.IdentityDefinition.IdentityIncrement); Assert.IsTrue(id.IdentityDefinition.IdentityByDefault); }