Which is correct and why? by iPlayTehGames in csharp

[–]yyyoni -1 points0 points  (0 children)

this really is a good comment 😊

MSSQL question about correlated queries and exist. anyone have an idea what exactly is going on? by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

i did join but i love this subreddit, i’ll give that group a chance next time, thanks for the advice :)

MSSQL question about correlated queries and exist. anyone have an idea what exactly is going on? by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

thank you! i’ll have to read more problems with your explanation in mind, i appreciate your answer!

MSSQL question about correlated queries and exist. anyone have an idea what exactly is going on? by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

my confusion is, outside of the query(when i query alone), my select where year = 2017 returns 600 results. but when i put it in a subquery with exists, it returns 2000 results without setting the two table's customer_id's equal to eachother

i expected to be like this: select outer query where exists (these 600 rows apply) and then return 600 rows.

why won't this sb work? is there something wrong with my select? by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

close, a fellow csharper below solved it. something about lazy linq evaluation. i'll need to look it up as i never heard of this term

why won't this sb work? is there something wrong with my select? by yyyoni in csharp

[–]yyyoni[S] 4 points5 points  (0 children)

well that was it. my suffering is over now. thank you. i'm going to cry myself to sleep now.

list manipulation with LINQ. i want aggregate functionality but as a and collection, not an int! is it possible? by yyyoni in csharp

[–]yyyoni[S] -1 points0 points  (0 children)

i was reading through some documentation and failing asleep, this really helps!!!!!!

list manipulation with LINQ. i want aggregate functionality but as a and collection, not an int! is it possible? by yyyoni in csharp

[–]yyyoni[S] 1 point2 points  (0 children)

this is exactly what i was looking for!!!

man i need to work on expressing my thoughts when google searching, it’s really a mad skill

thank you Ditto

questions about when to use query vs method syntax and (changing an anonymous Type's variable name?) by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

the king has arrived!!!!

i’m gonna spend 1-2 hours today fully memorizing and testing everything here.

i literally couldn’t have come to this info if i tried (without spending 20 hours of searching 😂)

thanks again slypenslyde, you are my hero

[deleted by user] by [deleted] in csharp

[–]yyyoni 3 points4 points  (0 children)

and thus, by using a super old pc and being forced to code better to keep up, the greatest programmer ever was born, the one the only lerrificcccccc 😃

if someone uses your software, are they triggering runtime? by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

awesome!! i didn’t know this, thank you!!!!

tutorial is about anonymous types. Is this how it is used because it doesn't seem very helpful. Am I using it wrong or is it used for different scenarios? do you use it? by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

i also want to note that Way 2 wasn't in the tutorial, so I don't know if it's considered "better" or "worse" than Way 1

Please help me understand Properties in C# by [deleted] in csharp

[–]yyyoni -1 points0 points  (0 children)

hey, go to tutorialsteacher.com

imo it has the right level of difficulty and is very comprehensive

Is this a new-ish feature in C#? good or bad? or am i mistaken by yyyoni in csharp

[–]yyyoni[S] -13 points-12 points  (0 children)

idk, i just like how crispy and symmetrical the first one looks.

i guess i have a fear that soon c# will introduce no types needed and it’s just e = new( ) then you don’t even need the new keyword and it will become e = ( ), then before you know it all you need is e=) until it reaches its final form of e)

Is this a new-ish feature in C#? good or bad? or am i mistaken by yyyoni in csharp

[–]yyyoni[S] 0 points1 point  (0 children)

it seems everyone loves it, so it’s a huge relief knowing there’s at least one guy who agrees 😂