Adding Column type to the column property

[amalsharief]

Could you kindly add the table column type ?
Thank you in advance.

Abdoessalam

My suggestion is :
To add Column type property - the column attribute in EF core is as follows :
Column Attribute: [Column (string name, Properties:[Order = int],[TypeName = string])
ex
[Column("DoB", Order = 1, TypeName="DateTime2")]

The suggested steps to add it :

a- open Craftsman\Models\EntityProperty.cs file, append the following property:

    public string ColumnType { get; set; }

b- open Craftsman\Builders\EntityBuilder.cs file and replace the following:

     if (!string.IsNullOrEmpty(entityProperty.ColumnName))                         
        attributeString += @$"        [Column(""{entityProperty.ColumnName}"",TypeName=""{entityProperty.ColumnType}"")]{Environment.NewLine}";              
    
    with the following:

     if (!string.IsNullOrEmpty(entityProperty.ColumnName))
        {
            if (!string.IsNullOrEmpty(entityProperty.ColumnType))
                attributeString += @$"        [Column(""{entityProperty.ColumnName}"",TypeName=""{entityProperty.ColumnType}"")]{Environment.NewLine}";
            else
                attributeString += @$"        [Column(""{entityProperty.ColumnName}"")]{Environment.NewLine}";
        }

[pdevito3]

Sounds reasonable. I'll put it in my backlog

[pdevito3]

Btw, if you're up for a PR it would be more than welcomed. Not sure how soon I'll get to this, but it should be a pretty low lift and good first ticket!

• new property on EntityProperty
• updating the attribute builder in the EntityBuilder class