concept defect in category .net

appears as: defects, defects, defect, defect
C# in Depth

This is an excerpt from Manning's book C# in Depth.

Figure 11.9. Sequences used when grouping defects by assignee. Each entry of the result has a Key property and is also a sequence of defect entries.

Let’s look at a simple example from the SkeetySoft defect system: grouping defects by their current assignee. The following listing does this with the simplest form of projection, so that the resulting sequence has the assignee as the key and a sequence of defects embedded in each entry.

  • The Defect table has two links to the DefectUser table: one for the user who created the defect and one for the current assignee. These are represented with the CreatedByUserId and AssignedToUserId columns, respectively.
  • // Query expression (modified from listing 11.12)
    from defect in context.Defects
    join subscription in context.NotificationSubscriptions
       on defect.Project equals subscription.Project
    select new { defect.Summary, subscription.EmailAddress }
    
    -- Generated SQL
    SELECT [t0].[Summary], [t1].[EmailAddress]
    FROM [dbo].[Defect] AS [t0]
    INNER JOIN [dbo].[NotificationSubscription] AS [t1]
    ON [t0].[ProjectID] = [t1].[ProjectID]