LINQ - throw system.OutOfMemoryException issue

Question

In my .net application, I have used LINQ-to-SQL to get some data from the database. The volume of data is not big at all (10 rows of data). But I constantly caught the "system.outofmemoryException" in my function even thought there is still spare memory in the server. Interestingly, I can still get the data with a ADO function from other pages.

The problem will be fixed once application pool restarts. From time to time, issue happen again. Do you have any clue how I should debug this scenario?

Note: I have used "using" block for all datacontext connection. Literally, All datacontext would be disposed after use.

Below is the code. It is simple.

using (StoreDataContext db = new StoreDataContext(conn)) 
{
     var list = from category in db.ProductCategories 
                select category;

     ddlCategory.DataSource = list.Distinct().ToList();
     ddlCategory.DataTextField = "CategoryName";
     ddlCategory.DataValueField = "CategoryName";
     ddlCategory.DataBind();
}

You have memory leaks in your application , you need to test your application through a good memory profiler — Habib
– Habib, Commented Aug 2, 2012 at 8:08
I would suggest you post your Linq code; it seems that either your rows are huge or there's something wrong with the Linq query that's causing it to pull back too much data. — Dan Puzey
– Dan Puzey, Commented Aug 2, 2012 at 8:09
Could you show us your linq query and model of classes you used in this query? it seems that you take circullar navigation properties — Kirill Bestemyanov
– Kirill Bestemyanov, Commented Aug 2, 2012 at 8:16
Why are you using Distinct? It implies that you're not selecting from master table. — Sergei Rogovtcev
– Sergei Rogovtcev, Commented Aug 2, 2012 at 8:51
Do you need all columns?? if not use select new{ID=category.categoryID,Name=category.categoryName} — huMpty duMpty
– huMpty duMpty, Commented Aug 2, 2012 at 8:55

HatSoft · Accepted Answer · 2012-08-02 08:14:14Z

1

My suggestion would you use memory profiling tool such as JetBrains dotTrace or RedGate's Ants Profiler (their are more in the market)

Personal experience even I had the same issue on my web application and dotTrace traced the poorly written code for me

answered Aug 2, 2012 at 8:14

HatSoft

11.3k3 gold badges30 silver badges43 bronze badges

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

2 Comments

seanbun Over a year ago

I used Ants Profiler and did not find any clue. I found the memory was occupied by a System.LocalDataStoreElemnt[] class. Do you know is this linq related?

HatSoft Over a year ago

@seanbun I have always used dotTrace because it gives you hotspot of every function call made based on the percentage it returned for a funtion, so refactor it to see in next run if its returns better number then previous. In your case it could be Linq so I would suggest is try to use a non-linq code and check for the difference in numbers, thats the best I can suggest

Matten · Accepted Answer · 2012-08-02 08:14:36Z

1

Exception thrown when there is not enough memory to continue execution of a program.

In order to view your message, see the OutOfMemoryException constructors.

Reasons :

you have an infinite loop.
You have lot of data, verify your queries sql when you load your context ans entities set.

edited Aug 2, 2012 at 8:14

Matten

17.6k2 gold badges45 silver badges64 bronze badges

answered Aug 2, 2012 at 8:14

Aghilas Yakoub

29k5 gold badges49 silver badges51 bronze badges

Collectives™ on Stack Overflow

LINQ - throw system.OutOfMemoryException issue

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related