changing a table to array

Question

I have a temp table which I fill and clear it in a loop in my code.
becouse of using database, it takes musch time. I want to change it to an array to run my app quicker.
here is my table columns:

ID ( int) , Type (string ), Amount (int)

reson : I have a loop which is repeated 700 times! I have some tables tu have store my data. now I finished my project and I just need one of those tables & the others are useless. I want to optimize my code to run it quicker.
THANKS.

Answer 1

If you are on .NET 4.0, you can use a generic list of a generic Tuple class:

var myList = new List<Tuple<int,string,int>>();