One model - two table !?

[Mike6x]

I Have two module in two project with two Database shema like Todos Module :

• Setting Module with Dimension model => to save some pickup value ...., then other project can use it.
• Elearing Module with Quiz model
• Quiz and Dimension have relationship one => Many

When do migration, EF created two Dimensions table: One for Quiz Quiz Project, one for Setting Project !!

How to work around this issue , because I only want all porjects use same table Dimension in Setting Module ?

Belows are codes ...

` namespace FSH.Starter.WebApi.Elearning.Domain;

public class Quiz : AuditableEntity, IAggregateRoot { public int Order { get; private set; } public string Code { get; private set; } public string Name { get; private set; } public Guid QuizTypeId { get; private set; } public virtual Dimension QuizType { get; private set; } = default!; public Guid QuizTopicId { get; private set; } public virtual Dimension QuizTopic { get; private set; } = default!; public Guid QuizModeId { get; private set; } public virtual Dimension QuizMode { get; private set; } = default!; }

namespace FSH.Starter.WebApi.Setting.Domain;

public class Dimension : AuditableEntity, IAggregateRoot { public int Order { get; private set; } public string Code { get; private set; } public string Name { get; private set; } public string? Description { get; private set; } } ` ' namespace FSH.Framework.Infrastructure.Persistence; public static class SchemaNames { public const string Todo = "todo"; public const string Catalog = "catalog"; public const string Tenant = "tenant"; public const string Setting = "setting"; public const string Elearning = "elearning"; }

'

[jacekmichalski]

I'm also interested in figuring out how to different modules should communicate. E.g. there is product catalog module. Next I want to add e.g. competitor offers module (to track competitor prices). So one product has many offers. How to communicate between modules? @iammukeshm do you have any examples? Thanks in advance

[arisng]

I guess this article will point you in the appropriate direction for your problem. Modeling Navigation Properties Between Aggregates or Modules https://ardalis.com/navigation-properties-between-aggregates-modules/