Unique index as Principal Key

Question

Hi,

create table [mytab1]
(
 [colA] varchar(30) not null,
 [colB] varchar(14) not null,

 constraint [mytab1_pk] primary key
  ([colA],[colB])
)

create unique index [mytab1CandidateKey] on
[mytab1]([colB])

 

create table [mytab2]
(
 [colB] varchar(14) not null,
 [colC] varchar(10) not null,

 constraint [mytab2_pk] primary key
  ([colB],[colC])
)

 

In EF "ADO.NET Entity Data Model" I would like to make an association mytab1mytab2  (1:n) using the candidate key mytab1.colB as the Principal Key.
This seems to be possible in "Link to SQL Classes".
Has the possibility to use a non primary key  but candidate key (uniquely indexed) as the Principal Key, deliberately been left out in EF?

Regards Roger.

Answer 1

Hi RogerRab,

Welcome!

You should add FK between your two tables, here is my reply for the similar question, you can refer here: http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/05ed9f9a-80d0-4b5c-8438-e67658124c43

Have a ncie day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi,

I am writing to check the status of the issue on your side. Would you mind letting us know the result of the suggestions?

If you need further assistance, please feel free to let me know. I will be more than happy to be of assistance.

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.