In-memory data structure to store mapping between zip code and states

[Jaheel22]

Which will be best in-memory data structure to store mapping between zip code and states ?

Any technique to find state for a given zip code ?

Thanks in advance.

 

[jbenson001]

Cache a datatable or dataset
then you can do a .Select() on the table to get the rows you want

 

[ca8msm]

Why does it have to be "in-memory"?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[Jaheel22]

It has to be in-memory because of client requires it.

 

[ca8msm]

That's not a requirement, a requirement would be that you would provide them the functionality to "find a state for a given zip code". How you implement this requirement should be the best technical solution so rather than let them dictate how you do it (after all if they do that they may as well do the work) tell them what is the best solution and document why if needs be. Holding this entire dataset in memory, probably isn't the best solution by the way.



____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[chrissie1]

The best would be to dod what ca8msm says, but a dictionary would do what you like.

Christiaan Baes
Belgium

"My new site" - Me