One-to-one relation on 2 custom attributes (no ID columns)

Hi!

I'm pulling my hair out!

I want to make a JOIN on two attributes EAN=SKU of two seperate tables:

Table Product

• Id
• Name
• EAN

Table ProductInfo

• Id
• Info
• SKU

I have added a one-to-one relationship. How can I tell Lightspeed to use EAN and SKU to do the JOIN?

Please help me with this simple issue!

This isn't possible with an association. While you could potentially use a custom column name to deal with this, the FK field for an association must be of the same type as the entities identity type and must reference the foreign tables primary key (Id property).

In cases where you want to just arbitrarily join two tables, just use Join criteria when constructing a query to handle this. Or if you want to expose some read only collections via property accessors on the entities you could handle this with some custom code like:

public IList<ProductInfo> ProductInfos
{
  get { return UnitOfWork.Find<ProductInfo>(Entity.Attribute("SKU") == EAN); }
}

And then a corresponding Products property on ProductInfo.

Jeremy