C# (CSharp) SQLServerTypeConstants示例

示例#1

文件： ColumnBase.cs 项目： joangilabert/nHydrate

        /// <summary>
        /// Determine if the specified type is
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        public static bool IsSupportedType(System.Data.SqlDbType type, SQLServerTypeConstants sqlVersion)
        {
            if (sqlVersion == SQLServerTypeConstants.SQL2005)
            {
                switch (type)
                {
                //case System.Data.SqlDbType.Xml:
                case System.Data.SqlDbType.Udt:
                case System.Data.SqlDbType.Structured:
                case System.Data.SqlDbType.Variant:
                case System.Data.SqlDbType.DateTimeOffset:
                case System.Data.SqlDbType.DateTime2:
                case System.Data.SqlDbType.Time:
                case System.Data.SqlDbType.Date:
                    return(false);

                default:
                    return(true);
                }
            }
            else if ((sqlVersion == SQLServerTypeConstants.SQL2008) || (sqlVersion == SQLServerTypeConstants.SQLAzure))
            {
                switch (type)
                {
                //case System.Data.SqlDbType.Xml:
                case System.Data.SqlDbType.Udt:
                case System.Data.SqlDbType.Structured:
                case System.Data.SqlDbType.Variant:
                    //case System.Data.SqlDbType.DateTimeOffset:
                    //case System.Data.SqlDbType.DateTime2:
                    //case System.Data.SqlDbType.Time:
                    //case System.Data.SqlDbType.Date:
                    return(false);

                default:
                    return(true);
                }
            }
            else
            {
                return(false);
            }
        }

示例#2

文件： ColumnBase.cs 项目： nHydrate/nHydrate

 /// <summary>
 /// Determine if the specified type is 
 /// </summary>
 /// <param name="type"></param>
 /// <returns></returns>
 public static bool IsSupportedType(System.Data.SqlDbType type, SQLServerTypeConstants sqlVersion)
 {
     if (sqlVersion == SQLServerTypeConstants.SQL2005)
     {
         switch (type)
         {
             //case System.Data.SqlDbType.Xml:
             case System.Data.SqlDbType.Udt:
             case System.Data.SqlDbType.Structured:
             case System.Data.SqlDbType.Variant:
             case System.Data.SqlDbType.DateTimeOffset:
             case System.Data.SqlDbType.DateTime2:
             case System.Data.SqlDbType.Time:
             case System.Data.SqlDbType.Date:
                 return false;
             default:
                 return true;
         }
     }
     else if ((sqlVersion == SQLServerTypeConstants.SQL2008) || (sqlVersion == SQLServerTypeConstants.SQLAzure))
     {
         switch (type)
         {
             //case System.Data.SqlDbType.Xml:
             case System.Data.SqlDbType.Udt:
             case System.Data.SqlDbType.Structured:
             case System.Data.SqlDbType.Variant:
                 //case System.Data.SqlDbType.DateTimeOffset:
                 //case System.Data.SqlDbType.DateTime2:
                 //case System.Data.SqlDbType.Time:
                 //case System.Data.SqlDbType.Date:
                 return false;
             default:
                 return true;
         }
     }
     else
     {
         return false;
     }
 }