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 107:        if (id != null)
Line 108:        {
Line 109:            tblProduct pro = db.tblProducts.Single(m => m.Language == Profile.Culture && m.ProductID == id);
Line 110:            var q = from g in db.tblProducts
Line 111:                    where g.Language == Profile.Culture && g.ProCatID == pro.ProCatID && g.ProductID != id 

Source File: c:\inetpub\vhosts\vaysexy.com\httpdocs\Products\ProductDetail.aspx.cs    Line: 109

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.Table`1.System.Linq.IQueryProvider.Execute(Expression expression) +51
   ProductDetail.DataPager1_PreRender(Object sender, EventArgs e) in c:\inetpub\vhosts\vaysexy.com\httpdocs\Products\ProductDetail.aspx.cs:109
   System.Web.UI.Control.OnPreRender(EventArgs e) +11727916
   System.Web.UI.Control.PreRenderRecursiveInternal() +132
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Control.PreRenderRecursiveInternal() +227
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3671


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