protected override void OnAddRelation(AddRelationship <TEntity> addRelationship)
{
foreach (var leftRelationship in this.left.Relationships)
{
addRelationship(leftRelationship);
}
}
protected override void OnAddRelation(AddRelationship <TEntity> addRelationship)
{
foreach (var relationship in this.specification.Relationships)
{
addRelationship(relationship);
}
}
protected override void OnAddRelation(AddRelationship <Person> addRelationship)
{
base.OnAddRelation(addRelationship);
var relationship = new Relationship <Person>(person => person.EmailAddresses);
addRelationship(relationship);
}
/// <summary>
///
/// </summary>
/// <param name="builder"></param>
public void OnCreating_Test1()
{
AddTable <DbEmployee>(DbFluent.Table(nameof(DbEmployee).Substring(2), "Mdm"))
.AddTable("RegionalDirectorate", DbFluent.Table(nameof(DbRegionalDirectorate).Substring(2), "Mdm"))
.AddTable <DbContact>(DbFluent.Table(nameof(DbContact).Substring(2), "Mdm"))
.AddRelationship("Employee_RegionalDirectorate",
Table <DbEmployee>(), Table("RegionalDirectorate"),
(nameof(DbEmployee.EmployeeId), nameof(DbRegionalDirectorate.RegionalDirectorateId)))
.AddRelationship <DbEmployee, DbContact>((p => p.MainContactId, q => q.ContactId))
.AddRelationship <DbEmployee, DbContact>("secondary", (p => p.MainContactId, q => q.ContactId))
.AddTuple("Fields_SelectEmployee",
DbFluent.FieldAsAll(Table <DbEmployee>()),
DbFluent.Field(nameof(DbRegionalDirectorate.RegionalDirectorateId), Table("RegionalDirectorate")),
DbFluent.Field(nameof(DbRegionalDirectorate.Code), Table("RegionalDirectorate")))
.AddTuple("Fields_SelectEmployee2",
DbFluent.FieldAsAll(Table <DbEmployee>("employee")),
DbFluent.Field <DbContact>(p => p.Code, Table <DbContact>("contact")).WithAlias("contactCode"),
DbFluent.Field(nameof(DbRegionalDirectorate.RegionalDirectorateId), Table("RegionalDirectorate", "regionalDirectorate")),
DbFluent.Field(nameof(DbRegionalDirectorate.Code), Table("RegionalDirectorate", "regionalDirectorate")))
.AddQuery(
DbFluent.StoredQuery(
DbFluent.SelectQuery(Table <DbEmployee>())
.From(
Table <DbEmployee>(),
DbFluent.TableAsJoin(
DbQueryJoinKind.Left,
Table("RegionalDirectorate"),
JoinCondition("Employee_RegionalDirectorate")))
.WithFields(Tuple("Fields_SelectEmployee"))
.AddIdField(p => DbFluent.FieldAsParameter(nameof(DbEmployee.Code), p.UseParameter("code")))));
}
protected override void OnAddRelation(AddRelationship <TEntity> addRelationship)
{
}
/// <summary>
///
/// </summary>
public void OnCreating_Test2()
{
// Community
AddTable <DbCommunity>(
DbFluent.Table(nameof(DbCommunity).Substring(2), DbSchemas.Test2.ToString()),
q => q.CommunityId,
q => q.Code,
q => q.CreationDate,
q => q.LabelEN,
q => q.LabelFR,
q => q.LastModificationDate)
.AddTuple(
"SelectCommunity",
AllFields <DbCommunity>().ToArray()
)
.AddTuple(
"UpdateCommunity",
DbFluent.Field(nameof(DbCommunity.Code), Table <DbCommunity>()),
Field <DbCommunity>(q => q.LabelEN),
Field(nameof(DbCommunity.LabelFR), "DbCommunity"),
DbFluent.Field(nameof(DbCommunity.LastModificationDate), Table <DbCommunity>())
);
// Country
AddTable <DbCountry>(
DbFluent.Table(nameof(DbCountry).Substring(2), DbSchemas.Test2.ToString()),
q => q.CountryId,
q => q.Code,
q => q.CreationDate,
q => q.LabelEN,
q => q.LabelFR,
q => q.LastModificationDate)
.AddTuple(
"SelectCountry",
Field <DbCountry>(q => q.CountryId),
DbFluent.Field(nameof(DbCountry.Code), Table <DbCountry>()),
DbFluent.Field(nameof(DbCountry.CreationDate)),
DbFluent.Field(nameof(DbCountry.LabelEN)),
DbFluent.Field(nameof(DbCountry.LabelFR)),
DbFluent.Field(nameof(DbCountry.LastModificationDate)))
.AddTuple(
"UpdateCountry",
DbFluent.Field(nameof(DbCountry.Code)),
DbFluent.Field(nameof(DbCountry.LabelEN)),
DbFluent.Field(nameof(DbCountry.LabelFR)),
DbFluent.Field(nameof(DbCountry.LastModificationDate)));
// Country_Community
AddTable("Country_Community", DbFluent.Table(nameof(DbCountry_Community).Substring(2), DbSchemas.Test2.ToString()))
.AddTuple(
"SelectCountry_Community",
DbFluent.Field(nameof(DbCountry_Community.CountryId), Table("Country_Community")),
DbFluent.Field(nameof(DbCountry_Community.CommunityId), Table("Country_Community")))
.AddTuple(
"UpdateCountry",
DbFluent.Field(nameof(DbCountry_Community.CountryId), Table("Country_Community")),
DbFluent.Field(nameof(DbCountry_Community.CommunityId), Table("Country_Community")));
// CountryInformation
AddTable <DbCountryInformation>(
DbFluent.Table(nameof(DbCountryInformation).Substring(2), DbSchemas.Test2.ToString()))
.AddTuple(
"SelectCountryInformation",
DbFluent.Field(nameof(DbCountryInformation.CountryId)),
DbFluent.Field(nameof(DbCountryInformation.CreationDate)),
DbFluent.Field(nameof(DbCountryInformation.LastModificationDate)),
DbFluent.Field(nameof(DbCountryInformation.StartDate)))
.AddTuple(
"UpdateCountryInformation",
DbFluent.Field(nameof(DbCountryInformation.LastModificationDate)),
DbFluent.Field(nameof(DbCountryInformation.StartDate)));
// Relationships
AddRelationship(
"Community_Country_Community",
Table <DbCommunity>(),
Table("Country_Community"),
(nameof(DbCommunity.CommunityId), nameof(DbCountry_Community.CommunityId)))
.AddRelationship(
"Community_Country_Community",
Table <DbCountry>(),
Table("Country_Community"),
(nameof(DbCountry.CountryId), nameof(DbCountry_Community.CountryId)))
.AddRelationship <DbCountryInformation, DbCountry>(
(q => q.CountryId, q => q.CountryId));
}
protected virtual void OnAddRelation(AddRelationship <TEntity> addRelationship)
{
}
protected override void OnAddRelation(AddRelationship <Animal> addRelationship)
{
base.OnAddRelation(addRelationship);
addRelationship(Relationship <Animal> .Create(animal => animal.Family));
}
