private void AddVariableParameters(ref string sqlQuery, List <SqlParameter> queryParams) { if (!string.IsNullOrWhiteSpace(sqlQuery)) { IDataManageEngine dataManageEngine = new DataManageEngine(base.EngineSharedModel, base.UnitOfWork); List <string> extractedParams = DomainUtility.GetParameters(sqlQuery); foreach (string parameter in extractedParams) { if (!queryParams.Any(c => c.ParameterName == parameter.Replace(".", "_")) && Regex.Matches(sqlQuery, "declare(\\s*?)" + parameter).Count == 0) { var result = dataManageEngine.GetValueByBinding(parameter.TrimStart('@')); if (result != null) { queryParams.Add(new SqlParameter(parameter.Replace(".", "_"), result)); sqlQuery = sqlQuery.Replace(parameter, parameter.Replace(".", "_")); } } } } }