Returning empty IQueryable<>

entity-framework

Question

I have this method that tries to get a list of things:

 private static IQueryable<Thing> GetThings(int thingsType)
        {
                try
                {
                    return from thing in entities.thing.Include("thingStuff")
                           select thing;
                }
                catch (Exception exception)
                {
                    return new EnumerableQuery<Thing>(?????);
                }
            }

        }

I want to return an empty IQueryable if I can't for whatever reason get the query to run. I don't want to return NULL because that could break the calling code. Is it possible or am I going totally wrong about this?

1
21
12/13/2012 8:19:33 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

These answers are good and do work, however I have always felt using Empty and not creating a new List is cleaner:

Enumerable.Empty<Thing>().AsQueryable();
53
8/6/2014 1:12:37 PM

Popular Answer

Try the following:

private static IQueryable<Thing> GetThings(int thingsType)
    {
            IQueryable<Thing> things = new List<Thing>().AsQueryable();
            try
            {
                things = from thing in entities.thing.Include("thingStuff")
                       select thing;

                return things;
            }
            catch (Exception exception)
            {
                return things;
            }
        }
mreyeros

Related Questions

If a LINQ to Entities query produces no results, how do you deliver a default value?

In a LINQ to entities expression like this:...var vote = (from vote in db.Vote where vote.Voter.Id == user.Id select v).FirstOrDefault(); ...How do you add a DefaultIfEmpty value so that when there's no vote I'd get a default value?
defaultifempty entity-framework linq linq-to-entities
asked by pupeno

If the query is empty, the maximum return value

I have this query:...int maxShoeSize = Workers .Where(x => x.CompanyId == 8) .Max(x => x.ShoeSize); ...What will be in ...maxShoeSize... if company 8 has no workers at all?...UPDATE:... How can I change the query in order to get 0 and not an exception?
.net c# entity-framework lambda linq
asked by Naor

IQueryableEntityObject> is converted to IQueryableSpecific>.

We are trying to cast an instance of ...IQueryable<EntityObject>... to an ...IQueryable<SpecificEntityObject>..., the ...SpecificEntityObject... type is only known at runtime....We have tried using the code below, which does not compile because The type or namespace 'objType' does not exist....var t = query.ElementType; Type objType = typeof(IQuery...
c# casting entity-framework iqueryable linq
asked by Stuart.Sklinar

Using EF and WebAPI, how can I return a ViewModel AND support IQueryable/OData?

I've got an ASP.NET WebAPI project. I've recently created EntityFramework entities for all my data tables. But I don't want to expose my data layer & schema to my users. How can I map my entities to a ViewModel (automapper?) ...and... provide IQueryable return type so that my API supports OData?...OData supports query composition and SQL-like param...
asp.net-web-api entity-framework iqueryable odata
asked by Eric Falsken

How to force LINQ Sum() to return 0 while source collection is empty

Basically when I do the following query, if no leads were matched the following query throws an exception. In that case I'd prefer to have the sum equalize 0 rather than an exception being thrown. Would this be possible in the query itself - I mean rather than storing the query and checking ...query.Any()... ?...double earnings = db.Leads.Where(l =...
.net c# entity-framework
asked by John Mayer

Casting errors when attempting to return an IQueryable<MyType>

I have a query that ought to return an ...IQueryable<MyType>.... The code looks like this:...public IQueryable<MyType> GetFooList() { var query = (from x in dbContext.TableX join y in dbContext.TableY on x.our_id equals y.our_id join z in dbContext.TableZ on y.our_id equals z.our_id join a i...
asp.net-mvc c# casting entity-framework linq
asked by Codes with Hammer

Stored Procedure returns incorrect scalar value of -1, instead of return value

I am trying to return a scalar value from a stored procedure. I actually want to return the ID of a newly created record, but I have simplified my problem down to a stored procedure that takes an ...int... and attempts to return that same ...int.... This always returns -1. Thank you very much for your help....Web API Controller call ...var idtest ...
entity-framework entity-framework-6 stored-procedures
asked by mschu

Second Service.AllAsync() returns empty ICollection, when mocking DbSet and ApplicationDbContext on EF6

I'm trying to test the method ...DepartmentSerive.SearchAsync(string name)... using ...Moq.... So far, I've followed this ...msdn tutorial... about how to mock ...DbSet... and ...ApplicationDbContext... classes....First, I copied ...DbAsyncQueryProvider... implementation, so I could use the asynchronous methods....Then I implemented my ...Departme...
asp.net-mvc-5 c# entity-framework-6 mocking unit-testing
asked by ldavid

Return IQueryable from EF proxy object

Imagine I have the following ...DbSet...:...public class X { public int Id { get; set; } public string Name { get; set; } public virtual ICollection<Y> YCollection { get; set; } } ...When I want to retrieve item 1 of ...X... I execute ...DbSet<X>.Find(1);... which returns me an EF proxy object....Now that this proxy object (...X...) con...
c# entity-framework entity-framework-6 linq-to-sql
asked by Corstian Boerman

Entity Framework returning IQueryable of join of two tables

I'd like to use Entity Framework to return data from 2 tables, and a selection of columns of the 2 tables, at first I was not having much luck with something simple, like returning int's and strings (ie. ...select new { id = t1.ID, other = t2.OtherData }..., as casting that anonymous type was cumbersome at the destination (destination being my winf...
c# entity-framework-6 linq
asked by Ninjanoel

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow