Populate Tuple list with SQlite data Xamarin

Question

I have a Xamarin App that I primarily write in C#. In de app I've got a SQlite database in which I store an Int (ID), a string and two doubles.

I need the string and two doubles in a Tuple list.

Altohugh I figured out how to put the information in a normal list, I don't know how to put it in a Tuple.

How I populated the normal list:

protected override async void OnAppearing()
    {
        devListLoc.ItemsSource = await App.Database.GetAllLocations();
    }

How I populate Tuple without SQlite:

List list = new List<Tuple<string, double, double>>
        {
            new Tuple<string, double, double>("tesst1", 57.434180, 7.236162),
            new Tuple<string, double, double>("test2", 58.435602, 8.234298),
        };

So I want to populate the Tuple list in kindof the same way, but I can't figure out how, nor can I find the answer somewhere else.

Cheers!

Edit: The GetAllLocations task:

public Task<List<BarLoc>> GetAllLocations()
    {
        return database.QueryAsync<BarLoc>("SELECT * FROM [BarLoc]");
    }

Jason · Accepted Answer · 2017-12-15 13:24:44Z

1

using System.Linq;

var locations = await App.Database.GetAllLocations();

var tuples = (from l in locations 
              select new Tuple<string,double,double>(l.Name, l.Lat, l.Long)).ToList();

edited Dec 15, 2017 at 13:24

answered Dec 15, 2017 at 13:13

Jason

89.5k15 gold badges137 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JeroenM Over a year ago

Thanks, but it gets the following error: Could not find an implementation of the query pattern for source type 'Task<List<BarLoc>>'. 'Select' not found I added the GetAllLocations Task code in the question because thats what it's talking about. (And I forgot adding it, whoops)

Jason Over a year ago

you need to await it - I left that out of my original response

Collectives™ on Stack Overflow

Populate Tuple list with SQlite data Xamarin

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related