Linq Query - Delete

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • shapper

    Linq Query - Delete

    Hello,

    I have 3 tables, Tags, ArticlesTags and FilesTags, with the following
    columns:

    Tags TagID, Text

    ArticlesTags TagID, ArticleID

    FilesTags TagID, FileID

    I need to delete all records in Tags which are not in ArticlesTags and
    FilesTags.

    If a Tag is present in one of the 2 tables, ArticlesTags or FilesTags,
    then it will not be deleted.

    How would I do this?

    Thanks,

    Miguel
Working...