public List <T> ExecuteReader <T>(string query, Dictionary <string, object> parameters, DataReaderHandler <T> dataReaderHandler) where T : ITableRow { List <T> result; using (SqlConnection connection = new SqlConnection(ConnectionString)) { using (SqlCommand command = new SqlCommand(query, connection)) { foreach (var nameValue in parameters) { command.Parameters.Add(new SqlParameter(nameValue.Key, nameValue.Value)); } connection.Open(); Reader = command.ExecuteReader(); result = dataReaderHandler(); connection.Close(); } } return(result); }
public List <TraitDragonConfiguration> GetPerfectChampionList(string set) { List <TraitDragonConfiguration> config = DataReaderHandler <List <TraitDragonConfiguration> > .ReadSetConfig(set, "traits"); return(config); }