Handling 'Sequence has no elements' Exception

c# .net linq entity-framework ado.net
Arrow picture Arrow · Aug 3, 2012 · Viewed 99.7k times · Source

I am updating a quantity in my cart, but it is throwing a Sequence has no elements' exception.

And I don't know what that even means. At first I thought that maybe there was a null value being passed somewhere, but that isn't the case, as I've checked that:

Sequence contains no elements Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Sequence contains no elements

Source Error:

Line 35: var uid = WebSecurity.CurrentUserId; Line 36: var newqty = Request.Form["Quantity"]; Line 37:
OModel.Cart c = (from item in database.Carts Line 38:
where item.UserId == uid && item.PartNumber == pnumber && item.OrderId == oid Line 39: select item).First();

Any ideas what could be causing this?

Answer

Varius picture Varius · Aug 3, 2012

First() is causing this if your select returns 0 rows. You either have to catch that exception, or use FirstOrDefault() which will return null in case of no elements.

Related questions

Remove item from list based on condition

I have a struct like this: public struct stuff { public int ID; public int quan; } and want to to remove the product where ID is 1. I'm trying this currently: prods.Remove(new stuff{ prodID = 1}); and it's not working. THANKS TO …

Read More
How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?

public static IQueryable<TResult> ApplySortFilter<T, TResult>(this IQueryable<T> query, string columnName) where T : EntityObject { var param = Expression.Parameter(typeof(T), "o"); var body = Expression.PropertyOrField(param,columnName); var sortExpression = Expression.Lambda(body, …

Read More
Linq Query keeps throwing "Unable to create a constant value of type System.Object....", Why?

The following is the code sample: private void loadCustomer(int custIdToQuery) { var dbContext = new SampleDB(); try { var customerContext = from t in dbContext.tblCustomers // keeps throwing: where t.CustID.Equals(custIdToQuery) // Unable to create a constant value of type 'System.Object'. …

Read More