using (var ctx = new SchoolDBEntities())

     {

         //Loading students only

         IList<Student> studList = ctx.Students.ToList<Student>();

         Student std = studList[];

         //Loads Student address for particular Student only (seperate SQL query)

         StudentAddress add = std.StudentAddress;

     }
     

SELECT

[Extent1].[StudentID] AS [StudentID],

[Extent1].[StudentName] AS [StudentName],

[Extent1].[StandardId] AS [StandardId]

FROM [dbo].[Student] AS [Extent1]
        

exec sp_executesql N'SELECT

[Extent1].[StudentID] AS [StudentID],

[Extent1].[Address1] AS [Address1],

[Extent1].[Address2] AS [Address2],

[Extent1].[City] AS [City],

[Extent1].[State] AS [State]

FROM [dbo].[StudentAddress] AS [Extent1]

WHERE [Extent1].[StudentID] = @EntityKeyValue1',N'@EntityKeyValue1 int',@EntityKeyValue1=1

using System;

using System.Data.Entity;

using System.Data.Entity.Infrastructure;

using System.Data.Entity.Core.Objects;

using System.Linq;

public partial class SchoolDBEntities : DbContext

{

    public SchoolDBEntities(): base("name=SchoolDBEntities")

    {

        this.Configuration.LazyLoadingEnabled = false;

    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)

    {

        throw new UnintentionalCodeFirstException();

    }

}