Subsonic generate table without primary key

subsonic

I need to generate a table without primary key. Its absolutely neccessary that the table dosen't have primary key. Please help.

Best Solution

Is there any reason you cannot use something like sequences?

class Something {
     private static final SEQUENCE seq = getDBsequence()

     @id
     private final long id = seq.newNumber();

     private final String whateverData;
}

EDIT:The way I wrote this was kinda dumb because once you reboot the app. you'll get duplicate keys.. You should use a sequence provided by the DB. Sorry about that.

Related Solutions

Primary key composed

I think you're asking if you can load an subsonic object that has a composite key.

Customer customer = new SubSonic.Select()
  .From(Customer.Schema)
  .Where(Customer.IdEmpresaColumn).IsEqualTo(idEmpresa)
  .And(Customer.IdClienteColumn).IsEqualTo(idCliente)
  .ExecuteSingle();

Please read http://subsonicproject.com/querying/select-queries/.

SubSonic 3 / ActiveRecord – Easy way to compare two records

The best way, if using SQL Server as your backend as this can be auto populated, is to create a derived column that has a definition that uses CHECKSUM to hash the values of "selected" columns to form a uniqueness outside of the primary key.

EDIT: if you are not using SQL Server then this hashing will need to be done in code as you save, edit the row.

Best Solution

Related Solutions

Primary key composed

SubSonic 3 / ActiveRecord – Easy way to compare two records

Related Question