select specific data from table in Microsoft.AspNetCore.Datasync.EFCore
I'm in the process of developing WPF app for clinical purposes, we offer app for each clinics to manage patient workflow. Trying to implement the data sync from API to WPF app.
Got a demo from https://github.com/Azure/azure-mobile-apps/tree/main/samples. But stuck at the moment that as all the data inside the tables are collected on the call but I need to select specific data using Id ( Clinic specific ). Tried a query etc but no success.
PatientsController.cs
[Route("tables/Patients")]
public class PatientsController : TableController<Patients>
{
public PatientsController(AppDbContext context)
: base(new EntityTableRepository<Patients>(context))
{
}
}
AppDbContext.cs
public class AppDbContext : DbContext
{
public AppDbContext(DbContextOptions<AppDbContext> options) : base(options)
{
}
public DbSet<Patients> Patients => Set<Patients>();
I would really appreciate if you could advice how to get patient specific updates ( based on clinics ) instead of all patients data