Click here to Skip to main content
15,902,114 members
Home / Discussions / C#
   

C#

 
GeneralRe: remove duplicates from list collection Pin
RobCroll15-Feb-11 5:04
RobCroll15-Feb-11 5:04 
AnswerRe: remove duplicates from list collection [modified] Pin
wesch15-Feb-11 4:08
wesch15-Feb-11 4:08 
AnswerRe: remove duplicates from list collection Pin
Pete O'Hanlon15-Feb-11 5:27
mvePete O'Hanlon15-Feb-11 5:27 
QuestionHow can you track the mouse pointer if you leave the form...... Pin
glennPattonWork314-Feb-11 23:25
professionalglennPattonWork314-Feb-11 23:25 
AnswerRe: How can you track the mouse pointer if you leave the form...... Pin
reza assar14-Feb-11 23:53
reza assar14-Feb-11 23:53 
GeneralRe: How can you track the mouse pointer if you leave the form...... Pin
glennPattonWork315-Feb-11 1:29
professionalglennPattonWork315-Feb-11 1:29 
AnswerRe: How can you track the mouse pointer if you leave the form...... Pin
Pravin Patil, Mumbai15-Feb-11 0:27
Pravin Patil, Mumbai15-Feb-11 0:27 
GeneralRe: How can you track the mouse pointer if you leave the form...... Pin
glennPattonWork315-Feb-11 1:30
professionalglennPattonWork315-Feb-11 1:30 
AnswerRe: How can you track the mouse pointer if you leave the form...... Pin
Luc Pattyn15-Feb-11 2:20
sitebuilderLuc Pattyn15-Feb-11 2:20 
QuestionHow to access port80 Pin
Krishna Varadharajan14-Feb-11 19:53
Krishna Varadharajan14-Feb-11 19:53 
AnswerRe: How to access port80 Pin
Bernhard Hiller14-Feb-11 22:07
Bernhard Hiller14-Feb-11 22:07 
AnswerRe: How to access port80 Pin
Luc Pattyn15-Feb-11 2:21
sitebuilderLuc Pattyn15-Feb-11 2:21 
GeneralRe: How to access port80 Pin
Bernhard Hiller16-Feb-11 21:42
Bernhard Hiller16-Feb-11 21:42 
QuestionGmail Port 465 Send Mail Error Pin
Anubhava Dimri14-Feb-11 19:49
Anubhava Dimri14-Feb-11 19:49 
AnswerRe: Gmail Port 465 Send Mail Error Pin
Dave Kreskowiak15-Feb-11 1:56
mveDave Kreskowiak15-Feb-11 1:56 
GeneralRe: Gmail Port 465 Send Mail Error Pin
Anubhava Dimri16-Feb-11 1:09
Anubhava Dimri16-Feb-11 1:09 
GeneralRe: Gmail Port 465 Send Mail Error Pin
Dave Kreskowiak16-Feb-11 1:12
mveDave Kreskowiak16-Feb-11 1:12 
GeneralRe: Gmail Port 465 Send Mail Error Pin
Anubhava Dimri16-Feb-11 1:17
Anubhava Dimri16-Feb-11 1:17 
GeneralRe: Gmail Port 465 Send Mail Error Pin
Dave Kreskowiak16-Feb-11 2:26
mveDave Kreskowiak16-Feb-11 2:26 
QuestionDataGridViewTextBoxEditingControl autocomplete conflict with wrapmode [modified] Pin
reza assar14-Feb-11 19:37
reza assar14-Feb-11 19:37 
Questionqueries with coding Pin
Rei ho14-Feb-11 18:43
Rei ho14-Feb-11 18:43 
QuestionRedirect after xsl file is downloaded Pin
S.Aijaz14-Feb-11 18:12
S.Aijaz14-Feb-11 18:12 
QuestionWhat is the better approach between IQueryable and IEnumerable ? Pin
Nadia Monalisa14-Feb-11 15:13
Nadia Monalisa14-Feb-11 15:13 
AnswerRe: What is the better approach between IQueryable and IEnumerable ? Pin
PIEBALDconsult14-Feb-11 17:16
mvePIEBALDconsult14-Feb-11 17:16 
GeneralRe: What is the better approach between IQueryable and IEnumerable ? Pin
Nadia Monalisa14-Feb-11 17:59
Nadia Monalisa14-Feb-11 17:59 
Hi,
Thanks a lot for your reply.

Actually, I am re-factoring my Web Application for better maintainability and memory performance. I host my web application in a shared hosting where I am allowed to use a very limited amount of RAM.

In my Web Application, I used LINQ to SQL where my Code Behind files are directly calling the DataContext class generated by LINQ to SQL Classes. I want to encapsulate the call of DataContext in a Business Logic Layer. I am very much tempted to return IEnumerable Objects from my Business Logic Layer to the Presentation Layer instead of IQueryable objects as I know, IQueryable object means, differed SQL query execution. Moreover, when using IQueryable object, I cannot use most of the LINQ features that are available for LINQ to Object. Because, LINQ to SQL does not have similar translation for many C# methods.

Now, My question, Is it more memory efficient to work with IQueryable object instead of IEnumerable object ? So far I can guess, using IQueryable means, my RAM will be free from loading the whole database table. But If I convert the IQueryable to IEnumerable by calling ToList() or ToArray(), then, the whole object will be loaded into the RAM and reduce performance. Is my guess right ? Would you please give me a better direction for this scenario ?

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.