/// <summary>
/// Convert instance to System.Data.Common.DbParameter with <paramref name="factory"/>
/// </summary>
/// <param name="factory">Factory to convert with</param>
public DbParameter ToParameter(IDbProviderParam factory)
{
if (ConvertToParameter != null)
{
return(ConvertToParameter(factory, this));
}
if (ParamType != null)
{
return(factory.Create(ParamName, ParamValue, ParamType));
}
return(factory.Create(ParamName, ParamValue));
}
/// <summary>
/// Convert columns to SqlParamater collection with values
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="columns"></param>
/// <param name="factory"></param>
/// <param name="entity"></param>
/// <returns></returns>
public static List <DbParameter> ToParams <TEntity>(this IColumnCollection <TEntity> columns, Func <IColumnMapping <TEntity>, bool> filter, IDbProviderParam factory, TEntity entity)
{
var parameters = new List <DbParameter>();
foreach (var c in columns)
{
if (filter(c))
{
var value = c.GetField(entity);
parameters.Add(factory.Create(c.Param, value, c.FieldType));
}
}
return(parameters);
}
public DbParameter[] ToArray(IDbProviderParam factory)
{
return(_parameters.Select(kvp => factory.Create(kvp.Key, kvp.Value)).ToArray());
}
/// <summary>
/// Convert columns to SqlParamater collection with values
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="columns"></param>
/// <param name="factory"></param>
/// <param name="entity"></param>
/// <returns></returns>
public static List <DbParameter> ToParams <TEntity>(this IColumnCollection <TEntity> columns, IDbProviderParam factory, TEntity entity)
{
return(columns.ToParams(column => true, factory, entity));
}
