Allow table/column comments to be specified in the model

[QJesus]

env:
EntityFrameworkCore.Tools 2.2.3
MySql.Data.EntityFrameworkCore 8.0.15

DROP TABLE IF EXISTS `demo`;
CREATE TABLE `demo`  (
  `aaa` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'HOW TO ADD COMMENT',
  --                                                                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  `bbb` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`aaa`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

[roji]

FWIW this exists on PostgreSQL and is supported by Npgsql (although the SQL is different): npgsql/efcore.pg#135.

[ajcvickers]

Notes from triage: It would be good to port this from the Npgsql provider so that it is general relational functionality that can be used by any relational provider.

[Muppets]

For SQL Server provider, would we imagine this being supported with extendedproperties?

https://stackoverflow.com/questions/4586842/sql-comments-on-create-table-on-sql-server-2008

[ErikEJ]

are there any plans relating to reverse engineering for this?
Is this documented?

[divega]

@ErikEJ I think this is a good question. Can you please create a new issue to track that? (unless you are able to find one).

[NeilBostrom]

I've not added any documentation for it yet.

I also remember seeing some comments on supporting DescriptionAttribute, but I can't for the life of me find this now.