iqueryable

Good Fast Way to Let Users Visualize and Explore Relational Data?

I'm looking for either a web-based or Windows-based way to point to a relational data source using automated schema exploration (or, even better, a reflection-based approach that would work on any IQueryable in-memory data source) and allow easy exploration of data, traversing between records in related tables, etc. Basically a dynamic ...

How to merge two IQueryable lists

I want to merge the records of two IQueryable lists in C#. I try IQueryable<MediaType> list1 = values; IQueryable<MediaType> list2 = values1; obj.Concat(obj1); and IQueryable<MediaType> list1 = values; IQueryable<MediaType> list2 = values1; obj.Union(obj1); but if list1 is empty then the resultant list is also empty. In my case e...

IQueryable Lambda Projection Syntax

I have an IQueryable whose Entity Framework 4 objects I would like to project to their DTO equivalents. One such object 'Person' is an EF4 class, and the corresponding POCO PersonP is a class I've defined. I am using Automapper to map between them. However, when I try the following code: IQueryable<Person> originalModel = _repo.QueryAll...

Creating a queryable property for a linq to sql entity

I have a simple table structure in SQL Server: One table storing a list of Bikes (Bikes) and a second table storing a historical list of the bike's owners (Owners). Using Linq 2 SQL I generated a model that gives me a 'Bike' entity with a 1 to many relationship to 'Owner' called 'HistoricalOwners'. So far so good... Now I have many q...

IQueryable where iterating (this or this or this)

I have a dynamic list of values, which i want to query against an IQueryable with OR conditions. How would I foreach the values to "OR" them up against the IQueryable? ...