public List<Parameter> GetFilterColumns(XsdDataBase.TBL_FilterRow filtro, int id_Objeto) { var param = new List<Parameter>(); var filterFields = filtro.GetTBL_Filter_FieldRows(); foreach (var Flt in filterFields) { var field = (TBL_FieldRow)(TBL_Field.Select("fk_Object = " + id_Objeto + " AND Field_Name = '" + Flt.Field_Name + "'")[0]); var direction = (ParameterDirection)(Enum.Parse(typeof(ParameterDirection), field.Direction)); var fType = (DbType)(Enum.Parse(typeof(DbType), field.Field_Type)); param.Add(new Parameter(field.Field_Name, fType, "", field.Specific_Type, field.Is_Nullable, field.Max_Length, field.Precision, field.Scale, direction)); } return param; }