LINQ to Entities does not recognize the method and this method cannot be translated into a store expression

Question

var ps = dbContext.SplLedgers.Select(p => new SplLedgerModel
            {
                Name = p.Name,
                VoucherType = Convert.ToString(((JIMS.VoucherTypes)p.VoucherType))
        });

I am getting the following exception, whats wrong with the code.

JIMS.VoucherType is an enum

+       $exception  {"LINQ to Entities does not recognize the method 'System.String ToString(System.Object)' method, and this method cannot be translated into a store expression."}    System.Exception {System.NotSupportedException}

Good link to discussion on this matter: http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/thread/19a33909-c532-419b-a533-57e431c0b30b — dugas, Sep 28 '12 at 14:46

Justin Harvey · Accepted Answer · 2012-09-28T14:53:52.757

9

Your code is basically trying to find the Convert.ToString() method in the DB and understandably failing.

You can get around it, for example by making sure the query executes before the select, e.g.

var ps = dbContext.SplLedgers.Select(p => new  
    { 
         Name = p.Name, 
         VoucherType = p.VoucherType
    }).ToList().Select(p => new SplLedgerModel( 
    { 
         Name = p.Name, 
         VoucherType = Convert.ToString(((JIMS.VoucherTypes)p.VoucherType)) 
    });

edited Sep 28 '12 at 14:53

answered Sep 28 '12 at 14:44

Justin Harvey

14,446
2
27
30

2

Has the disadvantage of retrieving all columns of SplLedgers, rather than just Name and VoucherType (which may or may not be significant). – sgmoore Sep 28 '12 at 14:49
Fair point, so could be refined as above – Justin Harvey Sep 28 '12 at 14:54
But when i tried to bind this data to my datagrid using CollectionViewSource... there are rows but the content is not visible. – Kishore Kumar Sep 29 '12 at 09:03
I think that is nothing to do with the original question, so you should raise another question for this please. – Justin Harvey Oct 01 '12 at 08:00

LINQ to Entities does not recognize the method and this method cannot be translated into a store expression

1 Answers1