/// <summary>
/// Create a new condition phrase.
/// </summary>
/// <param name="relationDef">Relation definition.</param>
public APSqlConditionPhrase(APRelationDef relationDef)
{
if (relationDef == null)
throw new ArgumentNullException("relationDef");
_expr = new APSqlColumnExpr(relationDef.Master);
_conditionOperator = APSqlConditionOperator.Equals;
_value = new APSqlColumnExpr(relationDef.Slave);
}
/// <summary>
/// Create a new 'SET' phrase.
/// </summary>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
/// <param name="paramName">Parameter name.</param>
public APSqlSetPhrase(APSqlColumnExpr assignmentExpr, object value, string paramName)
{
if (Object.Equals(assignmentExpr, null))
throw new ArgumentNullException("assignmentExpr");
if (value is String)
value = APSqlExpr.TryFitStringToRawExpr((string)value);
_assignmentExpr = assignmentExpr;
_paramName = String.IsNullOrEmpty(paramName) ? assignmentExpr.ParamName : paramName;
_value = value;
}
/// <summary>
/// Create a new 'SET' phrase.
/// </summary>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
/// <param name="paramName">Parameter name.</param>
public APSqlSetPhrase(APSqlColumnExpr assignmentExpr, object value, string paramName)
{
if (Object.Equals(assignmentExpr, null))
{
throw new ArgumentNullException("assignmentExpr");
}
if (value is String)
{
value = APSqlExpr.TryFitStringToRawExpr((string)value);
}
_assignmentExpr = assignmentExpr;
_paramName = String.IsNullOrEmpty(paramName) ? assignmentExpr.ParamName : paramName;
_value = value;
}
/// <summary>
/// Create a new 'SET' phrase what user sql expression
/// </summary>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="valueExpr">SQL value of assignment Expression.</param>
public APSqlSetPhrase(APSqlColumnExpr assignmentExpr, IAPSqlValueExpr valueExpr)
: this(assignmentExpr, valueExpr, null)
{
}
/// <summary>
/// Create a new 'SET' phrase.
/// </summary>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
public APSqlSetPhrase(APSqlColumnExpr assignmentExpr, object value)
: this(assignmentExpr, value, null)
{
}
/// <summary>
/// Create a new 'SET' phrase what user sql expression
/// </summary>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="valueExpr">SQL value of assignment Expression.</param>
public APSqlSetPhrase(APSqlColumnExpr assignmentExpr, IAPSqlValueExpr valueExpr)
: this(assignmentExpr, valueExpr, null)
{
}
/// <summary>
/// Create a new 'SET' phrase.
/// </summary>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
public APSqlSetPhrase(APSqlColumnExpr assignmentExpr, object value)
: this(assignmentExpr, value, null)
{
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="valueExpr">SQL value of assignment Expression.</param>
/// <returns>The command.</returns>
public static APSqlInsertCommand set(this APSqlInsertCommand command, APSqlColumnExpr assignmentExpr, IAPSqlValueExpr valueExpr)
{
return(set(command, new APSqlSetPhrase(assignmentExpr, valueExpr)));
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
/// <param name="paramName">Parameter name.</param>
/// <returns>The command.</returns>
public static APSqlInsertCommand set(this APSqlInsertCommand command, APSqlColumnExpr assignmentExpr, object value, string paramName)
{
return(set(command, new APSqlSetPhrase(assignmentExpr, value, paramName)));
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="valueExpr">SQL value of assignment Expression.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand set(this APSqlUpdateCommand command, APSqlColumnExpr assignmentExpr, IAPSqlValueExpr valueExpr)
{
return set(command, new APSqlSetPhrase(assignmentExpr, valueExpr));
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
/// <param name="paramName">Parameter name.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand set(this APSqlUpdateCommand command, APSqlColumnExpr assignmentExpr, object value, string paramName)
{
return set(command, new APSqlSetPhrase(assignmentExpr, value, paramName));
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand set(this APSqlUpdateCommand command, APSqlColumnExpr assignmentExpr, object value)
{
return(set(command, new APSqlSetPhrase(assignmentExpr, value)));
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
/// <returns>The command.</returns>
public static APSqlInsertCommand set(this APSqlInsertCommand command, APSqlColumnExpr assignmentExpr, object value)
{
return set(command, new APSqlSetPhrase(assignmentExpr, value));
}
