public static void CleanDatabase() { //make database newish //reset passwords var userProfileTableAdapter = new SSS_Library.IS2G10_DBSSSDataSetTableAdapters.USERPROFILETableAdapter(); var userProfiles = userProfileTableAdapter.GetData(); foreach (var userProfile in userProfiles) { userProfile.resetPassword = true; userProfileTableAdapter.Update(userProfile); } var brandingTableAdapter = new SSS_Library.IS2G10_DBSSSDataSetTableAdapters.BRANDINGTableAdapter(); var branding = brandingTableAdapter.GetData(); branding[0].is_system_clean = true; //kill all attendance and stuff like that. }