protected virtual TCmd BuildInsert()
{
if (SqlSets.Count == 0)
{
return(null);
}
TCmd cmd = new TCmd();
cmd.CommandText = "INSERT INTO " + SqlTable
+ "(" + SqlSets.Select(kvp => QuoteName(kvp.Key)).Join(", ")
+ ") VALUES ("
+ SqlSets.Select(kvp => "@" + ParamUniqueKey + "S_" + kvp.Key).Join(", ")
+ ")";
SetUpdateParameters(cmd, false);
return(cmd);
}
protected virtual TCmd BuildUpdate()
{
if (SqlSets.Count == 0)
{
return(null);
}
TCmd cmd = new TCmd();
cmd.CommandText = "UPDATE " + SqlTable
+ " SET "
+ SqlSets.Where(kvp => !PreservedFields.Contains(kvp.Key))
.Select(kvp => QuoteName(kvp.Key) + " = @" + ParamUniqueKey + "S_" + kvp.Key)
.Join(", ")
+ (SqlConditionals.Count == 0 ? ""
: " WHERE " + SqlConditionals.Select(sc => sc.Replace("@", "@" + ParamUniqueKey)).Join(" AND "));
SetParameters(cmd);
SetUpdateParameters(cmd, true);
return(cmd);
}
