private DBHandler()
{
this.connection = new SQLiteConnection();
string datasource = ConfigurationManager.AppSettings["DataSource"].ToString();
SQLiteConnectionStringBuilder connstr = new SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
this.connection.ConnectionString = connstr.ToString();
this.connection.Open();
this.dataContext = new StudentDataContext(this.connection);
}
public void TestInsert()
{
Student stu1 = new Student() { Name = "stu''1", Identity = "2202014986146513541", Contact = "1212", StartTime = DateTime.Parse("2012-1-1"), EndTime = DateTime.Parse("2012-2-1") };
Student stu2 = new Student() { Name = "stu2", Identity = "2202014981212113541", Contact = "1212", StartTime = DateTime.Parse("2012-1-1") };
StudentCollection _allStudents = new StudentCollection();
StudentDataContext dc = new StudentDataContext(this.connection);
dc.StudentTable.InsertOnSubmit(stu2);
dc.SubmitChanges();
}