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 296:        MACDataContext db = new MACDataContext();
Line 297:
Line 298:        var result = (from u in db.UrlFriendlyNames
Line 299:                      where u.BandId == bandId
Line 300:                      && u.Master == true

Source File: c:\inetpub\wwwroot\metalmusicarchives.com\App_Code\BLL\ArtistsBLL.cs    Line: 298

Stack Trace:


[InvalidOperationException: Sequence contains no elements]
   System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +3266
   System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +189
   System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +428
   System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +51
   ArtistsBLL.GetArtistUrlFriendlyName(Int32 bandId) in c:\inetpub\wwwroot\metalmusicarchives.com\App_Code\BLL\ArtistsBLL.cs:298
   Video.BuildExpectedUrl() in c:\inetpub\wwwroot\metalmusicarchives.com\Video.aspx.cs:48
   BasePage.Page_PreInit(Object sender, EventArgs e) in c:\inetpub\wwwroot\metalmusicarchives.com\App_Code\BasePage.cs:39
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Page.OnPreInit(EventArgs e) +11692096
   System.Web.UI.Page.PerformPreInit() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +335


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