/// <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);
}
public void GetParametersDictionary_GoodParameters_OK()
{
object parameters = new { Telefono = 5, Mail = ".es" };
Dictionary <string, object> result = instance.GetParametersDictionary(parameters);
Assert.Equal(result.Count, 2);
Assert.Equal(result.First().Key, "Telefono");
Assert.Equal(result.First().Value, 5);
Assert.Equal(result.ElementAt(1).Key, "Mail");
Assert.Equal(result.ElementAt(1).Value, ".es");
}