Server Error in '/' Application.

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 36:                         select new { s.YearbookID, s.Name, s.Year, s.Organization.OrgName, s.Organization.City.City1, s.Organization.City.State1.StateName };
Line 37:             int count = sites.Count();
Line 38:             string featuredHeaderText = "We found " + count + " sites for " + sites.First().OrgName + " with online yearbook photos and pictures.";
Line 39: 
Line 40:             LiteralListTitle.Text = (count > 0) ? featuredHeaderText : "No Yearbooks Found";

Source File: d:\Inetpub\vhosts\yearbook.net\httpdocs\yearbooknetwork\orglist.aspx.cs    Line: 38

Stack Trace:


[InvalidOperationException: Sequence contains no elements]
   System.Linq.Enumerable.First(IEnumerable`1 source) +335
   System.Data.Objects.ELinq.<>c__11`1.<GetElementFunction>b__11_0(IEnumerable`1 sequence) +43
   System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle(IEnumerable`1 query, Expression queryRoot) +61
   System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) +134
   System.Data.Entity.Internal.Linq.DbQueryProvider.Execute(Expression expression) +87
   System.Linq.Queryable.First(IQueryable`1 source) +220
   orglist.DoDataBind() in d:\Inetpub\vhosts\yearbook.net\httpdocs\yearbooknetwork\orglist.aspx.cs:38
   orglist.Page_Load(Object sender, EventArgs e) in d:\Inetpub\vhosts\yearbook.net\httpdocs\yearbooknetwork\orglist.aspx.cs:17
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4690.0