internal static Type SqlTypeToNativeType(string sqlType)
{
switch (sqlType.ToLower()) {
case "bit":
return typeof (bool);
case "datetime":
case "smalldatetime":
return typeof (DateTime);
case "int":
return typeof (int);
case "uniqueidentifier":
return typeof (Guid);
case "binary":
case "varbinary":
case "image":
return typeof (byte[]);
default:
return typeof (string);
}
}