How Manage Big Linq DataContext ?
- by Rev
Hi
The major problem in .net programs is "How manage memory for best performance".
so Microsoft use garbage collector in .net and with that, we don't need to do something for managing memory(or better say we can use GC easily)
But when you develop big project(business app), you make too many tables and database for your own project. so if you use Linq-to-sql, we must build DataContext include hundred or more tables. That make problem for program when you create an object from datacontext, that object give big amount of memory. also we cant divide datacontext to datacontexts(cuz relation between tables)
so "How manage datacontext and memory"?