static void Main(string[] args)
{
try
{
// 连接数据库引擎
using (DataClasses1DataContext aDataContext = new DataClasses1DataContext(ConnectionString))
{
if (!aDataContext.DatabaseExists())
{
aDataContext.CreateDatabase();
Console.WriteLine("数据库已经创建！");
}
else
{
Console.WriteLine("数据库已经存在！");
}
// 读取数据表内容
var aContacts = from r in aDataContext.lesson select r;
foreach (lesson aContact in aContacts)
{
Console.WriteLine($"{aContact.content} : {aContact.time}");
}
Console.WriteLine("插入新记录……");
lesson aNewContact = new lesson {
content = "需要任何帮助请联系134****6666", time = DateTime.Now.ToString()
};
aDataContext.lesson.InsertOnSubmit(aNewContact);
Console.WriteLine("删除记录……");
lesson aExistContact = (from r in aDataContext.lesson where r.content == "需要任何帮助请联系134****6666" select r).FirstOrDefault();
if (aExistContact != null)
{
aDataContext.lesson.DeleteOnSubmit(aExistContact);
}
Console.WriteLine("提交数据……");
aDataContext.SubmitChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
Console.WriteLine("按回车键退出……");
Console.ReadLine();
}
partial void Deletelesson(lesson instance);
partial void Updatelesson(lesson instance);
partial void Insertlesson(lesson instance);