public void GenerateStringQry_GoodParameters_OK() { string qry = $"Select * from Clientes where Telefono like '%@Telefono%' and mail like '%@Mail%'"; var parameters = new Dictionary <string, object>() { { "Telefono", 5 }, { "Mail", ".es" } }; string expected = "Select * from Clientes where Telefono like '%5%' and mail like '%.es%'"; string result = instance.GenerateStringQry(qry, parameters); Assert.Equal(expected, result); }
/// <summary> /// Get Entities in DB from qry with object parameters /// </summary> /// <param name="filter"></param> /// <returns>Entities for this filter</returns> public IEnumerable <TEntity> GetData(string qry, object parameters) { ParameterValidator.ValidateString(qry, nameof(qry)); ParameterValidator.ValidateObject(parameters, nameof(parameters)); var parametersDictionary = qryParameterManager.GetParametersDictionary(parameters); string qryDef = qryParameterManager.GenerateStringQry(qry, parametersDictionary); var result = context.Database.SqlQuery <TEntity>(qryDef).ToList(); return(result); }