PercolatorAnalysisServices 0.3.2

dotnet add package PercolatorAnalysisServices --version 0.3.2
NuGet\Install-Package PercolatorAnalysisServices -Version 0.3.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="PercolatorAnalysisServices" Version="0.3.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add PercolatorAnalysisServices --version 0.3.2
#r "nuget: PercolatorAnalysisServices, 0.3.2"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install PercolatorAnalysisServices as a Cake Addin
#addin nuget:?package=PercolatorAnalysisServices&version=0.3.2

// Install PercolatorAnalysisServices as a Cake Tool
#tool nuget:?package=PercolatorAnalysisServices&version=0.3.2

A LINQ to MDX Psued-O-RM for Microsoft SQL Server Analysis Services

Product Compatible and additional computed target framework versions.
.NET Framework net is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.3.2 4,276 4/9/2015

Finally, a way to query a Microsoft SQL Server Analysis Database with LINQ and type safe objects!


Beta version - Comes without any warranties.  Please contact me via the "Contact Owners" link for any questions, comments, bugs, or features you think should be included. Any input is GREATLY appreciated. Make sure to read the "Documentation" text file that is included with the package.

A big thanks goes out to Miguel Correia and Nuno Braz Oliveira for helping me find a lot of these bugs and lack of features, and really putting this project through the ringer!

Some of these features were implemented due to them requesting more functionality. So if you wish to see something, or have a bug, TELL US! We do listen, I promise.

* Working on finishing a Microsoft Sql Server LINQ enabled ORM with the speed of a micro orm with added functionality and features.  Stay tuned for more on that.

   * Optimizing the mapper for faster mapping (specially for large datasets).
   * Adding Mdx methods
   * Tidying things up for full release and open source.

   -VERSION 3.1
   * Version 3.1 has addressed:
       -Fixed an issue with mapping to certain data types.

       -A few small optimizations to the translators and the PAS objects.

       -Stripped out the IQueryable implementations and creating PAS specific implementations for the standard LINQ free form syntax.  This means that anonymous queries will no longer be supported (that doesn't mean I've abandoned the concept entirely, just re thinking its application).  The old IQueryable implementation introduced confusion into what translation methods should be called, so I stripped it out and now both the Free Form syntax and PAS Explicit syntax flow through the same translations.

       -The generated cube objects are now using the singleton pattern instead of newing up an entire new cube with all new attributes (since no data gets mapped to those objects anyways).

       -Added arithmetic operator overloads (+, -, *, /) so members can be created from other members operations (i.e. Member.Create<Sales>(cube => cube.WholesaleDollars / cube.TransactionCount)).

   -Although not listed as a dependency, some of the classes used in this library belong to the Microsoft.AnalysisServices.AdomdClient dll.  The project itself doesn't require the user to have this in the project to run, but some query methods allow the user to return a "CellSet" or "AdomdDataReader", which do belong to the AdomdClient dll.

   -A preliminary product page has been setup on our site containing the documentation of this project.  If you would like to see it before downloading it, click the "Product Site" link to the left. Also, visit us at

   -This product is still being developed, but soon we may be pulling it out of beta and releasing it as a full release.  Once we do that, it will more than likely be open sourced.  Until then, if you require the source code to work it into your project, that may be arranged. Contact us and we will get back to you on it.

   -Thank you to everyone who has provided feedback! This project has been under continual development because you guys have been asking for more! Again, PLEASE contact us for any bug issues, questions, or features you would like to see.