C
C#•2y ago
Zigo

Linq to select where Name contains substring?

var dynContentList = await _context.DynamicContents
                .OrderBy(x => x.OrderIndex)
                .Any(i => i.Name.Contains(substring))
                .ToListAsync();
var dynContentList = await _context.DynamicContents
                .OrderBy(x => x.OrderIndex)
                .Any(i => i.Name.Contains(substring))
                .ToListAsync();
I want to return all rows where the Name field contains a substring
5 Replies
Saber
Saber•2y ago
ok lets think about this logically, why would you be using Any instead of Where which you explicitly say in the description of what you want
TheBoxyBear
TheBoxyBear•2y ago
^
Zigo
Zigo•2y ago
i'm helpless with Linq
TheBoxyBear
TheBoxyBear•2y ago
Any as the name implies just returns a bool, true if any of the items meet the condition
Zigo
Zigo•2y ago
ah ok thank you wow it worked!
Want results from more Discord servers?
Add your server
More Posts
❔ Linux Mint .NET is installed but cmds such as run, new console, etc. are not recognised...I am thinking of switching to Linux but cannot get .NET SDK and runtime installed correctly for some✅ VerificationExceptionA friend of mine has a method that uses the Reflection.Emit namespace to create a method with the fo❔ ValuesNew to C#, trying to get a value that continuously returns different numbers until it reaches a maxi❔ ✅ JsonSerializer not serializing dictionaryI see this was an issue in .NET 6 and fixed in 7 however, it seems to still not be working in my pro❔ using cookie in cookie container in seleniumI want using cookie in cookie container in selenium how can I do it ?❔ Naming fields meaning numbersI ran into problem where I don't know how to name fields. How would be better to do it?❔ ModelState.IsValiddo I need to call this explicitly myself or does the framework call this when using webAPI? I would✅ data from excel to wpf appI want to make an application to display the data I need in graphs, etc. The only problem is that th❔ One OAUTH2 token, multiple users. Good practices, security.I'm consuming different REST APIs with my credentials to serve my users through my application, but ✅ Missing compiler required member, .NET 4.7.2For some reason I can't use dynamics in .net 4.7.2, I've reinstalled the framework to no avail. Proj