EFCore 通过实体Model生成创建SQL Server数据库表脚本

 /// 
     /// Model 生成数据库表脚本     /// 
     public class TableGenerator : ITableGenerator {         private static Dictionary DataMapper {             get {                 var dataMapper = new Dictionary {                     {typeof(int), "NUMBER(10) NOT NULL"},                     {typeof(int?), "NUMBER(10)"},                     {typeof(string), "VARCHAR2({0} CHAR)"},                     {typeof(bool), "NUMBER(1)"},                     {typeof(DateTime), "DATE"},                     {typeof(DateTime?), "DATE"},                     {typeof(float), "FLOAT"},                     {typeof(float?), "FLOAT"},                     {typeof(decimal), "DECIMAL(16,4)"},                     {typeof(decimal?), "DECIMAL(16,4)"},                     {typeof(Guid), "CHAR(36)"},                     {typeof(Guid?), "CHAR(36)"}                 };                   return dataMapper;             }         }           private readonly List> _fields = new List>();           /// 
         ///         /// 
         private string _tableName;           /// 
         ///         /// 
         ///          private string GetTableName(MemberInfo entityType) {             if (_tableName != null)                 return _tableName;             var prefix = entityType.GetCustomAttribute() != null ? "#" : string.Empty;             return _tableName = $"{prefix}{entityType.GetCustomAttribute()?.Name ?? entityType.Name}";         }           /// 
         /// 生成创建表的脚本         /// 
         ///          public string GenerateTableScript(Type entityType) {             if (entityType == null)                 throw new ArgumentNullException(nameof(entityType));               GenerateFields(entityType);               const int DefaultColumnLength = 500;             var script = new StringBuilder();               script.AppendLine($"CREATE TABLE {GetTableName(entityType)} (");             foreach (var (propName, propertyInfo) in _fields) {                 if (!DataMapper.ContainsKey(propertyInfo.PropertyType))                     throw new NotSupportedException($"尚不支持 {propertyInfo.PropertyType}, 请联系开发人员.");                 if (propertyInfo.PropertyType == typeof(string)) {                     var maxLengthAttribute = propertyInfo.GetCustomAttribute();                     script.Append($"\t {propName} {string.Format(DataMapper[propertyInfo.PropertyType], maxLengthAttribute?.Length ?? DefaultColumnLength)}");                     if (propertyInfo.GetCustomAttribute() != null)                         script.Append(" NOT NULL");                     script.AppendLine(",");                 } else {                     script.AppendLine($"\t {propName} {DataMapper[propertyInfo.PropertyType]},");                 }             }               script.Remove(script.Length - 1, 1);               script.AppendLine(")");               return script.ToString();         }           private void GenerateFields(Type entityType) {             foreach (var p in entityType.GetProperties()) {                 if (p.GetCustomAttribute() != null)                     continue;                 var columnName = p.GetCustomAttribute()?.Name ?? p.Name;                 var field = new KeyValuePair(columnName, p);                 _fields.Add(field);             }         }     }

 /// 
     /// Model 生成数据库表脚本     /// 
     public interface ITableGenerator {         /// 
         /// 生成创建表的脚本         /// 
         ///          string GenerateTableScript(Type entityType);     }

 /// 
     /// 是否临时表, 仅限 Dapper 生成 数据库表结构时使用     /// 
     [AttributeUsage(AttributeTargets.Class | AttributeTargets.Struct)]     public class TempTableAttribute : Attribute {       }

 [TempTable]       class StringTable {           public string DefaultString { get; set; }           [MaxLength(30)]           public string LengthString { get; set; }           [Required]           public string NotNullString { get; set; }       }

 [Table("Test")]        class IntTable {            public int IntProperty { get; set; }            public int? NullableIntProperty { get; set; }        }

 public class SqlServerTableGenerator_Tests {        [Table("Test")]        class IntTable {            public int IntProperty { get; set; }            public int? NullableIntProperty { get; set; }        }          [Fact]        public void GenerateTableScript_Int_Number10() {            // Act            var sql = new TableGenerator().GenerateTableScript(typeof(IntTable));            // Assert            sql.ShouldContain("IntProperty NUMBER(10) NOT NULL");            sql.ShouldContain("NullableIntProperty NUMBER(10)");        }          [Fact]        public void GenerateTableScript_TestTableName_Test() {            // Act            var sql = new TableGenerator().GenerateTableScript(typeof(IntTable));            // Assert            sql.ShouldContain("CREATE TABLE Test");        }          [TempTable]        class StringTable {            public string DefaultString { get; set; }            [MaxLength(30)]            public string LengthString { get; set; }            [Required]            public string NotNullString { get; set; }        }          [Fact]        public void GenerateTableScript_TempTable_TableNameWithSharp() {            // Act            var sql = new TableGenerator().GenerateTableScript(typeof(StringTable));            // Assert            sql.ShouldContain("Create Table #StringTable");        }          [Fact]        public void GenerateTableScript_String_Varchar() {            // Act            var sql = new TableGenerator().GenerateTableScript(typeof(StringTable));            // Assert            sql.ShouldContain("DefaultString VARCHAR2(500 CHAR)");            sql.ShouldContain("LengthString VARCHAR2(30 CHAR)");            sql.ShouldContain("NotNullString VARCHAR2(500 CHAR) NOT NULL");        }          class ColumnTable {            [Column("Test")]            public int IntProperty { get; set; }            [NotMapped]            public int Ingored {get; set; }        }          [Fact]        public void GenerateTableScript_ColumnName_NewName() {            // Act            var sql = new TableGenerator().GenerateTableScript(typeof(ColumnTable));            // Assert            sql.ShouldContain("Test NUMBER(10) NOT NULL");        }          [Fact]        public void GenerateTableScript_NotMapped_Ignore() {            // Act            var sql = new TableGenerator().GenerateTableScript(typeof(ColumnTable));            // Assert            sql.ShouldNotContain("Ingored NUMBER(10) NOT NULL");        }          class NotSupportedTable {            public dynamic Ingored {get; set; }        }          [Fact]        public void GenerateTableScript_NotSupported_ThrowException() {            // Act            Assert.Throws(() => {                new TableGenerator().GenerateTableScript(typeof(NotSupportedTable));            });        }    }

 CREATE TABLE Test (      IntProperty NUMBER(10) NOT NULL,      NullableIntProperty NUMBER(10), )

 CREATE TABLE #StringTable (      DefaultString VARCHAR2(500 CHAR),      LengthString VARCHAR2(30 CHAR),      NotNullString VARCHAR2(500 CHAR) NOT NULL, )