/// <summary> /// Widen datatype /// </summary> /// <param name="one">Datatype one</param> /// <param name="two">Datatype two</param> /// <returns>Widened datatype</returns> private DataType Widen(DataType one, DataType two) { OleDbType type = DataType.CommonType(one.Type, two.Type); one.Type = type; one.Length = Math.Max(one.Length.GetValueOrDefault(0), two.Length.GetValueOrDefault(0)); one.Precision = Math.Max(one.Precision.GetValueOrDefault(0), two.Precision.GetValueOrDefault(0)); one.Scale = Math.Max(one.Scale.GetValueOrDefault(0), two.Scale.GetValueOrDefault(0)); return(one); }