public Task<SearchDimensionItemViewModel> SearchDimensionAsync(Entity entity, string searchTerm) { return Task.Factory .StartNew(() => new SearchDimensionItemViewModel { SearchTerm = searchTerm, Results = entity.Dimensions .Where(x => x.Name.ToUpperInvariant().Contains(searchTerm.ToUpperInvariant())) .ToArray() }); }
public void ProductEntityGroupByProductName() { // new(Key.ProductName as ProductName, // Sum(UnitPrice) as UnitPrice, // Sum(UnitsInStock) as UnitsInStock, // Sum(UnitsOnOrder) as UnitsOnOrder, // Sum(ReorderLevel) as ReorderLevel var entity = new Entity("Products"); var dimension = new Dimension("ProductName"); entity.Dimensions.Add(dimension); entity.Measures.Add(new Measure("UnitPrice")); entity.Measures.Add(new Measure("UnitsInStock")); entity.Measures.Add(new Measure("UnitsOnOrder")); entity.Measures.Add(new Measure("ReorderLevel")); var query = new Query { DataSource = new DataSource {Name = "Northwind"}, Entity = entity, GroupingDimensions = new[] {dimension}, }; var entityFrameworkQueryExecutor = new EntityFrameworkQueryExecutor().Execute(new MyDbContext(), query); }