@alexboly

Not sure if this helps, but my tricks for left joins are:

- Use #linqpad to generate queries for me.
- Swap them around
- Use aliases
- Use temporary tables
- Move things to #NoSql #database (a project can have relational and documents)
- Use views or stored procedures to split complex queries

Other than that: Good luck!

I've FINALLY found a use case for #dotnet #regions! When hardcoding credentials in a temp #linqpad script, but needing to show someone over a video call - wrapping the creds in a region makes it easy to collapse/hide...

@GrahamDowns @cavorter @falkheiland

Especially as a dot net DEV you could profit so much from powershell! In all of my bigger projects I've built C# powershells module to reach behind the UI directly in the domain code.

Currently I'm working on a software which is communicating to machines over CAN. For automating stuff around my daily work i'm using powershell cmdlets. I'm just piping domain objects through my cmdlets.....
For explorative tinkering #linqpad is still king :-)

Just watched @danclarke showing #LinqPad and I'm glad to see people discovering this great productivity tool. I'm using and supporting it from version 1.0 and use it daily.

@danclarke mentioned in one of his blog posts about #LinqPad, that you would need symbolic links in you "scripts" folder and showed how to do that on the command line. I can highly recommend a neat little tool #LinkShellExtension (https://schinagl.priv.at/nt/hardlinkshellext/hardlinkshellext.html) to get that functionality in your right mouse menu on windows explorer

Have just published my next YouTube video, which is a short 5-minute intro into the new beta #linqpad AI functionality! (and apparently, that's what Midjourney thinks a robot version of me looks like! 🤯) https://youtu.be/2fplJvWRIhA #dotnet

Have just published my next YouTube video, which is a short 5-minute intro into the new beta #linqpad AI functionality! (and apparently, that's what Midjourney thinks a robot version of me looks like! 🤯) https://youtu.be/2fplJvWRIhA #dotnet

@khalidabuhakmeh yeah, I saw you linking to that. Looks interesting. I think I remember Joe Albahari mentioning that #WPF the main hurdle from porting #LinqPad another platform. #FingersCrossed

@jonstodle well, @avaloniaui just announced XPF, so there might be hope that #linqpad could port to macOS and Linux.

@khalidabuhakmeh that’s called #LinqPad 😛

My next YouTube video is now out - which is an intro to the awesome #linqpad! 🔥❤ https://youtu.be/zspjPQkOMEE #dotnet

I just completed "Monkey in the Middle" - Day 11 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/11 in #csharp and #linqpad.

This one was pretty tricky. Part 1 was mostly parsing, but part 2 definitely required some creative thinking. Felt like I got pretty lucky that my solution actually worked!

code: http://share.linqpad.net/ch4sau.linq

I just completed "Cathode-Ray Tube" - Day 10 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/10 in #csharp and #linqpad

After the trauma of day 9, I was pleased and grateful with how quick I got through this one!

code: http://share.linqpad.net/ttcxh2.linq

I just completed "Rope Bridge" - Day 9 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/9 in #csharp and #linqpad.

OH MY GOD that was a slog. Probably took me 3 hours. I hit a wall where my answer was rejected and I couldn't figure out why, so I spent a loong time writing a visualizer, having to deal with translating array indices to cartesian coordinates. Finally had to result to reddit where someone had the same issue I did, and that unblocked me. At least I got this cool viz:

I've completed "Treetop Tree House" - Day 8 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/8 in #csharp and using #linqpad

I'm *really* not proud of this one. It was a slog, and I ended up basically brute-force coding it. You can see my attempt to refactor the various loops into one method but I gave up on it. Curious to see how others did this more efficiently!

code: http://share.linqpad.net/pd6kqh.linq

I just completed "No Space Left On Device" - Day 7 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/7 in #csharp in #linqpad.

This one was a bear! Took me a good hour and a half due to some silly unforced errors...

code: http://share.linqpad.net/mjvnuw.linq

What would you have done differently?

I just completed "Tuning Trouble" - Day 6 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/6 in #csharp using #linqpad

For part 1, I decided to use a regex. I didn't necessarily think it'd be the simplest but I'd been wanting to learn how to use backreferences so this seemed like a good opportunity.

In part 2 that really bit me. I had to get a little creative to keep my regex solution :) Shout out to https://regex101.com/ for helping with my regex!

code: http://share.linqpad.net/is3v9b.linq

I just completed "Supply Stacks" - Day 5 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/5, in #csharp and #linqpad

code: http://share.linqpad.net/gr6iws.linq

I'm not very proud of my solution for part 2, but I didn't feel like switching my data structures from stacks to something else. Who had a better method?

I just completed "Camp Cleanup" - Day 4 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/4, in #csharp and #linqpad

code: http://share.linqpad.net/j7b4n3.linq

I just completed "Tuning Trouble" - Day 6 - Advent of Code 2022 #AdventOfCode #CSharp #DotNet #LinqPad https://adventofcode.com/2022/day/6

I just found out about this #AdventOfCode thing. In 2022… I guess the rock I’ve been living under failed to inform me… ¯\_(ツ)_/¯

Anyway, I’m all caught up now and it’s been pretty fun! I am using #LinqPad with #CSharp #DotNet 7.