using System;

using System.Linq;

using Microsoft.EntityFrameworkCore;

​

public class Program

{

    public static void Main()

    {

        using MyDbContext context = new MyDbContext();

        var clients =

            context.Clients

                .Include(c => c.Address)

                .Where(c => c.LastName == "patel")

                .ToList();

    }

}

​

public class Client

{

    public int Id { get; set; }

​

    public string LastName { get; set; }

​

    public string Gender { get; set; }

​

    public DateTime DateOfBirth { get; set; }

​

    public Address Address { get; set; }

}

​

public class Address

{

    public int Id { get; set; }

​

    public string FirstLine { get; set; }

​

    public string SecondLine { get; set; }

​

    public string Province { get; set; }

}

​

public class MyDbContext : DbContext

{

    public DbSet<Client> Clients { get; set; }

    public DbSet<Address> Addresses { get; set; }

}