Casting Errors on getting datetime value from db using Linq in MVC

Question

Problem Statement:

I'm trying to get the datetime value from the table using some where conditions but it is giving exception as : LINQ to Entities does not recognize the method 'System.Object get_Item(System.String)' method, and this method cannot be translated into a store expression.

Linq Query what i'm trying :

Datetime PDate=(from p in db.PMaster
                      where p.ID == ID
                      && p.PNumber == Num
                      select p.PDate).SingleOrDefault();

I'm trying to get Datetime column(PDate) value from the the db using linq and assigning it to variable.

What i'm doing wrong??

You're sure this is all the code that's causing the problem? I can't see any indexing here, which is odd... what's the compile-time type of db.PMaster? — Jon Skeet
– Jon Skeet, Commented Aug 22, 2014 at 8:46
@Tim.Tang-Thanks making db.PMaster as db.PMaster.AsEnumerable() solved my problem. — Vishal
– Vishal, Commented Aug 22, 2014 at 8:50

Vishal · Accepted Answer · 2014-08-22 10:41:11Z

2

Solution:

Based on @Tim.Tang comment, following code snippet solved my problem

Datetime PDate=(from p in db.PMaster.AsEnumerable()
                      where p.ID == ID
                      && p.PNumber == Num
                      select p.PDate).SingleOrDefault();

answered Aug 22, 2014 at 10:41

Vishal

2,0174 gold badges25 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Casting Errors on getting datetime value from db using Linq in MVC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related