protected void Page_Load(object sender, EventArgs e) { using (var db = new CodeFirstDbContext()) { var course = new Course { Name = "Algorihms", Description = "gadno", Materials = "za sega njama" }; //var material = "za sega njama"; //course.Materials.Add(material); db.Courses.Add(course); var student = new Student { Name = "Pesho", Number = 10000 }; student.Cources.Add(course); db.Students.Add(student); db.SaveChanges(); } }
private static void DeleteStudentById(int wantedId) { var db = new CodeFirstDbContext(); var itemToRemove = db.Students.SingleOrDefault(x => x.Id == wantedId); // returns a single item. if (itemToRemove != null) { db.Students.Remove(itemToRemove); db.SaveChanges(); } }
public static void Main(string[] args) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<CodeFirstDbContext, Configuration>()); var db = new CodeFirstDbContext(); var newCourse = new Course() { Name = "Databases", Description = @"In this course we are learning about MSSQL, MySQL, MongoDB, ADNO.NET, DatabaseFirst & CodeFirst techniques, ENtityFramework and others." }; //// db.Courses.Add(newCourse); //// DeleteCourseById(); var newStudent = new Student() { FirstName = "John", LastName = "Snow", BirthDate = new DateTime(1980, 04, 20, 11, 59, 59), Gender = Gender.Male, StudentNumber = 123456789 }; //// db.Students.Add(newStudent); //// DeleteStudentById(2); var newHomework = new Homework() { Title = "Code First Entity Framework", Attachments = new byte[1000 * 1000 * 3], AttachmentsName = "codeFirstHomework", AttachmentsExtension = "zip", CourseId = 3, StudentId = 3 }; db.Homeworks.Add(newHomework); db.SaveChanges(); Console.WriteLine(db.Courses.Count()); Console.WriteLine(db.Students.Count()); Console.WriteLine(db.Homeworks.Count()); }