public TsIndexField() { TsDbField = new TsDbField(); }
public List<TsDbField> GetTsDbFields(int templateBatchId) { var tsDbFields = new List<TsDbField>(); var strSql = string.Format(@"SELECT FieldID, FieldName, Options FROM Index{0} ORDER BY FieldID", templateBatchId); try { using (var myConn = new SqlConnection(ConnectionString)) { using (var cmd = new SqlCommand(strSql, myConn)) { myConn.Open(); using (var myDataReader = cmd.ExecuteReader()) { if (myDataReader.HasRows) { while (myDataReader.Read()) { var tsDbField = new TsDbField { FieldId = Convert.ToInt32(myDataReader[0]), FieldName = myDataReader[1].ToString(), Options = myDataReader[2].ToString() }; tsDbFields.Add(tsDbField); } } } } } } catch (Exception) { //throw; } return tsDbFields; }