public SemesterSales[] GetSalesPrSemester() { using (AdomdConnection conn = new AdomdConnection("DataSource = localhost; Initial Catalog = FClubCube")) { conn.Open(); AdomdCommand cmd = conn.CreateCommand(); cmd.CommandText = @" SELECT [Measures].[Fact Sale Count] ON COLUMNS, NONEMPTY([Dim Member].[Semester].[Semester]*[Dim Product].[Sub Sub Category].[Sub Sub Category]) ON ROWS FROM [F Club DW]"; AdomdDataReader dr = cmd.ExecuteReader(); List <SemesterSales> semesters = new List <SemesterSales>(); while (dr.Read()) { SemesterSales semester = new SemesterSales { semester = dr[0].ToString(), SubSubCategory = dr[1].ToString(), saleCount = int.Parse(dr[2].ToString()) }; semesters.Add(semester); } dr.Close(); SemesterSales[] semesterSales = semesters.FindAll(FindBeer).ToArray(); conn.Close(); return(semesterSales); } }
private static bool FindBeer(SemesterSales ss) { if (ss.SubSubCategory == "Beer") { return(true); } else { return(false); } }