コード例 #1
0
        private static string GetSQLField(ColumnSchema column)
        {
            string        ty   = column.GetSQLType();
            List <string> list = new List <string>();

            if (column.IsPrimary)
            {
                list.Add("PK");
            }

            if (column.IsForeignKey)
            {
                list.Add("FK");
            }

            if (column.IsIdentity)
            {
                list.Add("++");
            }

            list.Add(ty);
            list.Add(column.Nullable ? "null" : "not null");

            if (column.IsComputed)
            {
                list.Add($"={column.Definition}");
            }

            string line = string.Join(", ", list);

            return($"{column.ColumnName} ({line})");
        }