public static DbTypes ToDbType(InputFieldTypes columnType)
{
switch (columnType)
{
case InputFieldTypes.Currency:
return(DbTypes.Numeric);
case InputFieldTypes.Date:
case InputFieldTypes.DateTime:
return(DbTypes.DateTime);
case InputFieldTypes.Numeric:
return(DbTypes.Numeric);
case InputFieldTypes.Integer:
case InputFieldTypes.Serial:
return(DbTypes.Integer);
case InputFieldTypes.Text:
return(DbTypes.VarChar);
case InputFieldTypes.Memo:
return(DbTypes.Text);
case InputFieldTypes.Binary:
case InputFieldTypes.Image:
return(DbTypes.Blob);
case InputFieldTypes.Bool:
return(DbTypes.SmallInt);
default:
throw new NotImplementedException();
}
}
public static DbTypes ToDbType(InputFieldTypes columnType)
{
switch(columnType)
{
case InputFieldTypes.Currency:
return DbTypes.Numeric;
case InputFieldTypes.Date:
case InputFieldTypes.DateTime:
return DbTypes.DateTime;
case InputFieldTypes.Numeric:
return DbTypes.Numeric;
case InputFieldTypes.Integer:
case InputFieldTypes.Serial:
return DbTypes.Integer;
case InputFieldTypes.Text:
return DbTypes.VarChar;
case InputFieldTypes.Memo:
return DbTypes.Text;
case InputFieldTypes.Binary:
case InputFieldTypes.Image:
return DbTypes.Blob;
case InputFieldTypes.Bool:
return DbTypes.SmallInt;
default:
throw new NotImplementedException();
}
}
