//Create student in disconnected mode

Student newStudent = new Student() { StudentName = "New Single Student" };

//Assign new standard to student entity

newStudent.Standard = new Standard() { StandardName = "New Standard" };

//add new course with new teacher into student.courses

newStudent.Courses.Add(new Course() { CourseName = "New Course for single student", Teacher = new Teacher() { TeacherName = "New Teacher" } });

using (var context = new SchoolDBEntities())

{

    context.Students.Add(newStudent);

    context.SaveChanges();

    Console.WriteLine("New Student Entity has been added with new StudentId= " + newStudent.StudentID.ToString());

    Console.WriteLine("New Standard Entity has been added with new StandardId= " + newStudent.StandardId.ToString());

    Console.WriteLine("New Course Entity has been added with new CourseId= " + newStudent.Courses.ElementAt().CourseId.ToString());

    Console.WriteLine("New Teacher Entity has been added with new TeacherId= " + newStudent.Courses.ElementAt().TeacherId.ToString());

}

exec sp_executesql N'INSERT [dbo].[Standard]([StandardName], [Description])

VALUES (@0, NULL)

SELECT [StandardId]

FROM [dbo].[Standard]

WHERE @@ROWCOUNT > 0 AND [StandardId] = scope_identity()',N'@0 varchar(50)',@0='New Standard'

go

exec sp_executesql N'INSERT [dbo].[Student]([StudentName], [StandardId])

VALUES (@0, @1)

SELECT [StudentID]

FROM [dbo].[Student]

WHERE @@ROWCOUNT > 0 AND [StudentID] = scope_identity()',N'@0 varchar(50),@1 int',@0='New Single Student',@1=61

go

exec sp_executesql N'INSERT [dbo].[Teacher]([TeacherName], [StandardId])

VALUES (@0, NULL)

SELECT [TeacherId]

FROM [dbo].[Teacher]

WHERE @@ROWCOUNT > 0 AND [TeacherId] = scope_identity()',N'@0 varchar(50)',@0='New Teacher'

go

exec sp_executesql N'INSERT [dbo].[Course]([CourseName], [Location], [TeacherId])

VALUES (@0, NULL, @1)

SELECT [CourseId]

FROM [dbo].[Course]

WHERE @@ROWCOUNT > 0 AND [CourseId] = scope_identity()',N'@0 varchar(50),@1 int',@0='New Course for single student',@1=93

go

exec sp_executesql N'INSERT [dbo].[StudentCourse]([StudentId], [CourseId])

VALUES (@0, @1)

',N'@0 int,@1 int',@0=43,@1=72

go