/// <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);