예제 #1
0
#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);
        }
예제 #2
0
        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);
        }