#pragma warning disable CA1000 // Do not declare static members on generic types public static SaveableEntry <T> GetSaveableEntry([NotNull] MyDb db, SaveableEntryTableType saveableEntryTableType, [NotNull] ILogger logger) #pragma warning restore CA1000 // Do not declare static members on generic types { logger.Debug("Using db for " + typeof(T).Name + " logging at " + db.GetConnectionstring() + " with the table " + saveableEntryTableType, db.MyStage, "Profile"); var sa = new SaveableEntry <T>(db, typeof(T).Name + "_" + saveableEntryTableType, logger); var t = new T(); t.SetFieldListToSave(sa.AddField); return(sa); }
public static List <ArchiveEntry> Load([NotNull] MyDb db, [NotNull] ILogger logger) { const string query = "select * from " + nameof(ArchiveEntry); List <ArchiveEntry> entries = new List <ArchiveEntry>(); using (var con = new SQLiteConnection(db.GetConnectionstring())) { var cmd = new SQLiteCommand(con) { CommandText = query }; con.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { var e = ReadSingleLine(reader, logger); entries.Add(e); } reader.Close(); con.Close(); } return(entries); }