Using Entity Framework with an SSAS Cube

entity-framework ssas
CodeMonkey1313 picture CodeMonkey1313 · Feb 10, 2010 · Viewed 7.9k times · Source

Is it possible to use Entity Framework (any version, including, and preferably 4.0) to query an SSAS cube (preferably SSAS 2008)?

Answer

Grand picture Grand · Aug 28, 2011

Yes, now it is possible to use EF 4.0-4.1 to query SQL Server Analysis Services 2008 OLAP cubes (it is something like LINQ to MDX / SSAS). You will need to install SSAS Entity Framework Provider (tm) to enable that. You can checkout and request SSAS Entity Framework Provider here:

http://www.agiledesignllc.com/Products.htm

Disclosure: I work for Agile Design LLC - the company who offers this product.

Related questions

Validation failed for one or more entities. See 'EntityValidationErrors' property for more details

I am having this error when seeding my database with code first approach. Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. To be honest I don't know how to check the content of the validation …

Read More
MSSQL Error 'The underlying provider failed on Open'

I was using an .mdf for connecting to a database and entityClient. Now I want to change the connection string so that there will be no .mdf file. Is the following connectionString correct? <connectionStrings> <!--<add …

Read More
How to update record using Entity Framework 6?

I am trying to update record using EF6. First finding the record, if exists, update it. Here is my code:- var book = new Model.Book { BookNumber = _book.BookNumber, BookName = _book.BookName, BookTitle = _book.BookTitle, }; using (var db = new MyContextDB()) { …

Read More