Max return value if empty query

I have this query:

int maxShoeSize = Workers
.Where(x => x.CompanyId == 8)
.Max(x => x.ShoeSize);

What will be in `maxShoeSize` if company 8 has no workers at all?

**UPDATE:**
How can I change the query in order to get 0 and not an exception?

[Max()][1] won't return anything in that case.

It will raise [InvalidOperationException][2] since the source contains no elements.



[1]:

[To see links please register here]

[2]:

[To see links please register here]

Max will throw System.InvalidOperationException "Sequence contains no elements"


class Program
{
static void Main(string[] args)
{
List<MyClass> list = new List<MyClass>();

list.Add(new MyClass() { Value = 2 });

IEnumerable<MyClass> iterator = list.Where(x => x.Value == 3); // empty iterator.

int max = iterator.Max(x => x.Value); // throws System.InvalidOperationException
}
}

class MyClass
{
public int Value;
}

int maxShoeSize=Workers.Where(x=>x.CompanyId==8)
.Max(x=>(int?)x.ShoeSize).GetValueOrDefault();

(assuming that `ShoeSize` is of type `int`)

If `Workers` is a `DbSet` or `ObjectSet` from Entity Framework your initial query would throw an `InvalidOperationException`, but not complaining about an empty sequence but complaining that the materialized value NULL can't be converted into an `int`.

int maxShoeSize = Workers.Where(x => x.CompanyId == 8)
.Select(x => x.ShoeSize)
.DefaultIfEmpty()
.Max();

int maxShoeSize = Workers.Where(x => x.CompanyId == 8)
.Select(x => x.ShoeSize)
.DefaultIfEmpty(0)
.Max();

The zero in `DefaultIfEmpty` is not necessary.