Click here to Skip to main content
15,887,135 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# loop help Pin
Hrons23-Jan-14 2:34
Hrons23-Jan-14 2:34 
AnswerRe: C# loop help Pin
OriginalGriff23-Jan-14 3:01
mveOriginalGriff23-Jan-14 3:01 
QuestionC# Grid Plugin Pin
krikkidoddle23-Jan-14 0:30
krikkidoddle23-Jan-14 0:30 
AnswerRe: C# Grid Plugin Pin
Ron Beyer23-Jan-14 2:56
professionalRon Beyer23-Jan-14 2:56 
QuestionSet Location of ListView below DataGridView Active Row in C# Winform Pin
ahmed_one22-Jan-14 19:49
ahmed_one22-Jan-14 19:49 
AnswerRe: Set Location of ListView below DataGridView Active Row in C# Winform Pin
Mycroft Holmes22-Jan-14 21:33
professionalMycroft Holmes22-Jan-14 21:33 
GeneralRe: Set Location of ListView below DataGridView Active Row in C# Winform Pin
ahmed_one22-Jan-14 22:07
ahmed_one22-Jan-14 22:07 
GeneralRe: Set Location of ListView below DataGridView Active Row in C# Winform Pin
Mycroft Holmes22-Jan-14 22:23
professionalMycroft Holmes22-Jan-14 22:23 
GeneralRe: Set Location of ListView below DataGridView Active Row in C# Winform Pin
ahmed_one22-Jan-14 22:31
ahmed_one22-Jan-14 22:31 
QuestionAlgorithms which Max(x) Min(y) Pin
Swab.Jat22-Jan-14 17:18
Swab.Jat22-Jan-14 17:18 
QuestionDynamic created radio buttons wont execute event on click (c# .net ) Pin
salar136922-Jan-14 14:34
salar136922-Jan-14 14:34 
AnswerRe: Dynamic created radio buttons wont execute event on click (c# .net ) Pin
Kornfeld Eliyahu Peter22-Jan-14 20:13
professionalKornfeld Eliyahu Peter22-Jan-14 20:13 
GeneralRe: Dynamic created radio buttons wont execute event on click (c# .net ) Pin
salar136923-Jan-14 8:30
salar136923-Jan-14 8:30 
GeneralRe: Dynamic created radio buttons wont execute event on click (c# .net ) Pin
Kornfeld Eliyahu Peter23-Jan-14 8:34
professionalKornfeld Eliyahu Peter23-Jan-14 8:34 
GeneralRe: Dynamic created radio buttons wont execute event on click (c# .net ) Pin
Gopi Kishan Mariyala22-Jan-14 22:24
Gopi Kishan Mariyala22-Jan-14 22:24 
GeneralRe: Dynamic created radio buttons wont execute event on click (c# .net ) Pin
salar136923-Jan-14 6:53
salar136923-Jan-14 6:53 
QuestionPainfully Slow Operation Pin
eddieangel22-Jan-14 11:07
eddieangel22-Jan-14 11:07 
I am trying to root out why this particular linq query is so expensive from a time standpoint, assuming it is the linq query that is causing it.

C#
public static List<DocumentType> GetDocs()
        {
            List<DocumentType> output;
            using (context = contextLogic())
            {
                output = (from d in context.DocumentTypes
                          select d).AsEnumerable().Select (x => new DocumentType
                          {
                              Id = x.iD,
                              Name = x.Name,
                              FlagA = x.FlagA,
                              IsActive = x.IsActive,
                              UpdateDate = x.UpdateDate,
                              CategoryName = x.DocumentCategory.Name,
                              Associations = string.Join(",", x.DocumentAssociations.Select(g => g.ADocID.ToString()))
                          }).ToList();
            }
            return output;
        }


I tried flipping things around quite a bit. This was initially an observablecollection but it is a list right now as I try to tune it in different ways. Right now it is taking about 12 seconds to retrieve data from a table of 350 records. If I take out the CategoryName and the associations it times down to about six seconds, but that is still ridiculously slow.
AnswerRe: Painfully Slow Operation Pin
Matt T Heffron22-Jan-14 14:19
professionalMatt T Heffron22-Jan-14 14:19 
GeneralRe: Painfully Slow Operation Pin
eddieangel23-Jan-14 5:51
eddieangel23-Jan-14 5:51 
GeneralRe: Painfully Slow Operation Pin
Dave Kreskowiak23-Jan-14 7:48
mveDave Kreskowiak23-Jan-14 7:48 
GeneralRe: Painfully Slow Operation Pin
eddieangel23-Jan-14 7:59
eddieangel23-Jan-14 7:59 
QuestionRead XML values (attributes and elements) with C# Pin
SJR_122-Jan-14 5:14
SJR_122-Jan-14 5:14 
AnswerRe: Read XML values (attributes and elements) with C# Pin
Christian Wulff22-Jan-14 23:38
Christian Wulff22-Jan-14 23:38 
GeneralRe: Read XML values (attributes and elements) with C# Pin
SJR_123-Jan-14 4:59
SJR_123-Jan-14 4:59 
GeneralRe: Read XML values (attributes and elements) with C# Pin
Christian Wulff23-Jan-14 5:06
Christian Wulff23-Jan-14 5:06 

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.