Пример #1
0
        private StringBuilder DoAddParameters(SqlParameterCollection parameters, TableAdapterContext ctx, IEnumerable <string> paramColumns)
        {
            parameters.Clear();
            if (paramColumns == null)
            {
                return(null);
            }

            StringBuilder sqlParamText = new StringBuilder();
            TableSchema   tblSchema    = ctx.TableSchema;

            int counter = 0;

            foreach (string colName in paramColumns)
            {
                DataRow dtRow = tblSchema.ColumnDef(colName);
                AddParameter(dtRow, ref parameters, ref sqlParamText, counter, ctx.KeyColumns);
                counter++;
            }

            return((counter > 0)? sqlParamText: null);
        }