private void LoadHandednessPairs()
{
var idToHandedness = new Dictionary<int, string>();
var handednessToId = new Dictionary<string, int>();
using (var cmd = new SqlCmdExt(_connectionString))
{
cmd.CreateCmd(@"
SELECT
Id, Hand
FROM
Handedness
");
cmd.ExecuteSelect();
while (cmd.Read())
{
var id = cmd.GetInt("Id");
var hand = cmd.GetString("Hand");
idToHandedness.Add(id, hand);
handednessToId.Add(hand, id);
}
}
_idToHandedness = idToHandedness;
_handednessToId = handednessToId;
}
private SqlCmdExt Select(string command)
{
var cmd = new SqlCmdExt(_connectionString);
cmd.CreateCmd(command);
cmd.ExecuteSelect();
return cmd;
}
/* *******************************************************
*
*/
private void LoadPositionPairs()
{
var idToPosition = new Dictionary<int, string>();
var positionToId = new Dictionary<string, int>();
using (var cmd = new SqlCmdExt(_connectionString))
{
cmd.CreateCmd(@"
SELECT
Id, Position
FROM
Position
");
cmd.ExecuteSelect();
while (cmd.Read())
{
var id = cmd.GetInt("Id");
var position = cmd.GetString("Position");
idToPosition.Add(id, position);
positionToId.Add(position, id);
}
}
_idToPosition = idToPosition;
_positionToId = positionToId;
}