add-entity

To add a new entity across MySQL, MSSQL, and PostgreSQL, you need to generate the model class, update DbContext, and create synchronized migrations for all three databases. This ensures schema consistency across MySQL, SQL Server, and PostgreSQL with parallel migrations.

Creating database migrations for a multi-database C# backend requires automating schema alignment across MySQL, SQL Server, and PostgreSQL. This involves updating DbContext and generating parallel migrations with required indexes and annotations to keep schemas aligned.

Yes, the entity creation workflow supports vector entities in PostgreSQL using OmsPgContext. It differentiates between standard business entities using OmsContext and vector entities, guiding class creation, fields, and context updates for both types.

To scaffold a standard business entity using OmsContext, provide the entity name and fields in natural language. The system validates the input, ensures proper inheritance from BaseEntity, updates the DbContext, and creates synchronized migrations with required indexes.

Multi-database migrations fail to keep schemas aligned across MySQL and MSSQL when DbContext updates and migration scripts are not synchronized. Ensuring proper inheritance from BaseEntity and generating parallel migrations with required indexes and annotations resolves this issue.