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;
}
