xamarin.forms join query on azure sql database

Question

I have created a Xamarin.Forms app in Visual Studio that connects to an Azure SQL Database via an Azure Mobile App. So far everything is working fine - I can do CRUD operations on the database from my Xamarin App.

However I have not yet been able to perform an inner join query on two or more tables.

I have created one such query in a View on the Database, and it works ok on the server, but my problem is that I do not know how to connect to this View from the Xamarin.Forms app.

I would really appreciate any help :-)

Thank you!

XAMARIN.FORMS SERVICE CLASS FOR A GENERIC AZURE TABLE:

public class service<T> : serviceBase<T> where T : irlm.azure.models.modelBase
{
    public async Task<ObservableCollection<T>> get()
    {
        var items = await table.ToEnumerableAsync();
        return new ObservableCollection<T>(items);
    }

    public async Task<T> update(T item)
    {
        if (item.Id == null)
            await table.InsertAsync(item);
        else
            await table.UpdateAsync(item);
        return item;
    }

    public async Task delete(T item)
    {
        await table.DeleteAsync(item);
    }
}

public abstract class serviceBase<T>
{
    MobileServiceClient dc;
    public IMobileServiceTable<T> table;

    public serviceBase()
    {
        dc = new MobileServiceClient(irlm.constants.appUrl);
        table = dc.GetTable<T>();
    }
}

XAMARIN.FORMS MODEL EXAMPLE

public abstract class modelBase
{
    public string Id { get; set; }
}

public class golfClub : modelBase
{
    public string name { get; set; }
}

public class golfCourse : modelBase
{
    public string idClub { get; set; }
    public string name { get; set; }
}

XAMARIN.FORMS VIEWMODEL:

public class viewModel<T> : INotifyPropertyChanged
{
    private ObservableCollection<T> _items = new ObservableCollection<T>();
    public ObservableCollection<T> items
    {
        get { return _items; }
        set
        {
            _items = value;
            OnPropertyChanged();
        }
    }

    public event PropertyChangedEventHandler PropertyChanged;
    protected virtual void OnPropertyChanged([CallerMemberName] string propertyName = null)
    {
        PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));
    }
}

CONTENT PAGE:

irlm.azure.viewModels.viewModel<irlm.azure.models.golfClub> golfClubs = new azure.viewModels.viewModel<azure.models.golfClub>();
irlm.azure.services.service<irlm.azure.models.golfClub> dc = new azure.services.service<azure.models.golfClub>();
ListView list;
Entry txt = new Entry();

private async void BtnAdd_Clicked(object sender, EventArgs e)
{
   var golfCourse = await dc.update(new irlm.azure.models.golfClub { name = txt.Text });
   golfClubs.items.Add(golfCourse);
}

private async void BtnUpdate_Clicked(object sender, EventArgs e)
{
    var index = golfClubs.items.IndexOf(list.SelectedItem as irlm.azure.models.golfClub);
    var item = (irlm.azure.models.golfClub)list.SelectedItem;
    item.name = txt.Text;
    await dc.update(item);
    golfClubs.items[index] = item;
}

private async void BtnRemove_Clicked(object sender, EventArgs e)
{
    var item = (irlm.azure.models.golfClub)list.SelectedItem;
    await dc.delete(item);
    golfClubs.items.Remove((irlm.azure.models.golfClub)list.SelectedItem);
    txt.Text = "";
}