Association not imported in EF4 designer for non-primary key
Posted
by Rommel Manalo
on Stack Overflow
See other posts from Stack Overflow
or by Rommel Manalo
Published on 2010-04-27T03:43:00Z
Indexed on
2010/04/27
3:43 UTC
Read the original article
Hit count: 300
Filed under:
entity-framework
|ado.net-entity-data-model
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?
© Stack Overflow or respective owner
