{"Message":"An error has occurred."}

Question

Hello people.
I created a database on Azure and a web API that is already posted on Azure. The Web API runs normally, however when I try to perform a GET with the URL of a specific table, the following error appears: {"Message": "An error has occurred."}
Please, I'm desperate

Answer 1

Models/Contesto.cs

namespace WebApplication1
{
using System;
using System.Data.Entity;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;

public partial class Contexto : DbContext
{
    public Contexto()
        : base("name=Contexto")
    {
    }

    public virtual DbSet<coordenacao> coordenacao { get; set; }
    public virtual DbSet<demanda> demanda { get; set; }
    public virtual DbSet<organizacao> organizacao { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<coordenacao>()
            .Property(e => e.codigo_coord)
            .IsUnicode(false);

        modelBuilder.Entity<coordenacao>()
            .Property(e => e.municipio)
            .IsUnicode(false);

        modelBuilder.Entity<coordenacao>()
            .Property(e => e.uf)
            .IsUnicode(false);

        modelBuilder.Entity<coordenacao>()
            .Property(e => e.email_coord)
            .IsUnicode(false);

        modelBuilder.Entity<coordenacao>()
            .HasMany(e => e.demanda)
            .WithRequired(e => e.coordenacao)
            .HasForeignKey(e => e.cod_coord)
            .WillCascadeOnDelete(false);

        modelBuilder.Entity<coordenacao>()
            .HasMany(e => e.organizacao)
            .WithRequired(e => e.coordenacao)
            .HasForeignKey(e => e.cod_coo)
            .WillCascadeOnDelete(false);

        modelBuilder.Entity<demanda>()
            .Property(e => e.cod_coord)
            .IsUnicode(false);

        modelBuilder.Entity<demanda>()
            .Property(e => e.cod_org)
            .IsUnicode(false);

        modelBuilder.Entity<demanda>()
            .Property(e => e.organizacao)
            .IsUnicode(false);

        modelBuilder.Entity<demanda>()
            .Property(e => e.municipio_demanda)
            .IsUnicode(false);

        modelBuilder.Entity<demanda>()
            .Property(e => e.rua)
            .IsUnicode(false);

        modelBuilder.Entity<demanda>()
            .Property(e => e.bairro)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .Property(e => e.codigo_org)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .Property(e => e.cod_coo)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .Property(e => e.organizacao1)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .Property(e => e.cep)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .Property(e => e.rua)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .Property(e => e.bairro)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .Property(e => e.telefone)
            .IsUnicode(false);

        modelBuilder.Entity<organizacao>()
            .HasMany(e => e.demanda)
            .WithRequired(e => e.organizacao1)
            .HasForeignKey(e => e.cod_org)
            .WillCascadeOnDelete(false);
    }
}

}

Answer 2

Models/Contexto.cs

namespace WebApplication1
{
    using System;
    using System.Data.Entity;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Linq;

    public partial class Contexto : DbContext
    {
        public Contexto()
            : base("name=Contexto")
        {
        }

        public virtual DbSet<coordenacao> coordenacao { get; set; }
        public virtual DbSet<demanda> demanda { get; set; }
        public virtual DbSet<organizacao> organizacao { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<coordenacao>()
                .Property(e => e.codigo_coord)
                .IsUnicode(false);

            modelBuilder.Entity<coordenacao>()
                .Property(e => e.municipio)
                .IsUnicode(false);

            modelBuilder.Entity<coordenacao>()
                .Property(e => e.uf)
                .IsUnicode(false);

            modelBuilder.Entity<coordenacao>()
                .Property(e => e.email_coord)
                .IsUnicode(false);

            modelBuilder.Entity<coordenacao>()
                .HasMany(e => e.demanda)
                .WithRequired(e => e.coordenacao)
                .HasForeignKey(e => e.cod_coord)
                .WillCascadeOnDelete(false);

            modelBuilder.Entity<coordenacao>()
                .HasMany(e => e.organizacao)
                .WithRequired(e => e.coordenacao)
                .HasForeignKey(e => e.cod_coo)
                .WillCascadeOnDelete(false);

            modelBuilder.Entity<demanda>()
                .Property(e => e.cod_coord)
                .IsUnicode(false);

            modelBuilder.Entity<demanda>()
                .Property(e => e.cod_org)
                .IsUnicode(false);

            modelBuilder.Entity<demanda>()
                .Property(e => e.organizacao)
                .IsUnicode(false);

            modelBuilder.Entity<demanda>()
                .Property(e => e.municipio_demanda)
                .IsUnicode(false);

            modelBuilder.Entity<demanda>()
                .Property(e => e.rua)
                .IsUnicode(false);

            modelBuilder.Entity<demanda>()
                .Property(e => e.bairro)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .Property(e => e.codigo_org)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .Property(e => e.cod_coo)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .Property(e => e.organizacao1)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .Property(e => e.cep)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .Property(e => e.rua)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .Property(e => e.bairro)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .Property(e => e.telefone)
                .IsUnicode(false);

            modelBuilder.Entity<organizacao>()
                .HasMany(e => e.demanda)
                .WithRequired(e => e.organizacao1)
                .HasForeignKey(e => e.cod_org)
                .WillCascadeOnDelete(false);
        }
    }
}

Answer 3

Controllers/coordenacaosController.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using System.Web.Http.Description;
using WebApplication1;

namespace WebApplication1.Controllers
{
    public class coordenacaosController : ApiController
    {
        private Contexto db = new Contexto();

        // GET: api/coordenacaoseT
        public IQueryable<coordenacao> Getcoordenacao()
        {
            return db.coordenacao;
        }

        // GET: api/coordenacaos/5
        [ResponseType(typeof(coordenacao))]
        public IHttpActionResult Getcoordenacao(string id)
        {
            coordenacao coordenacao = db.coordenacao.Find(id);
            if (coordenacao == null)
            {
                return NotFound();
            }

            return Ok(coordenacao);
        }

        // PUT: api/coordenacaos/5
        [ResponseType(typeof(void))]
        public IHttpActionResult Putcoordenacao(string id, coordenacao coordenacao)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            if (id != coordenacao.codigo_coord)
            {
                return BadRequest();
            }

            db.Entry(coordenacao).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!coordenacaoExists(id))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }

            return StatusCode(HttpStatusCode.NoContent);
        }

        // POST: api/coordenacaos
        [ResponseType(typeof(coordenacao))]
        public IHttpActionResult Postcoordenacao(coordenacao coordenacao)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            db.coordenacao.Add(coordenacao);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (coordenacaoExists(coordenacao.codigo_coord))
                {
                    return Conflict();
                }
                else
                {
                    throw;
                }
            }

            return CreatedAtRoute("DefaultApi", new { id = coordenacao.codigo_coord }, coordenacao);
        }

        // DELETE: api/coordenacaos/5
        [ResponseType(typeof(coordenacao))]
        public IHttpActionResult Deletecoordenacao(string id)
        {
            coordenacao coordenacao = db.coordenacao.Find(id);
            if (coordenacao == null)
            {
                return NotFound();
            }

            db.coordenacao.Remove(coordenacao);
            db.SaveChanges();

            return Ok(coordenacao);
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }

        private bool coordenacaoExists(string id)
        {
            return db.coordenacao.Count(e => e.codigo_coord == id) > 0;
        }
    }
}

Answer 4

@Washington Rascaglia Gularte ,

Make sure you API app service has your Contexto connection string that's in your web.config.

Answer 5

Removing the Json format I got two different errors when viewing my table.

Locally:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<Error>
<Message>Ocorreu um erro.</Message>
<ExceptionMessage>O tipo 'ObjectContent`1' não pôde serializar o corpo da resposta para o tipo de conteúdo 'application/xml; charset=utf-8'.</ExceptionMessage>
<ExceptionType>System.InvalidOperationException</ExceptionType>
<StackTrace/>
<InnerException>
<Message>Ocorreu um erro.</Message>
<ExceptionMessage>O tipo 'System.Data.Entity.DynamicProxies.coordenacao_A5D9416F776FBC682AD084B67B3B5904EB346CA769FA87CBA5ED0C77C6943A3C' com nome de contrato de dados 'coordenacao_A5D9416F776FBC682AD084B67B3B5904EB346CA769FA87CBA5ED0C77C6943A3C:http://schemas.datacontract.org/2004/07/System.Data.Entity.DynamicProxies' não é esperado. Considere usar um DataContractResolver se você estiver usando um ou DataContractSerializer adicione quaisquer tipos não conhecidos estaticamente à lista de tipos conhecidos - por exemplo, usando o atributo KnownTypeAttribute ou adicionando-os à lista de tipos conhecidos transmitidos para o serializador.</ExceptionMessage>
<ExceptionType>System.Runtime.Serialization.SerializationException</ExceptionType>
<StackTrace> em System.Runtime.Serialization.XmlObjectSerializerWriteContext.SerializeAndVerifyType(DataContract dataContract, XmlWriterDelegator xmlWriter, Object obj, Boolean verifyKnownType, RuntimeTypeHandle declaredTypeHandle, Type declaredType) em System.Runtime.Serialization.XmlObjectSerializerWriteContext.SerializeWithXsiType(XmlWriterDelegator xmlWriter, Object obj, RuntimeTypeHandle objectTypeHandle, Type objectType, Int32 declaredTypeID, RuntimeTypeHandle declaredTypeHandle, Type declaredType) em System.Runtime.Serialization.XmlObjectSerializerWriteContext.InternalSerialize(XmlWriterDelegator xmlWriter, Object obj, Boolean isDeclaredType, Boolean writeXsiType, Int32 declaredTypeID, RuntimeTypeHandle declaredTypeHandle) em WriteArrayOfcoordenacaoToXml(XmlWriterDelegator , Object , XmlObjectSerializerWriteContext , CollectionDataContract ) em System.Runtime.Serialization.CollectionDataContract.WriteXmlValue(XmlWriterDelegator xmlWriter, Object obj, XmlObjectSerializerWriteContext context) em System.Runtime.Serialization.XmlObjectSerializerWriteContext.WriteDataContractValue(DataContract dataContract, XmlWriterDelegator xmlWriter, Object obj, RuntimeTypeHandle declaredTypeHandle) em System.Runtime.Serialization.XmlObjectSerializerWriteContext.SerializeWithoutXsiType(DataContract dataContract, XmlWriterDelegator xmlWriter, Object obj, RuntimeTypeHandle declaredTypeHandle) em System.Runtime.Serialization.DataContractSerializer.InternalWriteObjectContent(XmlWriterDelegator writer, Object graph, DataContractResolver dataContractResolver) em System.Runtime.Serialization.DataContractSerializer.InternalWriteObject(XmlWriterDelegator writer, Object graph, DataContractResolver dataContractResolver) em System.Runtime.Serialization.XmlObjectSerializer.WriteObjectHandleExceptions(XmlWriterDelegator writer, Object graph, DataContractResolver dataContractResolver) em System.Runtime.Serialization.DataContractSerializer.WriteObject(XmlWriter writer, Object graph) em System.Net.Http.Formatting.XmlMediaTypeFormatter.WriteToStream(Type type, Object value, Stream writeStream, HttpContent content) em System.Net.Http.Formatting.XmlMediaTypeFormatter.WriteToStreamAsync(Type type, Object value, Stream writeStream, HttpContent content, TransportContext transportContext, CancellationToken cancellationToken) --- Fim do rastreamento de pilha do local anterior onde a exceção foi gerada --- em System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) em System.Web.Http.WebHost.HttpControllerHandler.<WriteBufferedResponseContentAsync>d__22.MoveNext()</StackTrace>
</InnerException>
</Error>

Web API:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<Error>
<Message>An error has occurred.</Message>
</Error>