本文整理汇总了C#中DatabaseSchemaReader.DataSchema.DatabaseColumn.DbDataTypeStandard方法的典型用法代码示例。如果您正苦于以下问题：C# DatabaseColumn.DbDataTypeStandard方法的具体用法？C# DatabaseColumn.DbDataTypeStandard怎么用？C# DatabaseColumn.DbDataTypeStandard使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DatabaseSchemaReader.DataSchema.DatabaseColumn的用法示例。
在下文中一共展示了DatabaseColumn.DbDataTypeStandard方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: WriteDataType
public string WriteDataType(DatabaseColumn column)
{
if (column == null) return string.Empty;
if (string.IsNullOrEmpty(column.DbDataType)) return string.Empty;
var dataType = column.DbDataTypeStandard();
dataType = OtherDatabaseTypesToPostgreSql(dataType, column);
if ((dataType.StartsWith("TIMESTAMP", StringComparison.OrdinalIgnoreCase) || dataType == "TIME") &&
column.DateTimePrecision > 0)
dataType = dataType + " (" + column.DateTimePrecision + ")";
//write out datatype definition
if ((dataType == "VARCHAR" || dataType == "CHAR") && column.Length > 0)
{
dataType = dataType + " (" + column.Length + ")";
}
if (dataType == "NUMERIC" || dataType == "DECIMAL")
{
var scale = column.Scale;
var precision = column.Precision;
var writeScale = ((scale != null) && (scale > 0) ? "," + scale : "");
if (precision > 0) //Postgresql can have no specified precision
dataType = dataType + " (" + precision + writeScale + ")";
}
return dataType;
}示例2: OracleDataTypeForParameter
public static string OracleDataTypeForParameter(DatabaseColumn column)
{
if (column == null) return string.Empty;
if (string.IsNullOrEmpty(column.DbDataType)) return string.Empty;
var dataType = column.DbDataTypeStandard();
int providerType = GetProviderType(column);
var length = column.Length;
//oracle to sql server translation
dataType = SqlServerToOracleConversion(dataType, providerType, length);
return dataType;
}示例3: OracleDataType
/// <summary>
/// Gets the Oracle datatype definition as string
/// </summary>
/// <param name="column">The column.</param>
/// <returns></returns>
public static string OracleDataType(DatabaseColumn column)
{
if (column == null) return string.Empty;
if (string.IsNullOrEmpty(column.DbDataType)) return string.Empty;
var dataType = column.DbDataTypeStandard();
int providerType = GetProviderType(column);
var precision = column.Precision;
var scale = column.Scale;
var length = column.Length;
dataType = PostgreSqlToSqlServerConversion(dataType);
//oracle to sql server translation
dataType = SqlServerToOracleConversion(dataType, providerType, length);
if (dataType == "NUMERIC" || dataType == "DECIMAL")
{
var writeScale = ((scale != null) && (scale > 0) ? "," + scale : "");
dataType = dataType + " (" + precision + writeScale + ")";
}
return dataType;
}