public virtual void SetCGColumn(CGColumn column) { column.Comment = column.Row["COLUMN_COMMENT"].ToString(); column.Name = column.Row["COLUMN_NAME"].ToString(); column.IsNullable = column.Row["IS_NULLABLE"].ToString() == "NO" ? false : true; column.IsPK = column.Row["COLUMN_KEY"].ToString() == "PRI" ? true : false; switch (column.Row["DATA_TYPE"].ToString().ToUpper()) { case "VARCHAR": case "CHAR": case "TEXT": case "MEDIUMTEXT": case "TINYBLOB": case "TINYTEXT": case "BLOB": case "MEDIUMBLOB": case "LOGNGBLOB": case "LONGTEXT": column.Type = "string"; break; case "BIT": column.Type = "bool"; break; case "DATE": case "TIME": case "YEAR": case "DATETIME": case "TIMESTAMP": column.Type = "DateTime"; break; case "FLOAT": case "DOUBLE": column.Type = "double"; break; case "DECIMAL": column.Type = "decimal"; break; case "TINYINT": case "SMALLINT": case "MEDIUMINT": case "INT": case "INTEGER": case "BIGINT": case "ENUM": column.Type = "int"; break; default: break; } }
public override void SetCGColumn(CGColumn column) { column.Name = column.Row["COLUMN_NAME"].ToString(); column.IsNullable = column.Row["IS_NULLABLE"].ToString() == "NO" ? false : true; switch (column.Row["DATA_TYPE"].ToString().ToLower()) { case "char": case "varchar": case "text": case "nchar": case "nvarchar": case "ntext": column.Type = "string"; break; case "bit": column.Type = "bool"; break; case "binary": case "varbinary": case "image": column.Type = "object"; break; case "uniqueidentifier": column.Type = "Guid"; break; case "datetime": case "smalldatetime": case "timestamp": column.Type = "DateTime"; break; case "real": case "float": case "double": column.Type = "double"; break; case "numeric": case "decimal": case "money": case "smallmoney": column.Type = "decimal"; break; case "int": case "smallint": case "tinyint": case "bigint": column.Type = "int"; break; default: break; } }