SmartSQL/SmartSQL.Framework/Util/MapHelper/OracleDbTypeMapHelper.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SmartSQL.Framework.Util
{
    public class OracleDbTypeMapHelper
    {
        public static string MapCsharpType(string dbtype, bool isNullable)
        {
            if (string.IsNullOrEmpty(dbtype)) return dbtype;
            dbtype = dbtype.ToLower();
            string csharpType = "object";
            switch (dbtype)
            {
                case "int":
                case "integer":
                case "interval year to  month":
                case "interval day to  second":
                case "number": csharpType = isNullable ? "int?" : "int"; break;
                case "decimal": csharpType = isNullable ? "decimal?" : "decimal"; break;
                case "varchar":
                case "varchar2":
                case "nvarchar2":
                case "char":
                case "nchar":
                case "clob":
                case "long":
                case "nclob":
                case "rowid": csharpType = "string"; break;
                case "date":
                case "timestamp":
                case "timestamp with local time zone":
                case "timestamp with time zone": csharpType = isNullable ? "DateTime?" : "DateTime"; break;
                default: csharpType = "object"; break;
            }
            return csharpType;
        }
    }
}