MongoDB C# Linq driver with nullable types

Question

I am using mongodb c# driver and tried the following query

collection.AsQueryable().Where(x => x.IsArchived.GetValueOrDefault())

where IsArchived is of type bool? (nullable).

I get the following runtime error:

Unsupported where clause: x.IsArchived.GetValueOrDefault().

Does anybody know how I can query nullable types?

Ted Elliott · Accepted Answer · 2013-06-27 16:34:09Z

1

I know we use nullable types in our domain, but can't seem to find any specific instances of quering them. You might try this:

collection.AsQueryable().Where(x => x.IsArchived == true)

or this if that doesn't compile:

collection.AsQueryable().Where(x => x.IsArchived == (bool?) true)

answered Jun 27, 2013 at 16:34

Ted Elliott

3,5481 gold badge31 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mzf · Accepted Answer · 2013-06-13 17:09:21Z

0

Try

collection.AsQueryable().Where(x => x.IsArchived!= null && x.IsArchived)

your expression is translate to mongo query , that is not supprt the C# GetValueOrDefault which give you the exception

answered Jun 13, 2013 at 17:09

Mzf

5,2902 gold badges27 silver badges38 bronze badges

compiler complains "&& x.IsArchived" because this is not valid. using "&& x.IsArchived.Value" causes same runtime error.

Tuan · Accepted Answer · 2013-06-14 11:34:19Z

0

i found out a workaround, though it is not very nice:

collection.AsQueryable().Where(x => x.IsArchived ?? false)

answered Jun 14, 2013 at 11:34

Tuan

9521 gold badge10 silver badges27 bronze badges