Forum

I am trying to get my objects all connected to the database properly with the DAL2.  One thing that came up was what to do when there is a multiple field primary key.  Specifically I have a table that uses 2 varchar(50) fields to create the primary key.  I would like to use the GetById() function because it automatically incorporates caching but it doesn't appear to take multiple fields for the key. 

What is the best way to retrieve an object using a multiple field primary key?

I have done some additional research and testing.  It does not appear that composite keys are supported.  Designing things as you suggest appears to be the best way to do things:

• Add an id field that will be used as the primary key.
• Add a unique constraint to the table for the multiple fields.

Since selects for any table like this will likely need to be based on the unique fields and not the id, caching will have to be handled manually if needed.