Better Way to Search for a Value in a List of KeyValuePairs???
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
HashTable
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
In essence you are mirroring a Dictionary here. Why not just use that instead?
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
NickPace wrote:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Not sure if it is a typo but you don't select anything in the line below
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
It should be something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)).Select(kvp=>kvp).FirstOrDefault();
Than you could check if it exits simply by comparing someValue.Value with string.Empty. If not found the FirstOrDefault() method will initialize it with the default values witch is string.Empty for strings. But there are more speedier approaches to this such as Dictionary, HashTable...
All the best, Dan
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
You can always use LINQ. If you want to search by the
GUID(key) make your search criteriaGUID.IEnumerable result = someList.Where(y=>y.Key.Contains(searchGUID));You can always search on the value as below.IEnumerable result = someList.Where(y=>y.Value.Contains(searchString));In both cases,resultwill contain the final search result. Note that performance may or may not be better than using a loop. LINQ makes it easier to write code, performance is generally better (but not always).Too much of heaven can bring you underground Heaven can always turn around Too much of heaven, our life is all hell bound Heaven, the kill that makes no sound
-
NickPace wrote:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Not sure if it is a typo but you don't select anything in the line below
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
It should be something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)).Select(kvp=>kvp).FirstOrDefault();
Than you could check if it exits simply by comparing someValue.Value with string.Empty. If not found the FirstOrDefault() method will initialize it with the default values witch is string.Empty for strings. But there are more speedier approaches to this such as Dictionary, HashTable...
All the best, Dan
That works good, except I had to compare to null instead of a string because it returns a KeyValuePair object. But you got me on the right track. I guess I need to buy a good book on LINQ as I still struggle with it. And I agree that a Dictionary or HashTable would be better, but I'm stuck with the List that is passed to my method. Thanks again for your reply. It was very helpful.
-NP Never underestimate the creativity of the end-user.
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
If you want a replacement for
Contains(), you don't need to useWhere()...Any()means "If any member of the list satisfies this condition" (Opposite would be!All())bool onList = someList.Any(kvp => kvp.Value.Equals(someStringValue));
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels) -
That works good, except I had to compare to null instead of a string because it returns a KeyValuePair object. But you got me on the right track. I guess I need to buy a good book on LINQ as I still struggle with it. And I agree that a Dictionary or HashTable would be better, but I'm stuck with the List that is passed to my method. Thanks again for your reply. It was very helpful.
-NP Never underestimate the creativity of the end-user.
-
I am not sure I understand entirely. Why is it that you are stuck with the List?
djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.
Short version: The company I work for, in their infinite wisdom, decided to outsource some of our code. The 'List' comes from the Data Access Layer that they coded and is used primarily as a datasource for comboboxes. And even though I have access to their code, I am not allowed to touch it...something about licensing, intellectual property, and the infinite wisdom of my company and some other political BS which I just don't care about anymore. I could ask them to code a Dictionary or HashTable for me, but I don't feel like it. So I basically do my best to work around the crap that is sent to me (which probably sounds familiar to most coders out there). The long version includes several pages of expletives. Use your imagination...
-NP Never underestimate the creativity of the end-user.
-
Short version: The company I work for, in their infinite wisdom, decided to outsource some of our code. The 'List' comes from the Data Access Layer that they coded and is used primarily as a datasource for comboboxes. And even though I have access to their code, I am not allowed to touch it...something about licensing, intellectual property, and the infinite wisdom of my company and some other political BS which I just don't care about anymore. I could ask them to code a Dictionary or HashTable for me, but I don't feel like it. So I basically do my best to work around the crap that is sent to me (which probably sounds familiar to most coders out there). The long version includes several pages of expletives. Use your imagination...
-NP Never underestimate the creativity of the end-user.
Haha, that sheds a whole new light on the situation. I though at first that you simply were not sure how to go about using a Dictionary, in which case I could have been of help. My apologies. Good luck with those non-coding, outsourced geniuses. ;P
djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
If you have to do that frequently, you should probably reengineer the whole thing. Another way would be to define a specific class to hold the data and implement the Equals method.
-
HashTable
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
Ennis, Please see my comment on this thread. thanks, Bill
"Is it a fact - or have I dreamt it - that, by means of electricity, the world of matter has become a great nerve, vibrating thousands of miles in a breathless point of time? Rather, the round globe is a vast head, a brain, instinct with intelligence!" - Nathanial Hawthorne, House of the Seven Gables
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
Try this:
var result = someList.FindAll(delegate(KeyValuePair q) {return q.Value.Equals(someStringValue);});
You can use
Findfor single values also.Its the man, not the machine - Chuck Yeager If at first you don't succeed... get a better publicist If the final destination is death, then we should enjoy every second of the journey.
-
I have a list of KeyValuePairs:
List<KeyValuePair<Guid, string>> someList;
(And it is populated with several hundred KeyValuePairs of Guids and strings.) I want to determine if this list of KeyValuePairs contains a certain string value as part of its values. One way to do this is to loop through each KeyValuePair as follows:
bool onList = false;
foreach (KeyValuePair<Guid, string> kvp in someList)
{
if (kvp.Value.Equals(someStringValue))
{
onList = true;
break;
}
}if (onList)
{
// Do something...
}However, this seems like a clunky way to perform this check. It seems to me that there must be a way to use the ‘Contains’ method of the List object or Linq to perform this check, but I can’t seem to get the semantics right. Perhaps something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Any suggestions?
-NP Never underestimate the creativity of the end-user.
This is the kind of question and discussion I'd so enjoy seeing more of on this forum, thanks, Nick. It would be fascinating to know how the different techniques suggested here, including Ennis' suggestion of using a HashTable, compare in terms of speed and efficiency. This discussion on StackOverFlow may be relevant (?): [^] In this case we don't know whether every string in each KeyValuePair is unique or not, and that could influence the gamut of solutions ? Here's my suggestion, but I'm no Linq master:
List<KeyValuePair<Guid, string>> kvpList = new List<KeyValuePair<Guid, string>>();
private IEnumerable<string> sList;
private void testKVPToList()
{
for (int i = 1000; i < 2000; i++)
{
Guid guid = new Guid("F4168C51-CEB2-4EBC-B6BF-319B339D" + i.ToString());
kvpList.Add(new KeyValuePair<Guid, string>(guid,(i*5).ToString()));
}sList = from kvp in kvpList select kvp.Value; if(sList.Contains("5000")) Console.WriteLine("5000 found"); if(sList.Contains("9995")) Console.WriteLine("9995 found");}
Whether 'tis better to take a 'one-time' hit and build a List, or to dynamically look-up on-the-fly: that's a good question ! And, if the goal is to build the fastest List to search ? My casual attempt to make a SortedList from a KeyValuePair List resulted in a pig that could not fly, but I'm sure there's a way :) I'd certainly go and examine Mehdi Gholam's recent 'Hoot' full-text search be-all-and-end-all project[^], and see what he's doing there, because I'll bet it's as optimized as possible. You can find some implementations of the Boyer-Moore algorithm here on CP:[^].
"Is it a fact - or have I dreamt it - that, by means of electricity, the world of matter has become a great nerve, vibrating thousands of miles in a breathless point of time? Rather, the round globe is a vast head, a brain, instinct with intelligence!" - Nathanial Hawthorne, House of the Seven Gables
modified on Thursday, September 8, 2011 2:45 AM
-
This is the kind of question and discussion I'd so enjoy seeing more of on this forum, thanks, Nick. It would be fascinating to know how the different techniques suggested here, including Ennis' suggestion of using a HashTable, compare in terms of speed and efficiency. This discussion on StackOverFlow may be relevant (?): [^] In this case we don't know whether every string in each KeyValuePair is unique or not, and that could influence the gamut of solutions ? Here's my suggestion, but I'm no Linq master:
List<KeyValuePair<Guid, string>> kvpList = new List<KeyValuePair<Guid, string>>();
private IEnumerable<string> sList;
private void testKVPToList()
{
for (int i = 1000; i < 2000; i++)
{
Guid guid = new Guid("F4168C51-CEB2-4EBC-B6BF-319B339D" + i.ToString());
kvpList.Add(new KeyValuePair<Guid, string>(guid,(i*5).ToString()));
}sList = from kvp in kvpList select kvp.Value; if(sList.Contains("5000")) Console.WriteLine("5000 found"); if(sList.Contains("9995")) Console.WriteLine("9995 found");}
Whether 'tis better to take a 'one-time' hit and build a List, or to dynamically look-up on-the-fly: that's a good question ! And, if the goal is to build the fastest List to search ? My casual attempt to make a SortedList from a KeyValuePair List resulted in a pig that could not fly, but I'm sure there's a way :) I'd certainly go and examine Mehdi Gholam's recent 'Hoot' full-text search be-all-and-end-all project[^], and see what he's doing there, because I'll bet it's as optimized as possible. You can find some implementations of the Boyer-Moore algorithm here on CP:[^].
"Is it a fact - or have I dreamt it - that, by means of electricity, the world of matter has become a great nerve, vibrating thousands of miles in a breathless point of time? Rather, the round globe is a vast head, a brain, instinct with intelligence!" - Nathanial Hawthorne, House of the Seven Gables
modified on Thursday, September 8, 2011 2:45 AM
Thanks! That's good information you provided. Overall I am pleasantly surprised and pleased with the responses to my initial questions. Everyone provided some good ideas and I even learned a couple new things concerning LINQ. This issue started out as a minor client-requested enhancement to one of their existing applications (hopefully just a one-time deal), and when I looked at the code in question I discovered the data I needed to compare against already existed in a List of KeyValuePairs, so really no need to query the database again. And thus my little quest began. When I saw the first response from Pete O'Hanlon, I thought: "Of course. I'll just cast the List to an equivalent Dictionary object and use its 'ContainsValue' method." Which I thought was going to work because it compiled just fine, but then threw an 'Invalid Cast' exception during runtime (same thing for a HashTable). :sigh: And so the quest continued... I eventually went with the answer provided by MDL=>Moshu. It works great. The List has about 2000 KeyValuePairs in it and the new search appears instantaneous to the end users. So though the code design may not be ideal, it works, it's stable, it performs well, and the client is happy. And that is what it is really all about.
-NP Never underestimate the creativity of the end-user.
-
NickPace wrote:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
Not sure if it is a typo but you don't select anything in the line below
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)); // which doesn’t work
It should be something like:
var someValue = someList.Where(kvp => kvp.Value.Equals(someStringValue)).Select(kvp=>kvp).FirstOrDefault();
Than you could check if it exits simply by comparing someValue.Value with string.Empty. If not found the FirstOrDefault() method will initialize it with the default values witch is string.Empty for strings. But there are more speedier approaches to this such as Dictionary, HashTable...
All the best, Dan
Ok, might be a stupid question here, but ... Why doesn't the first line work? The someList.Where returns IEnumerable right? So, shouldn't someValue just be enumerable? I'm not sure what Select is doing there either. It transforms a kvp to a kvp, so doesn't that mean the entire Select is just removable?