c# - Best way to use LINQ to fill in gaps in my data -
yesterday posted question below on how use linq transform object several levels using 'group' flat structure: linq groupby on object several levels this kindly answered cédric bignon. reason wanted transformation populate componentart's silverlight xychart component userdata variable. however, i've found out there known bug component when displaying in stacked bar format. if there's gaps in data not display properly, need ensure users have value distinct values of category. in original question, i've put i'd userdata populated with, i'd need ensure [user = "bob", category = "international", spend = 0.00] present in results. i've achieved using following code after linq statement have given me: // linq statement provided @cedric var userdata = spend in allspend userdatapoint in (from monthspend in spend.spend spenddetail in monthspend.detail group spenddetail ...