public static bool IsSupportedType(DataTypeConstants type, DatabaseTypeConstants sqlVersion)
{
if (sqlVersion == DatabaseTypeConstants.SQL2005)
{
switch (type)
{
//case DataTypeConstants.Xml:
case DataTypeConstants.Udt:
case DataTypeConstants.Structured:
case DataTypeConstants.Variant:
case DataTypeConstants.DateTimeOffset:
case DataTypeConstants.DateTime2:
case DataTypeConstants.Time:
case DataTypeConstants.Date:
return(false);
default:
return(true);
}
}
else if ((sqlVersion == DatabaseTypeConstants.SQL2008) || (sqlVersion == DatabaseTypeConstants.SQLAzure))
{
switch (type)
{
//case DataTypeConstants.Xml:
case DataTypeConstants.Udt:
case DataTypeConstants.Structured:
case DataTypeConstants.Variant:
//case DataTypeConstants.DateTimeOffset:
//case DataTypeConstants.DateTime2:
//case DataTypeConstants.Time:
//case DataTypeConstants.Date:
return(false);
default:
return(true);
}
}
else
{
return(false);
}
}
public static bool IsSupportedType(DataTypeConstants type, DatabaseTypeConstants sqlVersion)
{
if (sqlVersion == DatabaseTypeConstants.SQL2005)
{
switch (type)
{
//case DataTypeConstants.Xml:
case DataTypeConstants.Udt:
case DataTypeConstants.Structured:
case DataTypeConstants.Variant:
case DataTypeConstants.DateTimeOffset:
case DataTypeConstants.DateTime2:
case DataTypeConstants.Time:
case DataTypeConstants.Date:
return false;
default:
return true;
}
}
else if ((sqlVersion == DatabaseTypeConstants.SQL2008) || (sqlVersion == DatabaseTypeConstants.SQLAzure))
{
switch (type)
{
//case DataTypeConstants.Xml:
case DataTypeConstants.Udt:
case DataTypeConstants.Structured:
case DataTypeConstants.Variant:
//case DataTypeConstants.DateTimeOffset:
//case DataTypeConstants.DateTime2:
//case DataTypeConstants.Time:
//case DataTypeConstants.Date:
return false;
default:
return true;
}
}
else
{
return false;
}
}
