[LARP DB] Okay, I want:
select * from
"ItemSheet" is2
join
(select count(id), guid, ma
createdate)
from "ItemSheet" is2
group by guid) as A
on A.guid =is2.guid
Can you do that?
C#: Fuck you!
select * from
"ItemSheet" is2
join
(select count(id), guid, ma
createdate)from "ItemSheet" is2
group by guid) as A
on A.guid =is2.guid
Can you do that?
C#: Fuck you!
Well, yeah, I don't think emojis are natively supported by C# yet.
rofl
squints Wait, a select count and a group by stacked like that usually works?
Yes totally does so long as all of the non-agregate columns are in the group by.
What I'm saying is the base SQL I write in 7 lines without a sweat.
.... Now translate that into C#/Linq.
.... Now translate that into C#/Linq.
Oh no no, I do get what you're saying, but now I'm feeling silly
All good
So, I work primarily in SAS, which uses proc sql statements, which are just different enough from base SQL that I can't always just copy/paste my SQL code between a 'proc sql' and 'quit'
So now I'm like, "wait, can I actually get both of those to play nice in one statement?"
::thumbsup::
This is one of the reasons why I sometimes like ORMs, since I don't have to write that SQL.
kbrighton: and yet this is the exact OPPOSITE problem for me.
I mean, understandable. 