What type should i use for "database-like" behaviour in C#?

Question

i'm currently working on an experimental setup, that is used to write complex microstructures into glass with a femtosecond laser.

The output power of the laser is regulated by a filterwheel which i control from my (C# console)application. As I initially do not know the position of the wheel, I need to initalize it on startup, by measuring the power for a predefined number of points on the wheel.

This information (power values and their corresponding position on the wheel) should be stored during runtime. So basically if a certain output power is requested, the controller will look up the two points in between which the desired value can be found and then increments the position until it is reached.

This is something i would usually achieve using a database. As the initialization takes place on every startup and it does not need to be persisted, i would probably prefer to just keep it as an in-memory list.

So my question is:

Is it possible to somehow "index" the power values to retrieve them quickly?

not many, 200 max as otherwise the init process will take too long anyways... — user871784, Jul 31 '13 at 15:37

score 3 · Answer 1 · answered Jul 31 '13 at 15:31

3

A Dictionary<int, int> would probably be your best bet. Of course, you could switch out the key/value types to match your data if it isn't ints.

answered Jul 31 '13 at 15:31

Justin Niessner

242,243
40
408
536

score 2 · Accepted Answer · edited May 23 '17 at 12:28

2

You may look at using a SortedDictionary<int, int> if you're going to have to calculate "in-between" values for keys.

Look at the similar question here for an example on finding points between two keys using a SortedDictionary

edited May 23 '17 at 12:28

Community

1
1

answered Jul 31 '13 at 15:35

Will Eddins

13,628
5
51
85

score 1 · Answer 3 · answered Jul 31 '13 at 20:01

1

Some time ago I wrote a small post on the different list types in dotnet with pros and cons.
http://www.selfelected.com/list-of-list-and-collection-classes-in-dotnet-11-45/

answered Jul 31 '13 at 20:01

LosManos

7,195
6
56
107

score 0 · Answer 4 · answered Jul 31 '13 at 15:35

0

if you want to map each key to a value you should use Dictionary<key,value>

answered Jul 31 '13 at 15:35

Ehsan

31,833
6
56
65

What type should i use for "database-like" behaviour in C#?

4 Answers4