Linq Tag Cloud

linq_tag_cloud.cs

var categories = from c in data.GraphicCategories
                 join g in data.Graphics on c.GraphicCategory_ID equals g.GraphicCategory_ID
                 group c by c.LongDescription into categoryGroup
                 select new
                 {
                     Category = categoryGroup.Key,
                     CategoryFrequency = categoryGroup.Count()
                 };
 
Int32 maxCategoryFrequency = (from c in categories select c.CategoryFrequency).Max();
 
var categoryCloud = from c in data.GraphicCategories
                    join g in data.Graphics on c.GraphicCategory_ID equals g.GraphicCategory_ID
                    group c by c.LongDescription into categoryGroup
                    select new
                    {
                        Category = categoryGroup.Key,
                        Weight = (Double)categoryGroup.Count() / maxCategoryFrequency * 100
                    };