public void InitializeData()
{
// clean up any data from previous runs
using (var db = new SampleDataSQLContext())
{
// delete any records from previous run
var personQuery = (from pers in db.Persons select pers).ToList();
db.Persons.RemoveRange(personQuery);
db.SaveChanges();
var deptQuery = (from dept in db.Departments select dept).ToList();
db.Departments.RemoveRange(deptQuery);
db.SaveChanges();
// insert one department
var myDepartment = new Department
{
name = "Operations"
};
db.Departments.Add(myDepartment);
db.SaveChanges();
// select the primary key of the department table for the only record that exists
_departmentKey = (from d in db.Departments where d.name == "Operations" select d.id).FirstOrDefault();
}
}
public double TestDelete()
{
using (var db = new SampleDataSQLContext())
{
var startTime = DateTime.Now;
var personQuery = (from pers in db.Persons select pers).ToList();
db.Persons.RemoveRange(personQuery);
db.SaveChanges();
var elapsedTime = DateTime.Now - startTime;
return elapsedTime.TotalSeconds;
}
}
public double TestUpdate()
{
using (var db = new SampleDataSQLContext())
{
var 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();
var elapsedTime = DateTime.Now - startTime;
return elapsedTime.TotalSeconds;
}
}
public double TestSelect()
{
using (var db = new SampleDataSQLContext())
{
db.Configuration.AutoDetectChangesEnabled = false;
var 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();
}
var elapsedTime = DateTime.Now - startTime;
return elapsedTime.TotalSeconds;
}
}
public double TestInsert()
{
using (var db = new SampleDataSQLContext())
{
// read first and last names
var firstnames = new List<string>();
using (var sr = new StreamReader(@"..\..\Data\firstnames.txt"))
{
string line;
while ((line = sr.ReadLine()) != null)
firstnames.Add(line);
}
var lastnames = new List<string>();
using (var 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 10000 records (only ~1,000 names in text)
var startTime = DateTime.Now;
for (int j = 0; j < 10; j++)
{
for (int i = 0; i < 1000; i++)
{
var personRecord = new Person
{
first = firstnames[i],
last = lastnames[i],
department = _departmentKey
};
db.Persons.Add(personRecord);
}
}
db.SaveChanges();
var elapsedTime = DateTime.Now - startTime;
return elapsedTime.TotalSeconds;
}
}
