private void InitializeDynamicFields(Form form) { foreach (var section in form.Sections) { foreach (var field in section.Fields) { if (!string.IsNullOrWhiteSpace(field.OptionListType) && field.OptionListType.Equals(OptionType.SQL)) { string sql = field.OptionListStatement; string optionList = _formInstanceHelper.ExecuteSQL(new SQLData { Parameters = null, Query = sql, ReturnColumn = "_sequenceid" }); if (!string.IsNullOrWhiteSpace(optionList)) { field.OptionList = JsonConvert.DeserializeObject <List <Option> >(optionList); } else { field.OptionList = new List <Option>(); } field.OptionListType = null; field.OptionListStatement = null; } } } }