i have two already existings tables (no foreignkey):

Customer (Id, Name, .....)
Projects (Id, CustomerId, name)

And in my asp.net core application i have two model:

```
public class Customer {
   public int Id { get; set; };
   public String Name { get; set; };
}

public class Project {
   public int Id { get; set; };
   public Customer Customer{ get; set; };
   public String Name{ get; set; };
}

```

And the datacontext classes for this 

```
public class CustomerContext: DbContext
{
    public CustomerContext(DbContextOptions<CustomerContext> options) : base(options)
    {
    }

    public DbSet<CustomerContext> Customer { get; set; }
}

public class ProjectContext: DbContext
{
    public ProjectContext(DbContextOptions<ProjectContext> options) : base(options)
    {
    }

    public DbSet<ProjectContext> Project{ get; set; }
}

```

But i cant find out how to fetch the Customer object in the Projectclass by the customerId

Can someone help me please? Thank you

Edit: Now i change my Model Classes like in the answer below

but with the following i get an SQL Exception while loading the page
SqlException: Invalid object name 'Customer'.

```
        projectList = await (from project in _context.Project
                                     join customer in _customerContext.Customer on project.CustomerId equals customer.Id into tmp
                                     from m in tmp.DefaultIfEmpty()

                                     select new Project
                                     {
                                         Id = sollIst.Id,
                                         CustomerId = sollIst.CustomerId,
                                         Customer = m,
                                         Name = sollIst.Name,
                                     }
                      ).ToListAsync();

```