getting InvalidOperationException while querying with AsQueryable in C#

Question

I have an entity class as City.

 [BsonRepresentation(MongoDB.Bson.BsonType.ObjectId)]
        public string _id { get;  set; }
        public string city { get; set; }
        public Array loc { get; set; }
        public double pop { get; set; }
        public string state { get; set; }

and I want to create a simple query with AsQueryable() class. Here is my query code

string dbName = dao.dbName();
var db = mongo.GetDatabase(dbName);

using (mongo.RequestStart(db))
{
       var collection = db.GetCollection<City>("city");
       var query = collection.AsQueryable().First(c => c.city.Equals("VIENNA"));

       Console.WriteLine( query.ToString());
}

When I run the code I get an System.InvalidOperationException like this

An unhandled exception of type 'System.InvalidOperationException' occurred in System.Core.dll

at

var query = collection.AsQueryable().First(c => c.city.Equals("VIENNA"));

line. Can anyone explain that why I'm getting this exception and lead to solution?

it says "sequence contains no elements". but i debugged that db connection have done successfully and there is a collection which is "city". — trallallalloo
– trallallalloo, Commented May 8, 2015 at 7:17
@vedat That means that collection does not have an element being equal to "VIENNA". Use FirstOrDefault instead. — molnarm
– molnarm, Commented May 8, 2015 at 7:25
@MártonMolnár thanks for answer. I thought that first documents' city field is "VIENNA" but I understand that functionality of First function is different. So I'm querying with _id. — trallallalloo
– trallallalloo, Commented May 8, 2015 at 7:38

molnarm · Accepted Answer · 2015-05-08 07:42:30Z

2

The First method looks for the first result that matches the expression passed as argument. When it doesn't find any, it will throw this exception. If you are not sure that the sequence contains the element you are looking for, use FirstOrDefault. See this article for a nice summary.

answered May 8, 2015 at 7:42

molnarm

10.1k2 gold badges46 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

getting InvalidOperationException while querying with AsQueryable in C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related