namespace Model
{
    public class MyContext : DbContext
    {
        public MyContext() : base("MyContext") { }

        public DbSet<UserType> UserTypes { get; set; }
        public DbSet<UserStatus> UserStatuses { get; set; }
        public DbSet<UserSex> UserSexes { get; set; }
        public DbSet<User> Users { get; set; }
    }

    [DataContract(IsReference = true)]
    public class UserSex
    {
        [DataMember]
        public int UserSexID { get; set; }
        [DataMember]
        public string UserSexName { get; set; }
        [DataMember]
        public string UserSexShortName { get; set; }

        [DataMember]
        public virtual List<User> Users { get; set; } = new List<User>();

        public UserSex() { }
        public UserSex(string p_Name, string p_ShortName) { UserSexName = p_Name; UserSexShortName = p_ShortName; }
        public override string ToString() => UserSexName;
        public string ToShortString() => UserSexShortName;
    }

    [DataContract(IsReference = true)]
    public class UserType
    {
        [DataMember]
        public int UserTypeID { get; set; }
        [DataMember]
        public string UserTypeName { get; set; }

        [DataMember]
        public virtual List<User> Users { get; set; } = new List<User>();

        public UserType() { }
        public UserType(string p_Name) { UserTypeName = p_Name; }
        public override string ToString() => UserTypeName;
    }

    [DataContract(IsReference = true)]
    public class UserStatus
    {
        [DataMember]
        public int UserStatusID { get; set; }
        [DataMember]
        public string UserStatusName { get; set; }

        [DataMember]
        public virtual List<User> Users { get; set; } = new List<User>();

        public UserStatus() { }
        public UserStatus(string p_Name) { UserStatusName = p_Name; }
        public override string ToString() => UserStatusName;
    }

    [DataContract(IsReference = true)]
    public class User
    {
        [DataMember]
        public int UserID { get; set; }
        [DataMember]
        public string Login { get; set; }
        [DataMember]
        public string Passowrd { get; set; }
        [DataMember]
        public string LastName { get; set; }
        [DataMember]
        public string Name { get; set; }
        [DataMember]
        public string MiddleName { get; set; }
        [DataMember]
        public DateTime Birthday { get; set; }
        [DataMember]
        public bool IsOnline { get; set; }

        [DataMember]
        public int UserSexID { get; set; }
        [DataMember]
        public virtual UserSex UserSex { get; set; }

        [DataMember]
        public int UserTypeID { get; set; }
        [DataMember]
        public virtual UserType UserType { get; set; }

        [DataMember]
        public int UserStatusID { get; set; }
        [DataMember]
        public virtual UserStatus UserStatus { get; set; }

        public User() { }
        public override string ToString() => $"{LastName} {Name[0]}.{MiddleName[0]}.";
    }
}

{SELECT TOP (2) 
    [top].[UserID] AS [UserID], 
    [top].[Login] AS [Login], 
    [top].[Passowrd] AS [Passowrd], 
    [top].[LastName] AS [LastName], 
    [top].[Name] AS [Name], 
    [top].[MiddleName] AS [MiddleName], 
    [top].[Birthday] AS [Birthday], 
    [top].[IsOnline] AS [IsOnline], 
    [top].[UserSexID] AS [UserSexID], 
    [top].[UserTypeID] AS [UserTypeID], 
    [top].[UserStatusID] AS [UserStatusID], 
    [top].[UserTypeID1] AS [UserTypeID1], 
    [top].[UserTypeName] AS [UserTypeName], 
    [top].[UserStatusID1] AS [UserStatusID1], 
    [top].[UserStatusName] AS [UserStatusName], 
    [top].[UserSexID1] AS [UserSexID1], 
    [top].[UserSexName] AS [UserSexName], 
    [top].[UserSexShortName] AS [UserSexShortName]
    FROM ( SELECT [Project1].[UserID] AS [UserID], [Project1].[Login] AS [Login], [Project1].[Passowrd] AS [Passowrd], [Project1].[LastName] AS [LastName], 

[Project1].[Name] AS [Name], [Project1].[MiddleName] AS [MiddleName], [Project1].[Birthday] AS [Birthday], [Project1].[IsOnline] AS [IsOnline], [Project1].[UserSexID] 

AS [UserSexID], [Project1].[UserTypeID] AS [UserTypeID], [Project1].[UserStatusID] AS [UserStatusID], [Project1].[UserTypeID1] AS [UserTypeID1], [Project1].

[UserTypeName] AS [UserTypeName], [Project1].[UserStatusID1] AS [UserStatusID1], [Project1].[UserStatusName] AS [UserStatusName], [Project1].[UserSexID1] AS 

[UserSexID1], [Project1].[UserSexName] AS [UserSexName], [Project1].[UserSexShortName] AS [UserSexShortName]
        FROM ( SELECT 
            [Extent1].[UserID] AS [UserID], 
            [Extent1].[Login] AS [Login], 
            [Extent1].[Passowrd] AS [Passowrd], 
            [Extent1].[LastName] AS [LastName], 
            [Extent1].[Name] AS [Name], 
            [Extent1].[MiddleName] AS [MiddleName], 
            [Extent1].[Birthday] AS [Birthday], 
            [Extent1].[IsOnline] AS [IsOnline], 
            [Extent1].[UserSexID] AS [UserSexID], 
            [Extent1].[UserTypeID] AS [UserTypeID], 
            [Extent1].[UserStatusID] AS [UserStatusID], 
            [Extent2].[UserTypeID] AS [UserTypeID1], 
            [Extent2].[UserTypeName] AS [UserTypeName], 
            [Extent3].[UserStatusID] AS [UserStatusID1], 
            [Extent3].[UserStatusName] AS [UserStatusName], 
            [Extent4].[UserSexID] AS [UserSexID1], 
            [Extent4].[UserSexName] AS [UserSexName], 
            [Extent4].[UserSexShortName] AS [UserSexShortName]
            FROM    [Users] AS [Extent1]
            INNER JOIN [UserTypes] AS [Extent2] ON [Extent1].[UserTypeID] = [Extent2].[UserTypeID]
            INNER JOIN [UserStatus] AS [Extent3] ON [Extent1].[UserStatusID] = [Extent3].[UserStatusID]
            INNER JOIN [UserSexes] AS [Extent4] ON [Extent1].[UserSexID] = [Extent4].[UserSexID]
            WHERE ([Extent1].[UserStatusID] = @p__linq__0) AND ([Extent1].[UserTypeID] = @p__linq__1) AND ([Extent1].[UserSexID] = @p__linq__2) AND (([Extent1].

[LastName] LIKE @p__linq__3 ESCAPE N'~') OR ([Extent1].[Name] LIKE @p__linq__4 ESCAPE N'~') OR ([Extent1].[MiddleName] LIKE @p__linq__5 ESCAPE N'~'))
        )  AS [Project1]
        ORDER BY [Project1].[UserID] ASC
        OFFSET 2 ROWS 
    )  AS [top]}