Entity Framework Exception

Question

Hi all I have a code like this inside entityframework (I want to change many items at the same time I dont know whether we can use a loop like this but it throws an exception like this:

LINQ to Entities does not recognize the method 'Int32 get_Item(Int32)' method, and this method cannot be translated into a store expression.

Code:

        try
        {
            for (int j = 0; j < ids.Count; j++)
            {
                using (OzgorenEntities2 context = new OzgorenEntities2())
                {
                        Stock st = context.Stocks.First(i => i.id == ids[j]);
                        st.stockAmount =  amounts[j];
                        context.SaveChanges();
                }
            }
            return true;
        }
        catch (Exception ex)
        {
            return false;
        }

to be honest I searched and only find that converting is not working in server side but I dont convert it there what might be solution for me ?

Thanks

LINQ to Entities is getting tripped up by your using ids[j] as a value in your query. It's totally obvious to you and me that you just want to use a value within the array, but as far as the query provider is concerned, you're trying to access the indexer property called get_Item on the array, and it doesn't know how to generate SQL code for that. — Jeremy Todd
– Jeremy Todd, Commented May 8, 2013 at 15:41

chris vietor · Accepted Answer · 2013-05-08 15:37:37Z

5

try to introduce a variable for the ids value at the given index

            using (OzgorenEntities2 context = new OzgorenEntities2())
            {
                    var id = ids[j];
                    Stock st = context.Stocks.First(i => i.id == id);
                    st.stockAmount =  amounts[j];
                    context.SaveChanges();
            }

answered May 8, 2013 at 15:37

chris vietor

2,0701 gold badge20 silver badges30 bronze badges

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

Comments

Kirill Bestemyanov · Accepted Answer · 2013-05-08 15:38:48Z

2

You should add intermediate variable to storage value ids[j]:

    try
    {
        for (int j = 0; j < ids.Count; j++)
        {
            var tempId = ids[j];
            using (OzgorenEntities2 context = new OzgorenEntities2())
            {
                    Stock st = context.Stocks.First(i => i.id == tempId);
                    st.stockAmount =  amounts[j];
                    context.SaveChanges();
            }
        }
        return true;
    }
    catch (Exception ex)
    {
        return false;
    }

It is due to nature of IQueriable expressions. LINQ to Entities don't know how to transfer expression i => i.id == ids[j] to SQL statement.

answered May 8, 2013 at 15:38

Kirill Bestemyanov

12k2 gold badges26 silver badges38 bronze badges

Collectives™ on Stack Overflow

Entity Framework Exception

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related