public static void Delete(Employee employee) { var context = new SoftUniEntities(); context.Entry(employee).State = EntityState.Deleted; context.SaveChanges(); }
public static void Add(Employee employee) { var context = new SoftUniEntities(); var entry = context.Entry(employee); entry.State = EntityState.Added; context.Employees.Add(employee); context.SaveChanges(); }
public static void DataChanges() { var ctx1 = new SoftUniEntities(); var employee1 = ctx1.Employees.Find(1); employee1.FirstName = "Gosho"; var ctx2 = new SoftUniEntities(); var employee2 = ctx2.Employees.Find(1); employee2.FirstName = "Vanka"; ctx1.SaveChanges(); ctx2.SaveChanges(); }
public static void Main() { SoftUniEntities context = new SoftUniEntities(); using (context) { // Town townOne = new Town(); // townOne.Name = "Studentski Grad"; // // context.Towns.Add(townOne); // context.SaveChanges(); Town st = context.Towns.FirstOrDefault(town => town.Name == "Sofia"); context.Addresses.RemoveRange(st.Addresses); context.Towns.Remove(st); context.SaveChanges(); } }
public static void Modify(Employee employee, string newName) { var context = new SoftUniEntities(); string[] name = Regex.Split(newName.Trim(), @"\s+"); string firstName = Regex.Split(newName.Trim(), @"\s+")[0]; employee.FirstName = firstName; if (name.Length == 2) { string lastName = Regex.Split(newName.Trim(), @"\s+")[0]; employee.LastName = lastName; } var entry = context.Entry(employee); entry.State = EntityState.Modified; context.SaveChanges(); }