convert IQueryable<int> to <int>

Question

I want to select my price level in database to compare with the an integer number. But It is error : Operator '==' cannot be applied to operands of type 'System.Linq.IQueryable' and 'int'. This is my code :

if (Request.IsAuthenticated){

CustomerModels cm = new CustomerModels();

string userName = Page.User.Identity.Name;
var list_pricelevel = from c in cm.DataContext.Customers
                      where c.WebAccount == userName
                       select c.PriceLevel;
 if (list_pricelevel == 3) {
    Response.Write("Welcome");
 }

 }

Answer 1

var list_pricelevel

This is per definition not an int because more than one row can be returned.

I don't use SQL syntax (only lambda) but at the end you want the equivalent of a .FirstOrDefault or Single or First. Basically taking the first row.

Answer 2

replace:

if (list_pricelevel == 3) 

with:

if (list_pricelevel.First() == 3) 

as you can see here: http://msdn.microsoft.com/en-us/library/bb291976.aspx, if you are sure there is a result or use FirstOrDefault...