/// <summary>
/// Updates the regional directorate of the specified Fidal employee.
/// </summary>
/// <param name="regionalDirectorateCode">The code of the regional directorate to consider.</param>
/// <returns>Returns the query.</returns>
internal IDbQuery UpdateEmployee2(string regionalDirectorateCode)
{
return(this.UseQuery("UpdateEmployee2", p =>
DbFluent.UpdateQuery(Table("DbEmployee", "employee"))
.AddField(q => DbFluent.Field <DbEmployee>(q => q.RegionalDirectorateId).AsNull())
.From(Table("RegionalDirectorate", "regionalDirectorate"))
.AddIdField(q =>
DbFluent.FieldAsOther <DbEmployee>(
t => t.RegionalDirectorateId, Table("DbEmployee", "employee"),
DbFluent.Field <DbRegionalDirectorate>(
t => t.RegionalDirectorateId, Table("RegionalDirectorate").WithAlias("regionalDirectorate"))))
.AddIdField(q =>
DbFluent.FieldAsParameter <DbEmployee>(
t => t.Code,
DbFluent.Table("employee"),
q.UseParameter("regionalDirectorateCode", DataValueTypes.Text)))
.WithReturnedIdFields(Field("Code", "DbEmployee", "employee"))
)
.WithParameters(
ElementFactory.CreateScalar("regionalDirectorateCode", regionalDirectorateCode)));
}
