public DataModificationResult DeletePerson(Person person)
{
try
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
db.Person.Attach(person);
db.Person.Remove(person);
db.SaveChanges();
return new DataModificationResult() { Result = DataModificationResult.Results.Ok };
}
}
catch (DbUpdateConcurrencyException ex)
{
return new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
};
}
catch (Exception ex)
{
return new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
};
}
}
public DataModificationResult UpdatePerson(Person person)
{
try
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
db.Person.Attach(person);
db.Entry(person).State = EntityState.Modified;
db.SaveChanges();
return(new DataModificationResult()
{
Result = DataModificationResult.Results.Ok
});
}
}
catch (DbUpdateConcurrencyException ex)
{
return(new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
});
}
catch (Exception ex)
{
return(new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
});
}
}
public void BulkInsert10000Records()
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
List<Person> data = new List<Person>();
Random rnd = new Random();
Guid guid;
for(int i = 0; i<=10000;i++)
{
guid = Guid.NewGuid();
data.Add(new Person { FirstName = guid.ToString().Substring(0, 8), LastName = guid.ToString().Substring(9, 8), BirthDate = DateTime.Now.AddDays(-rnd.Next(1, 10000)) });
}
db.BulkInsert<Person>(data);
db.SaveChanges();
}
}
public void BulkInsert10000Records()
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
List <Person> data = new List <Person>();
Random rnd = new Random();
Guid guid;
for (int i = 0; i <= 10000; i++)
{
guid = Guid.NewGuid();
data.Add(new Person {
FirstName = guid.ToString().Substring(0, 8), LastName = guid.ToString().Substring(9, 8), BirthDate = DateTime.Now.AddDays(-rnd.Next(1, 10000))
});
}
db.BulkInsert <Person>(data);
db.SaveChanges();
}
}
