CodeSmith模板编写中，数据类型由DbType转化为C#类型（函数）

最新推荐文章于 2021-01-19 16:12:02 发布

agod2008

最新推荐文章于 2021-01-19 16:12:02 发布

阅读量154

点赞数

文章标签： c# 数据库

原文链接：http://www.cnblogs.com/T_max_Csharp/archive/2011/03/18/1987606.html

版权

public string DataType2CSharpType(System.Data.DbType dbType) 
 
    { 
 
        switch (dbType) 
 
        { 
 
            case DbType.AnsiString: 
 
                return "string"; 
 
            case DbType.AnsiStringFixedLength: 
 
                return "string"; 
 
            case DbType.Binary: 
 
                return "byte[]"; 
 
            case DbType.Boolean: 
 
                return "bool"; 
 
            case DbType.Byte: 
 
                return "byte"; 
 
            case DbType.Currency: 
 
                return "decimal"; 
 
            case DbType.Date: 
 
                return "DateTime"; 
 
            case DbType.DateTime: 
 
                return "DateTime"; 
 
            case DbType.DateTime2: 
 
                return "DateTime"; 
 
            case DbType.DateTimeOffset: 
 
                return "DateTime"; 
 
            case DbType.Decimal: 
 
                return "decimal"; 
 
            case DbType.Double: 
 
                return "double"; 
 
            case DbType.Guid: 
 
                return "Guid"; 
 
            case DbType.Int16: 
 
                return "short"; 
 
            case DbType.Int32: 
 
                return "int"; 
 
            case DbType.Int64: 
 
                return "long"; 
 
            case DbType.Object: 
 
                return "object"; 
 
            case DbType.SByte: 
 
                return "sbyte"; 
 
            case DbType.Single: 
 
                return "float"; 
 
            case DbType.String: 
 
                return "string"; 
 
            case DbType.StringFixedLength: 
 
                return "string"; 
 
            case DbType.Time: 
 
                return "DateTime"; 
 
                
 
            case DbType.UInt16: 
 
                return "ushort"; 
 
            case DbType.UInt32: 
 
                return "uint"; 
 
            case DbType.UInt64: 
 
                return "ulong"; 
 
            case DbType.VarNumeric: 
 
                return "decimal"; 
 
            case DbType.Xml: 
 
                return "string"; 
 
            default: 
 
                return "object"; 
 
        } 
 
    }

转载于:https://www.cnblogs.com/T_max_Csharp/archive/2011/03/18/1987606.html