Styjun

I am just starting asp.net Core 2.0 web api. Please extend your help.

I have successfully deployed the asp.net WebApi app to Local IIS and
I have created a database in Sql Server 2017 (free version) with below code.

problem: status 500 internal server error when I do a post with PostMan

 1) in StartUp.cs with ConnectionString:

 public void ConfigureServices(IServiceCollection services)
 
 services.AddMvc();

 services.AddDbContext<ContactContext>(option => option.UseSqlServer(Configuration.GetConnectionString("Default")));
 


 2) connection string in appsettings.json

 "connectionstrings": 
 "Default": "Server = .\SQL2017Express; Database = ContactDB; Integrated Security = True;"
 


 **The Problems Encountered:** 

 problem: status 500 internal server error when I do a post with PostMan 

 Post : http://192.168.1.8:8989/api/contacts

 Json Data for the Body in PostMan:
 
 "FirstName" : "John",
 "LastName" : "David",
 "MobilePhone" : "123456789"
 

// controller
 [Produces("application/json")]
 [Route("api/[controller]")]
 public class ContactsController : Controller
 
 public IContactRepository ContactsRepo get; set; 

 public ContactsController(IContactRepository _repo)
 
 ContactsRepo = _repo;
 

 [HttpGet]
 public async Task<IActionResult> GetAll()
 
 var contactList = await ContactsRepo.GetAll();
 return Ok(contactList);
 

 [HttpGet("id", Name = "GetContacts")]
 public async Task<IActionResult> GetById(string id)
 
 var item = await ContactsRepo.Find(id);
 if (item == null)
 
 return NotFound();
 
 return Ok(item);
 

 [HttpPost]
 public async Task<IActionResult> Create([FromBody] Contacts item)
 
 if (item == null)
 
 return BadRequest();
 
 await ContactsRepo.Add(item);
 return CreatedAtRoute("GetContacts", new Controller = "Contacts", id = item.MobilePhone , item);
 

 [HttpPut("id")]
 public async Task<IActionResult> Update(string id, [FromBody] Contacts item)
 
 if (item == null)
 
 return BadRequest();
 
 var contactObj = await ContactsRepo.Find(id);
 if (contactObj == null)
 
 return NotFound();
 
 await ContactsRepo.Update(item);
 return NoContent();
 

 [HttpDelete("id")]
 public async Task<IActionResult> Delete(string id)
 
 await ContactsRepo.Remove(id);
 return NoContent();
 
 

I have tried both type of connection string:

a)
"connectionstrings": 
"Default": "Server = .\SQL2017Express; Database = ContactDB; Integrated Security = True;"
,
b)
"connectionstrings": 
"Default": "Server = .\SQL2017Express; Database = ContactDB; User Id=sa; Password=xxxxx ; Integrated Security = True;"
,

Looks to me like you have an issue connecting to the SQL instance. Unless you have more than one instance of SQL server running you would best un-install the software and install it as the default instance. This just makes configurations so much easier.

If you have SSMS (Sql Server Management Studio) installed on your webserver then open and type select @@servername this gives the name of your actual instance.

You can also see the name in the service, I have a default instance, hence you see no name

Please make sure you know the performance and size limitations of SQL server express before you deploy this too production.

Have you had a look at SQL Server configuration manager (you may need to install it)

You need to make sure that if you're not using TCP but DMA or Pipes to use the proper connection string; have you considered:

\<computer_name>pipeMSSQL$<instance_name>

Have a look at this URL.