Search code examples
sqllinqmdxcubeanalysisservices

Reverse engineer a cube(Analysis Service) enabling data access for .NET applications?


how to reverse engineer an SQL cube(Analysis Service)so that a data access for .NET applications is enabled , just like Entity Framework (ex. dataBase first approach ) but instead of an SQL DB a live Cube(Multidimensional Expressions) that can be queried via LINQ query ?


Solution

  • Use a data provider such as ADOMD which can connect to a cube to read its structure, and run MDX queries to return tables of values.