Primary key composed

subsonic

Customer customer = new Cliente(4);

In the code an object customer is created locating through IdCliente = 4

How would to create an object customer that possesses a primary key composed, to idEmpresa and idCliente?

Best Answer

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/.

Related Solutions

Asp – Subsonic ActiveRecord and foreign key property names

My first thought is you don't want to do this (the FK to the membership table). While convenient - you're tying your design to another system which can be an issue.

What I might suggest is having an intermediary table - Users if you will - and leave the FK relationship off.

That said - yes you should be able to tweak the templates (assuming you're using 3.0) to accomodate your needs.

R – Getting Record ID after saving with SubSonic 2.2

You can simply do

Product.Save();
int id = Product.ID; //or whatever your ID column is

Best Answer

Related Solutions

Asp – Subsonic ActiveRecord and foreign key property names

R – Getting Record ID after saving with SubSonic 2.2

Related Topic