Association not imported in EF4 designer for non-primary key

Question

The relationship 'FK_EXTERNAL_ISMARKETI_MARKETIN' has columns that are not part of the key of the table on the primary side of the relationship. The relationship was excluded.

USE [Instruments.UnitTest] GO

ALTER TABLE [Instr].[ExternalIdentification]  WITH CHECK ADD  CONSTRAINT [FK_EXTERNAL_ISMARKETI_MARKETIN] FOREIGN KEY([InstrumentID], [MarketInstrumentID])
REFERENCES [Instr].[MarketInstrument] ([InstrumentID], [MarketInstrumentID])
GO

ALTER TABLE [Instr].[ExternalIdentification] CHECK CONSTRAINT [FK_EXTERNAL_ISMARKETI_MARKETIN]
GO

I'm using an association for NON-PRIMARY KEY columns, is this possible in the EF4?

Answer 1

Such associations are not supported in EF v4.