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); }
public string BuildInsertSpDDL(SqlParameterCollection parameters, string spName, TableAdapterContext ctx) { return(null); //StringBuilder sqlParamText = _paramBuilder.AddSelectParameters(parameters, ctx); //string valueClause = ListFormatter.ToDelimittedString<string>(ctx.ValueColumns, ", ", "[{0}]"); //string sqlBodyText = string.Format(InsertDMLFmt, ctx.TableSchema.TableName, valueClause); //return string.Format(StoredProcFmt, spName, sqlParamText, sqlBodyText); }
public string BuildSelectSpDDL(SqlParameterCollection parameters, string spName, TableAdapterContext ctx) { StringBuilder sqlParamText = _paramBuilder.AddSelectParameters(parameters, ctx); string valueClause = Delimiter.ToString <string>(ctx.ValueColumns, ", ", "[{0}]"); string whereClause = string.Empty; if (ctx.SearchFilter != null && ctx.SearchFilter.Count > 0) { whereClause = string.Format(WhereSqlFmt, Delimiter.ToString <SearchCondition>(ctx.SearchFilter, " AND ", ColValueParamFmt)); } string sqlBodyText = string.Format(SelectDMLFmt, valueClause, ctx.TableSchema.TableName, whereClause); return(string.Format(StoredProcFmt, spName, sqlParamText, sqlBodyText)); }
public string BuildUpdateSpDDL(SqlParameterCollection parameters, string spName, TableAdapterContext ctx) { StringBuilder sqlParamText = _paramBuilder.AddUpdateParameters(parameters, ctx); List <string> updatableValueColumns = new List <string>(ctx.ValueColumns); foreach (string colName in ctx.TableSchema.ReadOnlyColumnList) { updatableValueColumns.Remove(colName); } string setValFmt = (ctx.Overwrite) ? ColValueParamFmt : ColValueParamCaseFmt; string sqlBodyText = BuildUpdateSqlBody(ctx.TableSchema, updatableValueColumns, ctx.KeyColumns, setValFmt); return(string.Format(StoredProcFmt, spName, sqlParamText, sqlBodyText)); }
public StringBuilder AddInsertParameters(SqlParameterCollection parameters, TableAdapterContext ctx) { IEnumerable <string> paramColumns = Macros.Merge(ctx.KeyColumns, ctx.ValueColumns); return(DoAddParameters(parameters, ctx, paramColumns)); }
public StringBuilder AddDeleteParameters(SqlParameterCollection parameters, TableAdapterContext ctx) { IEnumerable <string> paramColumns = ctx.SearchColumns; return(DoAddParameters(parameters, ctx, paramColumns)); }
public TableAdapterBulkLoader(TableAdapterContext context) : base(context) { }
public TableAdapterBulkUpdater(TableAdapterContext context) : base(context) { }
public TableAdapterEditor(TableAdapterContext context) : base(context) { }
public TableAdapterBase(TableAdapterContext context) { _context = context; }