C#•3y ago

EF navigation property is unattached from dbContext

Hello!
There are 2 Entities in relation with each other:

User

User

User

User and

Domain

Domain

Domain

Domain. When I want to insert a new Domain to the database an exception will occur, because the User related to it is not tracked.

There are 2 solutions, but I cannot decide which one is better.

Do an extra query to get the User:
```
domain.User = userRepo.FindUser(userId)
```
domain.User = userRepo.FindUser(userId)
```
domain.User = userRepo.FindUser(userId)
```
domain.User = userRepo.FindUser(userId)
Write an extra class that attaches the user to the context:
```
extraClass.AttachToDbContext(new User(userId))
```
extraClass.AttachToDbContext(new User(userId))
```
extraClass.AttachToDbContext(new User(userId))
```
extraClass.AttachToDbContext(new User(userId))
- no extra query performed (User already exists in the database)

I like the 2nd option better, but would like to hear other opinions

c#
public class User
{
    public string UserId { get; set; }
}

public class Domain
{
    public Guid DomainId { get; set; }
    public string DomainName { get; set; }

    public User User { get; set; }
}

c#
public class User
{
    public string UserId { get; set; }
}

public class Domain
{
    public Guid DomainId { get; set; }
    public string DomainName { get; set; }

    public User User { get; set; }
}

c#
public class User
{
    public string UserId { get; set; }
}

public class Domain
{
    public Guid DomainId { get; set; }
    public string DomainName { get; set; }

    public User User { get; set; }
}

c#
public class User
{
    public string UserId { get; set; }
}

public class Domain
{
    public Guid DomainId { get; set; }
    public string DomainName { get; set; }

    public User User { get; set; }
}

EF navigation property is unattached from dbContext

Similar Threads

Similar Threads

Similar Threads