Steps to reproduce:
- Create two tables in the existing DB:
SQLCREATE TABLE [dbo].[MultiFKTest_Source](
[OrderId] [int] NOT NULL,
[CustomerId] [nchar](5) NOT NULL,
CONSTRAINT [PK_MultiFKTest_Source] PRIMARY KEY CLUSTERED ([OrderId] ASC, [CustomerId] ASC)
)
CREATE TABLE [dbo].[MultiFKTest_Child](
[Id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[OrderId] [int] NOT NULL,
[CustomerId] [nchar](5) NOT NULL,
CONSTRAINT [FK_MultiFKTest_Child_Source] FOREIGN KEY([OrderId], [CustomerId])
REFERENCES [dbo].[MultiFKTest_Source] ([OrderId], [CustomerId])
)
- Define a corresponding connection in Web.config and connection provider.
- Run Query Builder and drop the MultiFKTest_Source and MultiFKTest_Child tables.
Current Result:
As you can see in the https://i.imgur.com/AD9mqkT.gifv screencast, the query builder creates only a single relation for the OrderId field.
Expected Result:
Two relations for the OrderId and CustomerId should be created.