I ave table structure like this
user has many user profiles, user_profile table join user and profile tables together.(there is a many to many relationship between user and the profile table)
user>many user_profiles> one profile
How can i select user with profile by using linq.
Found the answer
dbContext.Users .Include(user => user.UserProfiles) .ThenInclude(userProfiles => userProfiles.Profile) .Where(predicate) .FirstOrDefault();