Features

  • LINQ to Entities Features

    • Explicit aggregation functions

      • Mdx.Average()
      • Mdx.Max()
      • Mdx.Min()
      • Mdx.Sum()
    • Explicit Order By

      • Ascending
      • Descending
      • By multiple properties and dimensions
    • Set operations

      • Except()
      • Intersect()
      • Union()
      • Concat()
      • Distinct()
    • Pagination

      • Skip()
      • Take()
    • Where

      • MDX Filter() based Where (e.g. Where order.ShipCountry == "Italy")
      • MDX Where axis based Where (e.g. Where order.ShipCountry.Member("Italy"))
      • Combining simple boolean expressions via AND and OR
      • Filter by properties from multiple dimensions
      • DateTime.Now (converted to server side Now())
      • String methods:
      • Contains()
      • StartsWith()
      • IndexOf()
      • ToUpper()
      • ToLower()
  • SDX Dialect of LINQ Unique Features

    • Raw MDX execution and named mapping to entities based on all Entity Framework mapping options

    • Calculated Members

    • Using cube meta data

      • Implicit joins
      • Implicit grouping
      • Implicit aggregations
      • Implicit Order By