public void TestDelete()
{
using (var db = new SampleDataContext())
{
DateTime startTime = DateTime.Now;
var personQuery = (from pers in db.Persons select pers).ToList();
db.Persons.RemoveRange(personQuery);
db.SaveChanges();
TimeSpan elapsedTime = DateTime.Now - startTime;
Console.WriteLine("DELETE:" + elapsedTime.ToString());
}
}
public EFPerformanceTests()
{
// clean up any data from previous runs
using (var db = new SampleDataContext())
{
// delete any records from previous run
var deptQuery = (from dept in db.Departments select dept).ToList();
db.Departments.RemoveRange(deptQuery);
db.SaveChanges();
var personQuery = (from pers in db.Persons select pers).ToList();
db.Persons.RemoveRange(personQuery);
db.SaveChanges();
// insert one department
Department myDepartment = new Department()
{
name = "Operations"
};
db.Departments.Add(myDepartment);
db.SaveChanges();
}
}
public void TestInsert()
{
using (var db = new SampleDataContext())
{
// read first and last names
List<string> firstnames = new List<string>();
using (StreamReader sr = new StreamReader(@"..\..\Data\firstnames.txt"))
{
string line;
while ((line = sr.ReadLine()) != null)
firstnames.Add(line);
}
List<string> lastnames = new List<string>();
using (StreamReader sr = new StreamReader(@"..\..\Data\lastnames.txt"))
{
string line;
while ((line = sr.ReadLine()) != null)
lastnames.Add(line);
}
db.Configuration.AutoDetectChangesEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
//test inserting 1000 records
DateTime startTime = DateTime.Now;
for (int j = 0; j < 10; j++)
{
for (int i = 0; i < 1000; i++)
{
Person personRecord = new Person()
{
first = firstnames[i],
last = lastnames[i],
department = 1
};
db.Persons.Add(personRecord);
}
}
db.SaveChanges();
TimeSpan elapsedTime = DateTime.Now - startTime;
Console.WriteLine("INSERT:" + elapsedTime.ToString());
}
}
public void TestUpdate()
{
using (var db = new SampleDataContext())
{
DateTime startTime = DateTime.Now;
var query = (from p in db.Persons select p).ToList();
foreach (var item in query)
{
item.last = item.last + "2";
}
db.SaveChanges();
TimeSpan elapsedTime = DateTime.Now - startTime;
Console.WriteLine("SELECT:" + elapsedTime.ToString());
}
}
public void TestSelect()
{
using (var db = new SampleDataContext())
{
DateTime startTime = DateTime.Now;
for (int i = 0; i < 1000; i++)
{
var query = (from p in db.Persons
join d in db.Departments on p.department equals d.id
select p).ToList();
}
TimeSpan elapsedTime = DateTime.Now - startTime;
Console.WriteLine("INSERT:" + elapsedTime.ToString());
}
}