Cast Exception in C# Where clause

Question

It's been a while since I am trying to figure out what is causing a cast exception in this case. Following is my code.

var ratingTermDetails = dtRating.AsEnumerable()
    .Where(data => data.Field<int>("RATINGID") == ratingId)
    .FirstOrDefault();

dtRating is a datatable which gets populated from the database (oracle). The datatype of the column Ratingid is Integer in the database and the column is not nullable. The variable ratingId is an integer too.

Answer 1

As @MarcGravell said, the variable was getting converted into System.Decimal in C#. Upon changing to my code worked.

Answer 2

I don't know how much help this is because I've never seen similar Linq before. But in my understanding, you're saying that RATINGID is int in the DB and it's a primary key?

Then this should work.

var ratingTermDetails = dtRating
    .Where(data => data.Field.RATINGID == ratingId)
    .FirstOrDefault();