partial void DeletePerson(Person instance);
partial void InsertPerson(Person instance);
partial void UpdatePerson(Person instance);
public void TestInsert()
{
using (var db = new DataClasses1DataContext())
{
// 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);
}
//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.InsertOnSubmit(personRecord);
}
}
db.SubmitChanges();
TimeSpan elapsedTime = DateTime.Now - startTime;
Console.WriteLine("INSERT:" + elapsedTime.ToString());
//3.49 seconds
}
}
