public void BulkDelete() { using (var context = new EntitiesModel()) { context.OpenAccessDemoEntities.DeleteAll(); } }
public void NormalDelete() { using (var context = new EntitiesModel()) { foreach (var item in context.OpenAccessDemoEntities) { context.Delete(item); } context.SaveChanges(); } }
public MemoryStream SerializeToBinaryStream(string employeeFName)//memory stream { BinaryFormatter formatter = new BinaryFormatter(); MemoryStream stream = new MemoryStream(); using (var dbContext = new EntitiesModel()) { Employee customer = dbContext.Employees.Where(e => e.FirstName == employeeFName).First(); var sentQueryToServer = customer.FirstName; formatter.Serialize(stream, customer); } return stream; }
//HW3 public void Insert100000EntitiesInDB() { using (var context = new EntitiesModel()) { ulong id = 1; int counter = 0; while (counter < 100000) { id += 7; var row = new OpenAccessDemoEntity() { Name = id + "Demo" }; context.Add(row); counter += 1; context.SaveChanges(); } } }