Convert field in linq query c#

Question

I have a query and i want to convert a decimal field to string but the query return the above error

LINQ to Entities does not recognize the method 'System.String ToString () "and it can not be translated into term store.

My query :

    var t = (from f in db.teacher_fee
             where f.fee_status == 1
             select new
             {
                 f.fee_date,
                 f.teacher_fee_id,
                 debit = "",
                 credit = f.total_amount.ToString()
             });

can someone help me thanks

You can find an answer to your question here: http://stackoverflow.com/a/8192329/1694711 — Paul0PT, Oct 28 '16 at 14:48
try `credit = SqlFunctions.StringConvert(f.total_amount)` namespace is System.Data.Objects.SqlClient — JamieD77, Oct 28 '16 at 14:53
@ElHamza - I'm sorry but it is... The `ToString` is used in the `select` on a value from the iterated item - Just like in your case — Gilad Green, Oct 28 '16 at 14:56

score 0 · Answer 1 · answered Oct 28 '16 at 14:51

0

You cannot apply methods like (System.ToString() in your example) on something that is not on the memory.

So basically, the query was never executed. If you look at it, this is still a IQueryable.

You need to bring it with AsEnumerable() or ToList(), before applying the methods into your fields.

answered Oct 28 '16 at 14:51

Anderson Oki

637
1
6
18

thank you I see now – El Hamza Oct 28 '16 at 14:54

Convert field in linq query c#

1 Answers1