DAO To OleDb Data Type Maps

Here is a quick tip for remapping DAO data types to OleDb data types.

#region DAO To OleDb Map
private string DAOToOleDbMap(string daoDataType)
{
var ret = daoDataType;

switch (daoDataType)
{

case "10": // OleDbType.VarChar
return "OleDbType.VarChar";
case "12": // OleDbType.VarWChar
return "OleDbType.VarWChar";
case "7": // OleDbType.Numeric
return "OleDbType.Numeric";
case "2": // OleDbType.Integer
return "OleDbType.Integer";
case "8": // OleDbType.Date
return "OleDbType.Date";
case "5": // OleDbType.Currency
return "OleDbType.Currency";
case "1": // OleDbType.Boolean
return "OleDbType.Boolean";
case "9": // OleDbType.VarBinary
return "OleDbType.VarBinary";
default:
Debug.WriteLine(daoDataType);
break;
}

return ret;
}
#endregion