static TypeConvertor()
{
DbTypeMapEntry dbTypeMapEntry
= new DbTypeMapEntry(typeof(bool), DbType.Boolean, SqlDbType.Bit);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(byte), DbType.Byte, SqlDbType.TinyInt);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(byte[]), DbType.Binary, SqlDbType.Image);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(DateTime), DbType.DateTime, SqlDbType.DateTime);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(DateTime), DbType.DateTime2, SqlDbType.DateTime2);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(Decimal), DbType.Decimal, SqlDbType.Decimal);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(double), DbType.Double, SqlDbType.Float);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(Guid), DbType.Guid, SqlDbType.UniqueIdentifier);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(Int16), DbType.Int16, SqlDbType.SmallInt);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(Int32), DbType.Int32, SqlDbType.Int);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(Int64), DbType.Int64, SqlDbType.BigInt);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(object), DbType.Object, SqlDbType.Variant);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(string), DbType.String, SqlDbType.VarChar);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry
= new DbTypeMapEntry(typeof(string), DbType.AnsiString, SqlDbType.VarChar);
_DbTypeList.Add(dbTypeMapEntry);
}
static TypeConvertor()
{
DbTypeMapEntry dbTypeMapEntry = new DbTypeMapEntry(typeof(bool), DbType.Boolean, Microsoft.SqlServer.Management.Smo.SqlDataType.Bit, XmlTypeCode.Boolean);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(byte), DbType.Double, Microsoft.SqlServer.Management.Smo.SqlDataType.TinyInt, XmlTypeCode.Short);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(byte[]), DbType.Binary, Microsoft.SqlServer.Management.Smo.SqlDataType.Image, XmlTypeCode.HexBinary);
_DbTypeList.Add(dbTypeMapEntry);
// DATETIME
dbTypeMapEntry = new DbTypeMapEntry(typeof(DateTime), DbType.DateTime, Microsoft.SqlServer.Management.Smo.SqlDataType.DateTime, XmlTypeCode.DateTime);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(DateTime), DbType.DateTime, Microsoft.SqlServer.Management.Smo.SqlDataType.DateTime2, XmlTypeCode.DateTime);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(DateTime), DbType.DateTime, Microsoft.SqlServer.Management.Smo.SqlDataType.Date, XmlTypeCode.DateTime);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Decimal), DbType.Decimal, Microsoft.SqlServer.Management.Smo.SqlDataType.Decimal, XmlTypeCode.Decimal);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(double), DbType.Double, Microsoft.SqlServer.Management.Smo.SqlDataType.Float, XmlTypeCode.Float);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Guid), DbType.Guid, Microsoft.SqlServer.Management.Smo.SqlDataType.UniqueIdentifier, XmlTypeCode.Text);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Int16), DbType.Int16, Microsoft.SqlServer.Management.Smo.SqlDataType.SmallInt, XmlTypeCode.Short);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Int32), DbType.Int32, Microsoft.SqlServer.Management.Smo.SqlDataType.Int, XmlTypeCode.Int);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Int64), DbType.Int64, Microsoft.SqlServer.Management.Smo.SqlDataType.BigInt, XmlTypeCode.Long);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(object), DbType.Object, Microsoft.SqlServer.Management.Smo.SqlDataType.Variant, XmlTypeCode.Element);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(string), DbType.String, Microsoft.SqlServer.Management.Smo.SqlDataType.VarChar, XmlTypeCode.String);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Decimal), DbType.VarNumeric, Microsoft.SqlServer.Management.Smo.SqlDataType.Numeric, XmlTypeCode.Decimal);
_DbTypeList.Add(dbTypeMapEntry);
}
private static DbTypeMapEntry Find(Microsoft.SqlServer.Management.Smo.SqlDataType sqlDbType)
{
object retObj = new DbTypeMapEntry(typeof(System.String), DbType.String, Microsoft.SqlServer.Management.Smo.SqlDataType.VarChar, XmlTypeCode.String);
for (int i = 0; i < _DbTypeList.Count; i++)
{
DbTypeMapEntry entry = (DbTypeMapEntry)_DbTypeList[i];
if (entry.SqlDbType == sqlDbType)
{
retObj = entry;
break;
}
}
return (DbTypeMapEntry)retObj;
}
/// <summary>
/// Convert TSQL data type to DbType
/// </summary>
/// <param name="sqlDbType"></param>
/// <returns></returns>
public static DbType ToDbType(SqlDbType sqlDbType)
{
DbTypeMapEntry entry = Find(sqlDbType);
return(entry.DbType);
}
/// <summary>
/// Convert .Net type to TSQL data type
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static SqlDbType ToSqlDbType(Type type)
{
DbTypeMapEntry entry = Find(type);
return(entry.SqlDbType);
}
/// <summary>
/// Convert db type to .Net data type
/// </summary>
/// <param name="dbType"></param>
/// <returns></returns>
public static Type ToNetType(DbType dbType)
{
DbTypeMapEntry entry = Find(dbType);
return(entry.Type);
}
/// <summary>
/// Convert .Net type to Db type
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static DbType ToDbType(Type type)
{
DbTypeMapEntry entry = Find(type);
return(entry.DbType);
}
/// <summary>
/// Convert TSQL data type to DbType
/// </summary>
/// <param name="sqlDbType"></param>
/// <returns></returns>
public static DbType ToDbType(Microsoft.SqlServer.Management.Smo.SqlDataType sqlDbType)
{
DbTypeMapEntry entry = Find(sqlDbType);
return(entry.DbType);
}
/// <summary>
/// Convert DbType type to TSQL data type
/// </summary>
/// <param name="dbType"></param>
/// <returns></returns>
public static Microsoft.SqlServer.Management.Smo.SqlDataType ToSqlDbType(DbType dbType)
{
DbTypeMapEntry entry = Find(dbType);
return(entry.SqlDbType);
}
public static XmlTypeCode ToXmlType(Microsoft.SqlServer.Management.Smo.SqlDataType sqlDbType)
{
DbTypeMapEntry entry = Find(sqlDbType);
return(entry.XSchemaType);
}
public static Type ToNetType(XmlTypeCode xmlType)
{
DbTypeMapEntry entry = Find(xmlType);
return(entry.Type);
}
static TypeConvertor()
{
DbTypeMapEntry dbTypeMapEntry = new DbTypeMapEntry(typeof(bool), DbType.Boolean, SqlDbType.Bit);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(byte), DbType.Byte, SqlDbType.TinyInt);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(byte[]), DbType.Binary, SqlDbType.Image);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(DateTime), DbType.DateTime, SqlDbType.DateTime);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Decimal), DbType.Decimal, SqlDbType.Decimal);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(double), DbType.Double, SqlDbType.Float);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Guid), DbType.Guid, SqlDbType.UniqueIdentifier);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Int16), DbType.Int16, SqlDbType.SmallInt);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Int32), DbType.Int32, SqlDbType.Int);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Int64), DbType.Int64, SqlDbType.BigInt);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(object), DbType.Object, SqlDbType.Variant);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(string), DbType.String, SqlDbType.NVarChar);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(string), DbType.AnsiString, SqlDbType.VarChar);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(DateTime), DbType.DateTime2, SqlDbType.SmallDateTime);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(DateTime), DbType.DateTimeOffset, SqlDbType.DateTimeOffset);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(Char), DbType.AnsiStringFixedLength, SqlDbType.Char);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(object), DbType.Binary, SqlDbType.Binary);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(string), DbType.Xml, SqlDbType.Xml);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(DateTime), DbType.Time, SqlDbType.Time);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(short), DbType.Single, SqlDbType.SmallInt);
_DbTypeList.Add(dbTypeMapEntry);
dbTypeMapEntry = new DbTypeMapEntry(typeof(DataTable), DbType.Object, SqlDbType.Udt);
_DbTypeList.Add(dbTypeMapEntry);
}
/// <summary>
/// Convert DbType type to TSQL data type
/// </summary>
/// <param name="dbType"></param>
/// <returns></returns>
public static MySqlDbType ToMySqlDbType(DbType dbType)
{
DbTypeMapEntry entry = Find(dbType);
return(entry.MySqlDbType);
}
/// <summary>
/// Convert TSQL type to .Net data type
/// </summary>
/// <param name="MySqlDbType"></param>
/// <returns></returns>
public static Type ToNetType(MySqlDbType MySqlDbType)
{
DbTypeMapEntry entry = Find(MySqlDbType);
return(entry.Type);
}
