public VfpStringTypeMapping(
VfpType vfpType,
int?size = null,
bool fixedLength = false
) : this(vfpType.ToVfpTypeName(), size, fixedLength, vfpType)
{
}
public static string GetDefaultValue(this VfpType vfpType)
{
switch (vfpType)
{
case VfpType.Logical:
return(".f.");
case VfpType.BinaryCharacter:
case VfpType.BinaryMemo:
case VfpType.BinaryVarchar:
case VfpType.Character:
case VfpType.Memo:
case VfpType.Varchar:
return("''");
case VfpType.Currency:
case VfpType.Numeric:
case VfpType.Double:
case VfpType.Float:
case VfpType.Integer:
case VfpType.AutoIncInteger:
return("0");
case VfpType.Date:
case VfpType.DateTime:
return("Date(1900, 1, 1)");
default:
throw new NotImplementedException(vfpType.ToString());
}
}
public static string ToVfpTypeName(this VfpType vfpType)
{
if (!_vfpTypeToVfpTypeName.ContainsKey(vfpType))
{
throw new VfpException("Unable to convert VfpType " + vfpType + " to a VfpTypeName");
}
return(_vfpTypeToVfpTypeName[vfpType]);
}
public VfpParameter(string name, VfpType vfpType)
{
_vfpType = vfpType;
OleDbParameter = new OleDbParameter {
ParameterName = name,
DbType = vfpType.ToDbType()
};
}
public static bool IsStringType(this VfpType vfpType)
{
return(vfpType == VfpType.BinaryCharacter ||
vfpType == VfpType.BinaryMemo ||
vfpType == VfpType.BinaryVarchar ||
vfpType == VfpType.Character ||
vfpType == VfpType.Memo ||
vfpType == VfpType.Varchar);
}
public static DbType ToDbType(this VfpType vfpType)
{
if (!_vfpTypeToDbType.ContainsKey(vfpType))
{
throw new VfpException("Unable to convert VfpType " + vfpType + " to a DbType");
}
return(_vfpTypeToDbType[vfpType]);
}
private static Type GetClrType(VfpType vfpType, bool isNullable)
{
var type = vfpType.ToType();
if (isNullable && type.IsValueType) {
type = typeof(Nullable<>).MakeGenericType(new[] { type });
}
return type;
}
private static Type GetClrType(VfpType vfpType, bool isNullable)
{
var type = vfpType.ToType();
if (isNullable && type.IsValueType)
{
type = typeof(Nullable <>).MakeGenericType(new[] { type });
}
return(type);
}
public VfpTypeMapping(
VfpType vfpType,
Type type
) : this(new RelationalTypeMappingParameters(
new CoreTypeMappingParameters(type),
vfpType.ToVfpTypeName(),
StoreTypePostfix.None,
vfpType.ToDbType()
),
vfpType
)
{
}
public VfpNumericTypeMapping(
VfpType vfpType,
int?precision = null,
int?scale = null,
StoreTypePostfix storeTypePostfix = StoreTypePostfix.None
) : this(new RelationalTypeMappingParameters(
new CoreTypeMappingParameters(typeof(decimal)),
vfpType.ToVfpTypeName(),
storeTypePostfix,
vfpType.ToDbType()
).WithPrecisionAndScale(precision, scale),
vfpType
)
{
}
protected VfpNumericTypeMapping(RelationalTypeMappingParameters parameters, VfpType vfpType)
: base(parameters)
{
_vfpType = vfpType;
}
public VfpParameter Add(string parameterName, VfpType vfpType)
{
return(Add(new VfpParameter(parameterName, vfpType)));
}
public void ResetVfpType()
{
OleDbParameter.ResetDbType();
_vfpType = OleDbParameter.DbType.ToVfpType();
}
internal VfpParameter(VfpParameter vfpParameter)
{
OleDbParameter = (OleDbParameter)((ICloneable)vfpParameter.OleDbParameter).Clone();
_vfpType = OleDbParameter.DbType.ToVfpType();
}
internal VfpParameter(OleDbParameter oleDbParameter)
{
OleDbParameter = oleDbParameter;
_vfpType = OleDbParameter.DbType.ToVfpType();
}
public VfpParameter(string name, object value)
{
OleDbParameter = new OleDbParameter(GetValidParameterName(name), value);
_vfpType = OleDbParameter.DbType.ToVfpType();
}
public VfpTypeAndDbTypeTestCase(VfpType vfpType, DbType dbType)
{
this.VfpType = vfpType;
this.DbType = dbType;
}
