Hello, could someone explain to me how it works IQueryable that I use it directly in VB.NET ??
Thanks.
Dim obj As IQueryable(Of AfipEscalaSuss)
Hello, could someone explain to me how it works IQueryable that I use it directly in VB.NET ??
Thanks.
Dim obj As IQueryable(Of AfipEscalaSuss)
IQueryable is an interface that lets you allows to execute queries to a set of data.
IQueryable<Order> result = context.Orders;
//Se filtran todas las órdenes donde el id sea igual a 10248.
IQueryable<Order> product = result.Where(x => x.OrderID == 10248);
//Recorremos todas las órdenes filtradas en product y mostramos el nombre de barco.
foreach (Order r in product)
{
Console.WriteLine(r.ShipName);
}
IQueryable(Of T) is an interface that allows you to store a expression that can be modified before being evaluated to obtain the data.
Example using Entity Framework
Dim query As IQueryable = db.Personas 'Aún no se traen los datos de la BD
query = query.Where(Function(p) p.Edad > 18) 'Todavía no se ejecuta la consulta
Dim resultados = query.ToList() 'Acá si se genera el SQL correspondiente y se traen los datos desde la BD