Hello everyone I am learning Azure, So after finishing my XamContact app, to work perfectly with SQLite I decided to Integrate Azure, I already did all the CRUD operation methods, but I get an error when trying to insert in the People table ] 1 ] 1 As you can see I have a People table, but for some reason, when trying to get something out via Postman, I get an error https://github.com/eduardoagr/XamContact // here is my code So I don't know if I am calling the wrong table here is my ASP web https://github.com/eduardoagr/Azure What I don't understand is that if my table is name people, why if I put people in Postman it doesn't get it, but if I put http://xamxontacts.azurewebsites.net/tables/person?ZUMO-API-VERSION=2.0.0 I can get If you see, I have a people table

You're using Entity Framework migrations to create/update the database schema; https://github.com/eduardoagr/AzureBackEnd/blob/729cf33c16849ebeddc5c072a1f35162784c8db0/ZUMOAPPNAMEService/App_Start/Startup.MobileApp.cs#L26 . var migrator = new DbMigrator(new Migrations.Configuration()); migrator.Update(); It will pluralize Dto's to table names; check out this blog post . However, what's odd is when checking your repo, you don't have a "Person"/"People" object in the context, it's called contacts . I even checked your migrations and the table created is Contacts . You also have ContactController in the PersonController filename. It's not decorated with [MobileAppController] which may affect offline sync but should be fine for making request from Postman. Instead of person/people, try making the request to /contacts and see if you still get the error. If you still get an error, then how did you create the database to begin with?

Intergrate Azure with xamarin table Error

Accepted answer

Ryan Hill 25,476 Reputation points Microsoft Employee

2021-04-02T22:50:24.067+00:00
You're using Entity Framework migrations to create/update the database schema; https://github.com/eduardoagr/AzureBackEnd/blob/729cf33c16849ebeddc5c072a1f35162784c8db0/ZUMOAPPNAMEService/App_Start/Startup.MobileApp.cs#L26.

var migrator = new DbMigrator(new Migrations.Configuration()); migrator.Update();

It will pluralize Dto's to table names; check out this blog post. However, what's odd is when checking your repo, you don't have a "Person"/"People" object in the context, it's called contacts. I even checked your migrations and the table created is Contacts. You also have ContactController in the PersonController filename. It's not decorated with [MobileAppController] which may affect offline sync but should be fine for making request from Postman. Instead of person/people, try making the request to /contacts and see if you still get the error. If you still get an error, then how did you create the database to begin with?
Please sign in to rate this answer.
Eduardo Gomez 1 Reputation point

2021-04-02T22:55:16.937+00:00

Yes I change it now and did a little console application to try it out, and it works perfectly I do not understand however why when checking the database, I have to put Contact instead of contacts if my DB in azure is name contracts

Eduardo Gomez 1 Reputation point

2021-04-02T23:00:40.427+00:00

by the way, if you do this is potman, it will work

http://xamxontacts.azurewebsites.net/tables/contact?ZUMO-API-VERSION=2.0.0

I made this console app, just to tested it, and works fine

using AzureTest;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Net.Http;

const string Url = "http://xamxontacts.azurewebsites.net/tables/contact?ZUMO-API-VERSION=2.0.0";

using (HttpClient client = new HttpClient()) {

var request = await client.GetAsync(Url); if (request.IsSuccessStatusCode) { var content = await request.Content.ReadAsStringAsync(); var res = JsonConvert.DeserializeObject<List<Contacts.Contact>>(content); foreach (var item in res) { Console.WriteLine(item.name); } }

}

but when I go to Xamarin, it doesn't read, or add, or update or delete

Eduardo Gomez 1 Reputation point

2021-04-02T23:02:17.19+00:00

the database was created by Microsoft, is in the azure getting started github

JessieZhang-MSFT 7,701 Reputation points Microsoft Vendor

2021-04-05T08:54:43.097+00:00

Does the application in the github you posted is the latest? We will try to download it and test ourself.

Eduardo Gomez 1 Reputation point

2021-04-05T12:37:38.47+00:00

Yes the xamarinn App is the latest

Eduardo Gomez 1 Reputation point

2021-04-06T09:35:14.457+00:00

Did you look at my code?

How can I insert in my contactable on Azure?
Sign in to comment

Intergrate Azure with xamarin table Error

0 additional answers