Click here to Skip to main content
15,508,376 members
Home / Discussions / C#
   

C#

 
QuestionHow convert SQL Server Pivot functionality in C# uisng LINQ Pin
Mou_kol3-May-21 6:45
Mou_kol3-May-21 6:45 
QuestionRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
Eddy Vluggen3-May-21 7:10
professionalEddy Vluggen3-May-21 7:10 
AnswerRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
Mou_kol3-May-21 7:50
Mou_kol3-May-21 7:50 
GeneralRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
Eddy Vluggen3-May-21 7:57
professionalEddy Vluggen3-May-21 7:57 
GeneralRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
Gerry Schmitz3-May-21 8:49
mveGerry Schmitz3-May-21 8:49 
GeneralRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
Eddy Vluggen3-May-21 12:23
professionalEddy Vluggen3-May-21 12:23 
GeneralRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
Gerry Schmitz3-May-21 22:56
mveGerry Schmitz3-May-21 22:56 
GeneralRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
Pete O'Hanlon4-May-21 0:18
mvaPete O'Hanlon4-May-21 0:18 
This could mean anything. When you say that SQL Server is taking a long time to return the result set, you have left a wide open area here. Does the pivot table take a long time to create on the server? Is it returning a massive amount of data? Has anyone run a profiling session on the pivot operation to see if you are doing sequential scans? Doing an analysis in SQL Server does not need a DBA - the developers should be able to pick this up.

In reality, I doubt you could build a pivot that would work as quickly as the SQL Server implementation which is heavily optimised. In order to pivot, you would have to pull all of the data back from the server then write your own code to transform the data, applying aggregation operations yourself, so you will need to potentially drag back large amounts of data.

My advice - profile the PIVOT operation.

GeneralRe: How convert SQL Server Pivot functionality in C# uisng LINQ Pin
OriginalGriff4-May-21 2:34
mveOriginalGriff4-May-21 2:34 
QuestionBinding Textblock Text and Textbox Text Pin
mnkdrt3-May-21 5:09
mnkdrt3-May-21 5:09 
AnswerRe: Binding Textblock Text and Textbox Text Pin
Gerry Schmitz3-May-21 9:07
mveGerry Schmitz3-May-21 9:07 
QuestionDebug decompile - urgent project restore Pin
Ahmedtsadek2-May-21 20:05
Ahmedtsadek2-May-21 20:05 
AnswerRe: Debug decompile - urgent project restore Pin
OriginalGriff2-May-21 20:32
mveOriginalGriff2-May-21 20:32 
AnswerRe: Debug decompile - urgent project restore Pin
Kuolung19673-May-21 1:48
Kuolung19673-May-21 1:48 
AnswerRe: Debug decompile - urgent project restore Pin
Gerry Schmitz3-May-21 8:42
mveGerry Schmitz3-May-21 8:42 
GeneralRe: Debug decompile - urgent project restore Pin
Richard Andrew x643-May-21 11:32
professionalRichard Andrew x643-May-21 11:32 
GeneralRe: Debug decompile - urgent project restore Pin
Ahmedtsadek3-May-21 13:55
Ahmedtsadek3-May-21 13:55 
GeneralRe: Debug decompile - urgent project restore Pin
Gerry Schmitz3-May-21 22:41
mveGerry Schmitz3-May-21 22:41 
Questionlinq to objects Extract values between start and end strings Pin
Mou_kol1-May-21 4:09
Mou_kol1-May-21 4:09 
AnswerRe: linq to objects Extract values between start and end strings Pin
OriginalGriff1-May-21 5:28
mveOriginalGriff1-May-21 5:28 
AnswerRe: linq to objects Extract values between start and end strings Pin
Richard MacCutchan1-May-21 5:41
mveRichard MacCutchan1-May-21 5:41 
GeneralRe: linq to objects Extract values between start and end strings Pin
Mou_kol1-May-21 7:44
Mou_kol1-May-21 7:44 
GeneralRe: linq to objects Extract values between start and end strings Pin
Richard MacCutchan1-May-21 7:48
mveRichard MacCutchan1-May-21 7:48 
AnswerRe: linq to objects Extract values between start and end strings Pin
Gerry Schmitz1-May-21 8:16
mveGerry Schmitz1-May-21 8:16 
AnswerRe: linq to objects Extract values between start and end strings Pin
Mycroft Holmes1-May-21 12:54
professionalMycroft Holmes1-May-21 12:54 

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.