- How to retrieve data from SSAS Cube using EDMX?
- CellSet adomdCellSet;
- using (var adomdConnection = new AdomdConnection())
- {
- adomdConnection.ConnectionString = "YourConnectionString";
- adomdConnection.Open();
- var adomdCommand = adomdConnection.CreateCommand();
- adomdCommand.CommandText = "YourMDXQuery";
- adomdCellSet = adomdCommand.ExecuteCellSet();
- }
- return adomdCellSet;