实体框架和SQL Analysis Service [英] Entity framework and SQL Analysis Service

问题描述

我目前正在研究使用ASP.Net MVC和实体框架从SQL Server Analysis Services访问多维数据集数据的可行性。有没有人做过类似的事情？使用Entity访问SSAS多维数据集数据是否有任何特殊障碍？任何有启发性的书籍，博客或参考文献都将受到赞赏。

提前感谢！

I'm currently looking at the feasibility of using ASP.Net MVC and the Entity Framework to access cube data from SQL Server Analysis Services. Has anyone done something similar to this? Are there any special hurdles in using Entity to access SSAS cube data? Any enlightening books, blogs or references would be appreciated.

Thanks in advance!

推荐答案

没有目前市场上的Microsoft SQL Server Analysis Services（SSAS）的ADO.NET实体框架数据提供程序，因此我们不得不创建一个。

请在此处查看SSAS实体框架提供商（tm）：

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

There were no ADO.NET Entity Framework data providers for Microsoft SQL Server Analysis Services (SSAS) on the market so far, so we had to create one.

Please, have a look into SSAS Entity Framework Provider (tm) here:
http://www.agiledesignllc.com/Products.htm

SSAS实体框架提供程序为您提供LINQ over MDX / SSAS OLAP多维数据集。它使用LINQ方言，它比原始LINQ本身更短更简单。

SSAS Entity Framework Provider gives you LINQ over MDX / SSAS OLAP cubes. It uses a LINQ dialect which is much shorter and simpler than an original LINQ itself.

在这里您可以看到它的用法示例：

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

Here you can see its usage example:
http://www.agiledesignllc.com/LINQX_vs_LINQ_vs_MDX.htm

（我在Agile Design LLC工作）。

(I work for Agile Design LLC).

这篇关于实体框架和SQL Analysis Service的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！