concept defect in category .net
appears as: defects, defects, defect, defect

This is an excerpt from Manning's book C# in Depth.
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]