public static void TvpBinaryExpressionBuilder(string parameterName, SqlDbType sqlType, int length, ParameterExpression expRecord, Expression expProperty, IList <Expression> setExpressions, IList <NewExpression> sqlMetaDataTypeExpressions, HashSet <string> parameterNames, ref int ordinal, Type propertyType, ParameterExpression prmColumnList, ParameterExpression expLogger, ILogger logger)
{
var dataName = SqlParameterCollectionExtensions.NormalizeSqlColumnName(parameterName);
if (parameterNames.Add(dataName))
{
var ctor = typeof(SqlMetaData).GetConstructor(new[] { typeof(string), typeof(SqlDbType), typeof(int) });
var expPrmName = Expression.Constant(dataName, typeof(string));
var expPrmType = Expression.Constant(sqlType, typeof(SqlDbType));
var expPrmLength = Expression.Constant((long)length, typeof(long));
sqlMetaDataTypeExpressions.Add(Expression.New(ctor, new[] { expPrmName, expPrmType, expPrmLength }));
var miSet = typeof(SqlDataRecord).GetMethod(nameof(SqlDataRecord.SetBytes));
var miDbNull = typeof(SqlDataRecord).GetMethod(nameof(SqlDataRecord.SetDBNull));
var expOrdinal = Expression.Call(typeof(TvpExpressionHelpers).GetMethod(nameof(TvpExpressionHelpers.GetOrdinal), BindingFlags.NonPublic | BindingFlags.Static), Expression.Constant(ordinal, typeof(int)), Expression.Constant(parameterName, typeof(string)), prmColumnList);
var expFieldOffset = Expression.Constant(0L, typeof(long));
var expBufOffset = Expression.Constant(0, typeof(int));
var expLength = Expression.Property(expProperty, typeof(byte[]).GetProperty(nameof(Array.Length)));
var expAssign = Expression.Condition(
Expression.Equal(expProperty, Expression.Constant(null, typeof(byte[]))),
Expression.Call(expRecord, miDbNull, new Expression[] { Expression.Constant(ordinal, typeof(int)) }),
Expression.Call(expRecord, miSet, new Expression[] { Expression.Constant(ordinal, typeof(int)), expFieldOffset, expProperty, expBufOffset, expLength })
);
setExpressions.Add(Expression.IfThen(
Expression.Call(typeof(TvpExpressionHelpers).GetMethod(nameof(TvpExpressionHelpers.IncludeThisColumn), BindingFlags.NonPublic | BindingFlags.Static), new Expression[] { Expression.Constant(parameterName, typeof(string)), prmColumnList }), //if
expAssign)); //then
}
}
//int, short, byte, enum
public static void TvpEnumXIntExpressionBuilder(string parameterName, SqlDbType sqlType, string methodName, Type baseType, ParameterExpression expRecord, Expression expProperty, IList <Expression> setExpressions, IList <NewExpression> sqlMetaDataTypeExpressions, HashSet <string> parameterNames, ref int ordinal, Type propertyType, ParameterExpression prmColumnList, ParameterExpression expLogger, ILogger logger)
{
var dataName = SqlParameterCollectionExtensions.NormalizeSqlColumnName(parameterName);
if (parameterNames.Add(dataName))
{
var ctor = typeof(SqlMetaData).GetConstructor(new[] { typeof(string), typeof(SqlDbType) });
var expPrmName = Expression.Constant(dataName, typeof(string));
var expPrmType = Expression.Constant(sqlType, typeof(SqlDbType));
sqlMetaDataTypeExpressions.Add(Expression.New(ctor, new[] { expPrmName, expPrmType }));
var miSet = typeof(SqlDataRecord).GetMethod(methodName);
var miDbNull = typeof(SqlDataRecord).GetMethod(nameof(SqlDataRecord.SetDBNull));
var expOrdinal = Expression.Call(typeof(TvpExpressionHelpers).GetMethod(nameof(TvpExpressionHelpers.GetOrdinal), BindingFlags.NonPublic | BindingFlags.Static), Expression.Constant(ordinal, typeof(int)), Expression.Constant(parameterName, typeof(string)), prmColumnList);
Expression expAssign;
if (propertyType.IsEnum)
{
expAssign = Expression.Call(expRecord, miSet, new Expression[] { expOrdinal, Expression.Convert(expProperty, baseType) });
}
else if (propertyType.IsGenericType && propertyType.GetGenericTypeDefinition() == typeof(Nullable <>))
{
//var baseType = Nullable.GetUnderlyingType(propertyType);
var piNullableHasValue = propertyType.GetProperty(nameof(Nullable <int> .HasValue));
var piNullableGetValue = propertyType.GetProperty(nameof(Nullable <int> .Value));
if (Nullable.GetUnderlyingType(propertyType).IsEnum)
{
expAssign = Expression.Condition(
Expression.Property(expProperty, piNullableHasValue),
Expression.Call(expRecord, miSet, new Expression[] { expOrdinal, Expression.Convert(Expression.Convert(Expression.Property(expProperty, piNullableGetValue), typeof(int)), baseType) }),
Expression.Call(expRecord, miDbNull, new Expression[] { expOrdinal })
);
//left off here: need to convert Nullable<Enum> and validate int
}
else //if (Nullable.GetUnderlyingType(propertyType) == typeof(int))
{
expAssign = Expression.Condition(
Expression.Property(expProperty, piNullableHasValue),
Expression.Call(expRecord, miSet, new Expression[] { expOrdinal, Expression.Convert(Expression.Property(expProperty, piNullableGetValue), baseType) }),
Expression.Call(expRecord, miDbNull, new Expression[] { expOrdinal })
);
}
}
else
{
expAssign = Expression.Call(expRecord, miSet, new Expression[] { expOrdinal, expProperty });
}
setExpressions.Add(Expression.IfThen(
Expression.Call(typeof(TvpExpressionHelpers).GetMethod(nameof(TvpExpressionHelpers.IncludeThisColumn), BindingFlags.NonPublic | BindingFlags.Static), new Expression[] { Expression.Constant(parameterName, typeof(string)), prmColumnList }), //if
expAssign)); //then
}
}
public static void TvpStringExpressionBuilder(string parameterName, SqlDbType sqlType, int length, ParameterExpression expRecord, Expression expProperty, IList <Expression> setExpressions, IList <NewExpression> sqlMetaDataTypeExpressions, HashSet <string> parameterNames, ref int ordinal, Type propertyType, ParameterExpression prmColumnList, ParameterExpression expLogger, ILogger logger)
{
var dataName = SqlParameterCollectionExtensions.NormalizeSqlColumnName(parameterName);
if (parameterNames.Add(dataName))
{
var ctor = typeof(SqlMetaData).GetConstructor(new[] { typeof(string), typeof(SqlDbType), typeof(long) });
var expPrmName = Expression.Constant(dataName, typeof(string));
var expPrmType = Expression.Constant(sqlType, typeof(SqlDbType));
var expPrmLength = Expression.Constant((long)length, typeof(long));
sqlMetaDataTypeExpressions.Add(Expression.New(ctor, new[] { expPrmName, expPrmType, expPrmLength }));
var miSet = typeof(SqlDataRecord).GetMethod(nameof(SqlDataRecord.SetString));
var miDbNull = typeof(SqlDataRecord).GetMethod(nameof(SqlDataRecord.SetDBNull));
var expOrdinal = Expression.Call(typeof(TvpExpressionHelpers).GetMethod(nameof(TvpExpressionHelpers.GetOrdinal), BindingFlags.NonPublic | BindingFlags.Static), Expression.Constant(ordinal, typeof(int)), Expression.Constant(parameterName, typeof(string)), prmColumnList);
Expression expAssign;
if (propertyType.IsEnum)
{
var miEnumToString = typeof(Enum).GetMethod(nameof(Enum.ToString), new Type[] { });
var expGetString = Expression.Call(expProperty, miEnumToString);
expAssign = Expression.Call(expRecord, miSet, new Expression[] { expOrdinal, expGetString });
}
else if (propertyType.IsGenericType && propertyType.GetGenericTypeDefinition() == typeof(Nullable <>) && Nullable.GetUnderlyingType(propertyType).IsEnum) //Nullable Enum
{
var miEnumToString = typeof(Enum).GetMethod(nameof(Enum.ToString), new Type[] { });
var piNullableHasValue = propertyType.GetProperty(nameof(Nullable <int> .HasValue));
var piNullableGetValue = propertyType.GetProperty(nameof(Nullable <int> .Value));
expAssign = Expression.Condition(
Expression.Property(expProperty, piNullableHasValue),
Expression.Call(expRecord, miSet, new Expression[] { expOrdinal, Expression.Call(Expression.Property(expProperty, piNullableGetValue), miEnumToString) }),
Expression.Call(expRecord, miDbNull, new Expression[] { expOrdinal })
);
}
else
{
expAssign = Expression.Condition(
Expression.Equal(expProperty, Expression.Constant(null, typeof(string))),
Expression.Call(expRecord, miDbNull, new Expression[] { expOrdinal }),
Expression.Call(expRecord, miSet, new Expression[] { expOrdinal, expProperty })
);
}
setExpressions.Add(Expression.IfThen(
Expression.Call(typeof(TvpExpressionHelpers).GetMethod(nameof(TvpExpressionHelpers.IncludeThisColumn), BindingFlags.NonPublic | BindingFlags.Static), new Expression[] { Expression.Constant(parameterName, typeof(string)), prmColumnList }), //if
expAssign)); //then
}
}
/// <summary>
///
/// </summary>
/// <param name="parameters"></param>
/// <returns></returns>
public static string ToLogString(this IDataParameterCollection parameters)
{
Assert.IsNotNull(parameters);
var sqlParameters = parameters as SqlParameterCollection;
string s;
if (sqlParameters != null)
{
s = SqlParameterCollectionExtensions.ToLogString(sqlParameters);
}
else
{
var sb = new StringBuilder();
var first = true;
foreach (IDataParameter parameter in parameters)
{
if (parameter.Direction != ParameterDirection.ReturnValue)
{
var value = parameter.Value;
if (value != null)
{
string valueString;
if (value == DBNull.Value)
{
valueString = SqlNull.NullString;
}
else
{
var dbType = parameter.DbType;
switch (dbType)
{
case DbType.DateTime:
var dateTime = (DateTime)value;
valueString = dateTime.ToTSqlDateTime();
break;
case DbType.Int32:
valueString = value.ToString();
break;
case DbType.String:
valueString = "'" + value.ToString().Replace("'", "''") + "'";
break;
default:
valueString = value.ToString();
break;
}
}
if (first)
{
first = false;
}
else
{
sb.AppendLine(",");
}
sb.AppendFormat(" {0} = {1}", parameter.ParameterName, valueString);
}
}
}
s = sb.ToString();
}
return(s);
}
