/// <summary> /// 确保数据库已被创建 /// </summary> public void EnsureDbCreated() { using (var context = new TimeDataContext(options)) { context.Database.EnsureCreated(); } }
/// <summary> /// 从数据库中读出所有实体 /// </summary> public void LoadDataFromDb() { using (var context = new TimeDataContext(options)) { UserActivityPieces = context.UserActivityPieces.ToList(); KilledActivities = context.KilledActivities.ToList(); } }
/// <summary> /// 将新增加的实体写入数据库 /// </summary> public void SaveDataToDb() { using (var context = new TimeDataContext(options)) { int savedUAPCount = context.UserActivityPieces.Count(); int savedKACount = context.KilledActivities.Count(); int newUAPCount = UserActivityPieces.Count - savedUAPCount - 1; // 数组中最后一个UAP总是未完成的,未完成的UAP不记录入数据库中 int newKACount = KilledActivities.Count - savedKACount; if (newUAPCount > 0) { context.UserActivityPieces.AddRange(UserActivityPieces.GetRange(savedUAPCount, newUAPCount)); } if (newKACount > 0) { context.KilledActivities.AddRange(KilledActivities.GetRange(savedKACount, newKACount)); } context.SaveChanges(); } }