public IEnumerable <T> GetWhere <T>(string field, object value, DataConditional conditional = DataConditional.EqualTo) where T : IOrmGenerated
{
Sanitise(field);
using (var rep = new SqlRepository(_Configuration, _Logger))
if (conditional == DataConditional.NotNull || conditional == DataConditional.IsNull)
{
return(rep.ExecuteSql <T>($"WHERE [{field}] {conditional.GetDataConditional()}", new List <SqlParameter>()) ?? new List <T>());
}
else
{
return(rep.ExecuteSql <T>($"WHERE [{field}] {conditional.GetDataConditional()} @{field}", new List <SqlParameter> {
new SqlParameter($"@{field}", value)
}) ?? new List <T>());
}
}
public IEnumerable <T> GetWhere <T>(string field, object value) where T : IOrmGenerated
{
using (var rep = new SqlRepository(_Configuration, _Logger))
return(rep.ExecuteSql <T>($"WHERE [{field}] = @{field}", new List <System.Data.SqlClient.SqlParameter> {
new System.Data.SqlClient.SqlParameter($"@{field}", value)
}));
}
public IEnumerable <T> GetWhere <T>(Dictionary <string, object> parameters, DataConditional conditional = DataConditional.EqualTo) where T : IOrmGenerated
{
var sb = new StringBuilder();
sb.AppendLine("WHERE ");
var sqlParams = new List <SqlParameter>();
bool first = true;
int paramIndex = 0;
Sanitise(parameters);
foreach (var o in parameters)
{
var paramName = $"sqlParam_{paramIndex}";
if (conditional == DataConditional.NotNull || conditional == DataConditional.IsNull)
{
sb.AppendLine($"{(first ? "" : " AND ")} [{o.Key}] {conditional.GetDataConditional()} ");
}
else
{
sb.AppendLine($"{(first ? "" : " AND ")} [{o.Key}] {conditional.GetDataConditional()} @{paramName.Replace(" ", "")} ");
sqlParams.Add(new SqlParameter($"@{paramName.Replace(" ", "")}", o.Value));
}
first = false;
paramIndex++;
}
using (var rep = new SqlRepository(_Configuration, _Logger))
return(rep.ExecuteSql <T>(sb.ToString(), sqlParams) ?? new List <T>());
}
public IEnumerable <T> GetWhere <T>(Dictionary <string, object> parameters) where T : IOrmGenerated
{
var sb = new StringBuilder();
sb.AppendLine("WHERE ");
var sqlParams = new List <SqlParameter>();
bool first = true;
foreach (var o in parameters)
{
sb.AppendLine($"{(first ? "" : " AND ")} [{o.Key}] = @{o.Key.Replace(" ", "")} ");
sqlParams.Add(new SqlParameter($"@{o.Key.Replace(" ", "")}", o.Value));
first = false;
}
using (var rep = new SqlRepository(_Configuration, _Logger))
return(rep.ExecuteSql <T>(sb.ToString(), sqlParams));
}
