Exemple #1
0
        public static void ClearDatabase(LINQDatabase db)
        {
            // Pending Mail Table
            var mrows = from row in db.PendingMail
                       select row;
            foreach (var row in mrows)
                db.PendingMail.DeleteOnSubmit(row);
            db.SubmitChanges();

            // Users Table
            var urows = from row in db.Users
                       select row;
            foreach (var row in urows)
                db.Users.DeleteOnSubmit(row);
            db.SubmitChanges();

            // Tags Table
            var trows = from row in db.Tags
                        select row;
            foreach (var row in trows)
                db.Tags.DeleteOnSubmit(row);
            db.SubmitChanges();

            // Files Table
            var frows = from row in db.Files
                        select row;
            foreach (var row in frows)
                db.Files.DeleteOnSubmit(row);
            db.SubmitChanges();

            // TagName Table
            var tnrows = from row in db.Files
                        select row;
            foreach (var row in tnrows)
                db.Files.DeleteOnSubmit(row);
            db.SubmitChanges();
        }
Exemple #2
0
        public static LINQDatabase PopulatedDatabase()
        {
            LINQDatabase db = new LINQDatabase();
            ClearDatabase(db);

            CaesFile music = new CaesFile();
            music.Path = musicFile;
            db.Files.InsertOnSubmit(music);

            CaesFile sound = new CaesFile();
            sound.Path = soundFile;
            db.Files.InsertOnSubmit(sound);

            CaesFile anime = new CaesFile();
            anime.Path = animeFile;
            db.Files.InsertOnSubmit(anime);

            CaesFile video = new CaesFile();
            video.Path = videoFile;
            db.Files.InsertOnSubmit(video);

            db.SubmitChanges();

            // Music File
            Tag m1 = new Tag();
            m1.FilePath = musicFile;
            m1.TagName = "audio";
            db.Tags.InsertOnSubmit(m1);

            Tag m2 = new Tag();
            m2.FilePath = musicFile;
            m2.TagName = "mp3";
            db.Tags.InsertOnSubmit(m2);

            // Sound File
            Tag s1 = new Tag();
            s1.FilePath = soundFile;
            s1.TagName = "audio";
            db.Tags.InsertOnSubmit(s1);

            Tag s2 = new Tag();
            s2.FilePath = soundFile;
            s2.TagName = "wav";
            db.Tags.InsertOnSubmit(s2);

            // Anime File
            Tag a1 = new Tag();
            a1.FilePath = animeFile;
            a1.TagName = "anime";
            db.Tags.InsertOnSubmit(a1);

            Tag a2 = new Tag();
            a2.FilePath = animeFile;
            a2.TagName = "video";
            db.Tags.InsertOnSubmit(a2);

            Tag a3 = new Tag();
            a3.FilePath = animeFile;
            a3.TagName = "mkv";
            db.Tags.InsertOnSubmit(a3);

            // Video File
            Tag v1 = new Tag();
            v1.FilePath = videoFile;
            v1.TagName = "video";
            db.Tags.InsertOnSubmit(v1);

            Tag v2 = new Tag();
            v2.FilePath = videoFile;
            v2.TagName = "avi";
            db.Tags.InsertOnSubmit(v2);

            db.SubmitChanges();

            return db;
        }