public IActionResult GetFirstAlumnoCentro()
{
var uri = new Uri("https://localhost:44307/api");
var context = new AlumnosService.Default.Container(uri);
var query = context.Alumnos.First();
return(Ok(query.Centro));
}
public IActionResult GetAsignaturas()
{
var uri = new Uri("https://localhost:44307/api");
var context = new AlumnosService.Default.Container(uri);
var query = context.Asignaturas.Execute();
return(Ok(query));
}
public IActionResult GetAlumnosConCentro()
{
var uri = new Uri("https://localhost:44307/api");
var context = new AlumnosService.Default.Container(uri);
var query = context.Alumnos
.Expand(x => x.Centro);
return(Ok(query));
}
public IActionResult GetPorNombre(string name)
{
var uri = new Uri("https://localhost:44307/api");
var context = new AlumnosService.Default.Container(uri);
var query = context.Alumnos
.Where(x => x.Nombre.StartsWith(name));
return(Ok(query));
}
public async Task <IActionResult> GetQuery()
{
var uri = new Uri("https://localhost:44307/api");
var context = new AlumnosService.Default.Container(uri);
var centros = context.Centros.ExecuteAsync();
var Alumnos = context.Alumnos
.Expand(x => x.Centro)
.ExecuteAsync();
var query = from a in await Alumnos
join c in await centros
on a.Centro.Id equals c.Id
select new
{
Alumno = $"{a.Nombre} {a.Apellido1} {a.Apellido2}",
Centro = c.Nombre
};
return(Ok(query));
}
