Category Archives: LINQ
LINQuist: Order By “Phrases”
If you know how to order items in a DataTable by a given column, then you are probably looking for something a little more advanced. But really, how much more advanced can we get with this? Why would I want to order it any more than it already is? There are times when the OrderBy…
LINQuist: Order By
Making sweet, sweet progress. Not only are you away of the two syntaxes with which you can construct LINQ, you also know how to filter and project data into whatever shape you want! Now it’s time to up your game by learning how to order data, but first here is something that I have to…
LINQuist: Select the Columns You Want
Working with Data isn’t limited to merely filtering out the items you don’t want or merging it with similar data…which is a topic for another day. You might also have to slice and dice them until they fit the requirement. Clients come with all sorts of fancy requirements these days, so it’s crucial that you…
LINQuist: Select
With Where, we have learnt how to be selective about the data we want. It uses conditions to filter out data before boxing it up with the same paper wrapping it came in. But Where is built to manipulate data, not the schema which houses it. You can’t filter a DataTable and compartmentalize it into…
LINQuist: Where
Now that you are familiar with both Lambda and Query Syntaxes, we will explore the methods one by one – or at least the ones I believe are incredibly useful, starting with Where. Filter With Ease Using Where, you can easily filter collections. If you are trying to filter DataTables, you are better off using…
LINQuist: Query Syntax
If you found Lambda Syntax difficult to work with, then Query just might be what you were looking for. What Makes It So “Special”? Unlike Lambda Syntax, you don’t have to chain coaches of methods one after the other and worry about the anonymous functions not having enough brackets to bottle up its logic in…
LINQuist: Lambda Syntax
LINQ is not easy to wrap your head around. Heck, even I find myself struggling with it from time to time, especially when the problem comes sandwiched with layers upon juicy layers of complexities. It’s a struggle to find any resource out there which describes it in layman terms, other then the technical descriptions which…
Why Learn LINQ?
LINQ is pretty darn useful. Not only does it generate instant results, it also makes you look a lot smarter than you actually are. But what value does it bring to RPA developers, who already have hundreds upon hundreds of click and drag activities to rely on? Also, why learn LINQ, when you can simply…
Believe Me When I Say This LINQ is “Complex”(Part-II)
If last week’s article didn’t send chills down your spine, then you clearly aren’t human. It took me approximately 4 days to wrap my head around that query, before forgetting who I was, where I was, and what I was doing. Bad jokes aside, it did take me a while to understand this, and it…
Believe me When I Say This LINQ Is “Complex”(Part-I)
LINQ is complex enough by itself, which is why I decided to kick it up a notch and torture you with some more. Pain and suffering are the catalyst for success, and I use this platitude each time to gaslight people when they ask me why I like spending hours in front of an illuminated…