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 } }