queries in entity framework

Question

i have written the following code

var resumeedit=(from t in db.Resumes where t.User.UserID==theUserID && t.ResumeID==theResumeID select t).Select(t=> new EditResumes
                 {
                     Iswizard=t.isWizard,
                     Resumeid=t.ResumeID.ToString()
                 }).First();
             EditResumes ed = (EditResumes)resumeedit;

and it is giving error LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.

davethecoder · Accepted Answer · 2011-06-09 10:21:13Z

1

this line

Resumeid=t.ResumeID.ToString()

what happens when you make it

Resumeid=t.ResumeID

?

or simple do:

select new { t.ResumeID, t.isWizard }

answered Jun 9, 2011 at 10:21

davethecoder

3,9324 gold badges38 silver badges66 bronze badges

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

1 Comment

Craig Stuntz Over a year ago

With your first suggestion, the code won't compile. With your second, the cast in the second line fails.

Craig Stuntz · Accepted Answer · 2011-06-09 15:35:30Z

0

Like the message says, L2E doesn't do .ToString(). So use .AsEnumerable() to bring it into L2O:

var resumeedit= (from t in db.Resumes 
                 where t.User.UserID==theUserID && t.ResumeID==theResumeID
                 select t)
                .AsEnumerable()
                .Select(t=> new EditResumes
                 {
                     Iswizard=t.isWizard,
                     Resumeid=t.ResumeID.ToString()
                 }).First();

This cast should be unnecessary:

 EditResumes ed = (EditResumes)resumeedit;

answered Jun 9, 2011 at 15:35

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

Collectives™ on Stack Overflow

queries in entity framework

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related