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