public void AddTagForFile(String FilePath, params String[] tags) { foreach (String tag in tags) { Tag t = new Tag(); t.FilePath = FilePath; t.TagName = tag; this.Tags.InsertOnSubmit(t); } this.SubmitChanges(); }
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; }