public static DbCommand AddParameters(this DbCommand dbCommand, DataSourceParameters parameters)
{
Argument.IsNotNull(() => dbCommand);
parameters?.Parameters?.ForEach(x => dbCommand.AddParameter(x));
return(dbCommand);
}
public static bool IsSameAs(this DataSourceParameters databaseQueryParameters, DataSourceParameters other)
{
if (ReferenceEquals(databaseQueryParameters, other))
{
return(true);
}
if (databaseQueryParameters.IsEmpty() && other.IsEmpty())
{
return(true);
}
var parameters = databaseQueryParameters?.Parameters;
var otherParameters = other?.Parameters;
if (parameters is null || otherParameters is null)
{
return(false);
}
return(parameters.SequenceEqual(otherParameters, new NameAndTypeEqualsEqualyComparer()));
}
public static string ToArgsNamesString(this DataSourceParameters queryParameters, string argsPrefix = "")
{
return(queryParameters is not null?string.Join(",", queryParameters.Parameters?.Select(x => $"{argsPrefix}{x.Name}") ?? new List <string>()) : string.Empty);
}
public static bool IsEmpty(this DataSourceParameters databaseQueryParameters)
{
return(databaseQueryParameters?.Parameters is null || !databaseQueryParameters.Parameters.Any());
}
public static string ToArgsValueString(this DataSourceParameters queryParameters)
{
return(queryParameters is not null?string.Join(",", queryParameters.Parameters?.Select(x => $"'{x.Value}'") ?? new List <string>()) : string.Empty);
}