Code First and WITH NOCHECK ADD equivalent

Question

Hi there,

I have a many-to-many relationship between User and Group via UserGroup table (UserId, GroupId). However, I also have some special application specific groups (e.g. Administrators) with predefined GroupId in my code, not in DB. GroupId is a GUID.

I want to be able to add an entry into UserGroup table even if the group with the given ID doesn't exist in the Group table.

Before code first, I would disable an on-add constraint when designing my tables, which would be equivalent of ALTER TABLE UserGroup WITH NOCHECK ADD CONSTRAINT FK_UserGroup_Group FOREIGN KEY (GroupId) REFERENCES Group (Id)

Is there a way to accomplish this using CodeFirst's meta-attributes? I'm not seeing anything related on ForeignKeyAttribute.

Thanks

Answer 1

On 5/21/2012 5:57 PM, DashNYC wrote:

> Hi there,

>

> I have a many-to-many relationship between User and Group via UserGroup

> table (UserId, GroupId). However, I also have some special application

> specific groups (e.g. Administrators) with predefined GroupId in my

> code, not in DB. GroupId is a GUID.

>

> I want to be able to add an entry into UserGroup table even if the group

> with the given ID doesn't exist in the Group table.

>

> Before code first, I would disable an on-add constraint when designing

> my tables, which would be equivalent of ALTER TABLE UserGroup WITH

> NOCHECK ADD CONSTRAINT FK_UserGroup_Group FOREIGN KEY (GroupId)

> REFERENCES Group (Id)

>

> Is there a way to accomplish this using CodeFirst's meta-attributes? I'm

> not seeing anything related on ForeignKeyAttribute.

>

> Thanks

>

 

That's at the database level your are talking about with T-SQL. You

can't make EF generate a NOLOCK T-SQL statement let alone what you are

talking about.

 

Answer 2

The question was about NOCHECK . The answer is about NOLOCK , which is irrelevant