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)); }