Solved

The query results cannot be enumerated more than once in LINQ

Posted on 2009-06-28
2
4,128 Views
Last Modified: 2013-12-17
I am getting this error while  implementing the stored procedure in LINQ.. Please see the code attached below...


Error Message : The query results cannot be enumerated more than once in LINQ...

let me know if you  want to see the method( code) ,  where I am Implementing the below mentioned code..

Please resolve it ASAP.


var q = from c in s_Validation_DL.SP_SV_COM_XOSERV_FETCH_CHARGE_ITEM_DETAILS(invoiceNumber)

 

                                where c.INV_NUMBER == invoiceNumber

 

                                select c;

 

                         foreach (var chargeItem in q)

 

                        {

 

                            if (chargeItem.IS_AQGT73200.Value)

 

                            {

 

                              }

Open in new window

0
Comment
Question by:tulasisiva
2 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 50 total points
ID: 24735178
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now