public static ArrayList getTautomerRules(SqlConnection connection, string bingo_schema) { ArrayList result = new ArrayList(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = String.Format(@"select id, begg, endd from {0}.TAUTOMER_RULES", bingo_schema); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 3600; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { TautomerRule rule = new TautomerRule(); rule.n = Convert.ToInt32(reader[0]); rule.beg = Convert.ToString(reader[1]); rule.end = Convert.ToString(reader[2]); result.Add(rule); } } return(result); }
public static ArrayList getTautomerRules (SqlConnection connection, string bingo_schema) { ArrayList result = new ArrayList(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = String.Format(@"select id, begg, endd from {0}.TAUTOMER_RULES", bingo_schema); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 3600; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { TautomerRule rule = new TautomerRule(); rule.n = Convert.ToInt32(reader[0]); rule.beg = Convert.ToString(reader[1]); rule.end = Convert.ToString(reader[2]); result.Add(rule); } } return result; }