Where(c => c.fixturetype = "Spot" & c.spotlist_location = "3").OrderByDescending(x => x.createddate).ToEnumerableAsync() Where(x => x.spotlist_location = "1" || x.spotlist_location = "2" || x.spotlist_location = "3") IEnumerable requirements = await requirementsTable Here is the method for getting the data from the database public async Task> GetRequirementsSpotAsync(bool syncItems = false) if I remove ALL the conditions from the Linq method in my app it still only returns about 17 rows of data from a table that has a few hundred. SQL Where Statement where (spotlist_location = '1' or spotlist_location = '2' or spotlist_location = '3') and fixturetype = 'spot' and requirementstatus = 'open' and private_check = 'false'Īt the mobile side there seems to be data missing or not there. The query works perfectly when selecting the data using SSMS Where(x => x.open = true) I would expect to see 3 results. The problem I am having is that if I enter a condition like the above. I have a view that it looks at to get its data and then at the client side I run some conditions against the returned collection for example. The mobile app uses a backend service to read the datavia table apis. Both the site and the mobile app are hosted on Azure and read from the same table in the same Azure database. I am having major problems getting data that I show on my website to match the data my Xamarin Forms mobile app is showing in it's ListView.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |