コード例 #1
0
        private List <string> ExecuteCommand(SQLiteCommand command)
        {
            command.CommandText =
                "SELECT t1.file_path FROM server_file_list t1 " +
                "WHERE NOT EXISTS ( " +
                "SELECT * FROM local_file_list t2 " +
                "WHERE t1.file_path = t2.file_path) ";

            using (var reader = command.ExecuteReader())
            {
                return(SqlReaderUtils.ReadStringList(reader));
            }
        }
コード例 #2
0
        private List <string> ExecuteCommand(SQLiteCommand command)
        {
            command.CommandText =
                "SELECT t1.file_path FROM file_list t1 " +
                "INNER JOIN local_file_list t2 " +
                "ON t1.file_path = t2.file_path " +
                "AND datetime(t1.file_updated_at) <> datetime(t2.file_updated_at) ";

            using (var reader = command.ExecuteReader())
            {
                return(SqlReaderUtils.ReadStringList(reader));
            }
        }