public static bool IsOutputType(this Je.ISqlExpander exp, ref Type type)
{
var geType = type.IsGenericType && type.GetGenericTypeDefinition() == typeof(MssqlCommandParameterOutput <>) ? Je.sys.GenericOf(type) : null;
var isOutput = geType != null;
type = geType ?? type;
return(isOutput);
}
public static SqlDbType SqlTypeOf(this Je.ISqlExpander exp, Type type)
{
if (type.IsEnum ||
type == typeof(bool) ||
type == typeof(bool?) ||
type == typeof(byte) ||
type == typeof(byte?) ||
type == typeof(sbyte) ||
type == typeof(sbyte?) ||
type == typeof(short) ||
type == typeof(short?) ||
type == typeof(ushort) ||
type == typeof(ushort?) ||
type == typeof(int) ||
type == typeof(int?) ||
type == typeof(uint) ||
type == typeof(uint?) ||
type == typeof(long) ||
type == typeof(long?) ||
type == typeof(ulong) ||
type == typeof(ulong?))
{
return(SqlDbType.BigInt);
}
if (type == typeof(decimal) ||
type == typeof(decimal?) ||
type == typeof(float) ||
type == typeof(float?) ||
type == typeof(double) ||
type == typeof(double?))
{
return(SqlDbType.Money);
}
if (type == typeof(Guid) ||
type == typeof(Guid?))
{
return(SqlDbType.UniqueIdentifier);
}
if (type == typeof(DateTime) ||
type == typeof(DateTime?))
{
return(SqlDbType.DateTime);
}
if (type == typeof(char) || type == typeof(char?))
{
return(SqlDbType.NChar);
}
if (type == typeof(byte[]))
{
return(SqlDbType.VarBinary);
}
if (type == typeof(string))
{
return(SqlDbType.NVarChar);
}
return(SqlDbType.NVarChar);
}
public static object SqlValueOf(this Je.ISqlExpander exp, object value)
{
if (value == null)
{
return(DBNull.Value);
}
var type = value.GetType();
if (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(MssqlCommandParameterOutput <>))
{
return(type.GetProperty("Value", BindingFlags.Instance | BindingFlags.NonPublic).GetValue(value, null));
}
if (!Je.sys.IsSimple(type))
{
return(Je.xml.Of(value));
}
if (value is Guid)
{
var g = (Guid)value;
if (g == Guid.Empty)
{
return(DBNull.Value);
}
}
if (value is DateTime)
{
var d = (DateTime)value;
if (SqlDateTime.MinValue.Value >= d || d >= SqlDateTime.MaxValue.Value)
{
return(DBNull.Value);
}
}
if (value.Equals(Je.sys.DefaultOf(value.GetType())))
{
return(DBNull.Value);
}
if (type.IsEnum || type == typeof(bool) || type == typeof(bool?) || type == typeof(byte) || type == typeof(byte?) || type == typeof(sbyte) || type == typeof(sbyte?) || type == typeof(short) || type == typeof(short?) || type == typeof(ushort) || type == typeof(ushort?) || type == typeof(int) || type == typeof(int?) || type == typeof(uint) || type == typeof(uint?) || type == typeof(long) || type == typeof(long?) || type == typeof(ulong) || type == typeof(ulong?))
{
return((long)value);
}
if (type == typeof(decimal) || type == typeof(decimal?) || type == typeof(float) || type == typeof(float?) || type == typeof(double) || type == typeof(double?))
{
return((decimal)value);
}
return(value);
}
public static object To(this Je.ISqlExpander exp, DataSet ds, Type type)
{
return(Je <SqlConverter> .Onu().Deserialize(ds, type));
}
public static T To <T>(this Je.ISqlExpander exp, DataSet ds)
{
return((T)Je <SqlConverter> .Onu().Deserialize(ds, typeof(T)));
}
public static DataSet Of(this Je.ISqlExpander exp, object value)
{
return(Je <SqlConverter> .Onu().Serialize(value));
}