Posted on: 4/7/2015 8:14:28 PM | Views : 595

How to handle this SingleOrDefault when the stored procedure returns one or more records? The collection can retun 0, or 1 to many records how to i handle that...? Codes(C#): var ObjData = new  iDataContext(); works fine var Obj = ObjData.spBooking_SendEmail_SC().SingleOrDefault(); <---get error below... Note the collection has one more more record, how do I collect the records? Error message: "Invalid Operation Exeception was catch --- Sequence contains more than one element" I need to return one or more records, How do I stop the error message and change my codes to loop through the record collections? The collection can retun 0, or 1 to many records

Go to the complete details ...