public void ReadFromDatabase(SqliteDataReader reader, ref int index)
{
if (PerformJoin)
{
ColumnValue = ForeignDataModelFactory.GenerateAndGetIDataModel(reader, ref index);
}
else
{
ColumnValue = ForeignDataModelFactory.GenerateDataModelWithOnlyPK(reader, ref index);
}
index++;
}
public string GetCreateForeignKeyCode()
{
return($"FOREIGN KEY ({ColumnName}) REFERENCES {ForeignDataModelFactory.TableName}({ForeignDataModelFactory.Get_PrimaryKeyProperties().ColumnName})");
}
public string GetCreateForeignKeyColumnCode()
{
return($"{ColumnName} {ForeignDataModelFactory.Get_PrimaryKeyProperties().ColumnType} ");
}
public string GetForeignTablePK()
{
return($"{GetJoinName()}.{ForeignDataModelFactory.Get_PrimaryKeyProperties().ColumnName}");
}
