/// <summary>
/// Delete the specified employee.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery DeleteEmployee1(string code)
{
var query = DbFluent.DeleteQuery(Table <DbEmployee>())
.AddIdField(DbFluent.FieldAsLiteral <DbEmployee>(p => p.Code, code));
return(query);
}
/// <summary>
/// Delete the specified employee.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery DeleteEmployee5(string code)
{
var query = DbFluent.DeleteQuery(Table <DbEmployee>())
.Where(q => DbFluent.Eq(DbFluent.Field("code"), code));
return(query);
}
/// <summary>
/// Delete the specified country.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery QueryDeleteCountry(string code)
{
return(this.UseQuery("DeleteCountry", p =>
DbFluent.DeleteQuery(Table("Country"))
.AddIdField(q => DbFluent.FieldAsParameter(nameof(DbCountry.Code), q.UseParameter("code", DataValueTypes.Text))))
.WithParameters(
ElementFactory.CreateScalar("code", code)));
}
/// <summary>
/// Delete the specified employee.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery DeleteEmployee4(string code)
{
var query = DbFluent.DeleteQuery(Table <DbEmployee>())
.Where(q => DbFluent.Eq(DbFluent.Field("code"), q.UseParameter("code", DataValueTypes.Text)))
.WithParameters(
ElementFactory.CreateScalar("code", code));
return(query);
}
/// <summary>
/// Delete the specified employee.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery DeleteEmployee3(string code)
{
var query = DbFluent.DeleteQuery(Table <DbEmployee>())
.Where(q => DataExpressionFactory.CreateExpAsAuto("{{" + string.Format("$sqlEq($sqlField('Code'), {0})", q.UseParameter("code", DataValueTypes.Text).AsExp()) + "}}"))
.WithParameters(
ElementFactory.CreateScalar("code", code));
return(query);
}
/// <summary>
/// Delete the specified employee.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery DeleteEmployee6(string code)
{
var query = DbFluent.DeleteQuery(Table <DbEmployee>())
.From(
DbFluent.TableAsJoin(
DbQueryJoinKind.Left,
Table("RegionalDirectorate").WithAlias("directorate"),
JoinCondition("Employee_RegionalDirectorate", null, "directorate")))
.Where(q => DbFluent.Eq(DbFluent.Field("code"), code));
return(query);
}
/// <summary>
/// Delete the specified employee.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery DeleteEmployee9(string code)
{
var query = DbFluent.DeleteQuery(Table <DbEmployee>())
.From(
DbFluent.TableAsJoin(DbQueryJoinKind.Left,
Table("RegionalDirectorate").WithAlias("directorate"),
JoinCondition("Employee_RegionalDirectorate")))
.Where(q => DbFluent.Eq(DbFluent.Field("code"), q.UseParameter("code", DataValueTypes.Text)))
.AddIdField(q => DbFluent.FieldAsParameter(nameof(DbEmployee.Code), q.UseParameter("code", DataValueTypes.Text)))
.WithParameters(
ElementFactory.CreateScalar("code", code));
return(query);
}
/// <summary>
/// Delete the specified employee.
/// </summary>
/// <param name="code">The code to consider.</param>
/// <returns>Returns the generated query.</returns>
internal IDbQuery DeleteEmployee7(string code)
{
var query = DbFluent.DeleteQuery(Table <DbEmployee>())
.From(
TableAsJoin <DbContact>(
DbQueryJoinKind.Left,
JoinCondition <DbEmployee, DbContact>())
.WithAlias("mainCountry"))
.Where(q => DataExpressionFactory.CreateExpAsAuto("{{" + string.Format("$sqlEq($sqlField('Code'), {0})", q.UseParameter("code", DataValueTypes.Text).AsExp()) + "}}"))
.WithParameters(
ElementFactory.CreateScalar("code", code));
return(query);
}
/// <summary> /// Creates a new Delete advanced database query. /// </summary> /// <returns>Returns a new Delete advanced database query</returns> public IDbSingleQuery DeleteQuery <T>(Action <IDbSingleQuery> initAction = null) => DbFluent.DeleteQuery(Table <T>(), initAction);
// Delete --------------------------------
/// <summary>
/// Creates a new Delete advanced database query.
/// </summary>
/// <returns>Returns a new Delete advanced database query</returns>
public IDbSingleQuery DeleteQuery <T>(string name, Action <IDbSingleQuery> initAction = null)
=> DbFluent.DeleteQuery(name, Table <T>(), initAction);
