DEV Community

C# (C Sharp) CRUD Rest API using .NET 7, ASP.NET, Entity Framework, Postgres, Docker and Docker Compose

Francesco Ciulla on April 16, 2023

Let's create a CRUD Rest API in C# (or C sharp), using: .NET 7 ASP.NET (Framework for building web apps) Entity Framework (ORM) Postgres (Databa...

Read full post

VladisS-Vostok2000 • May 15 '23

// POST: api/users
  [HttpPost]
  public async Task<ActionResult<User>> PostUser(User user)
  {
    _context.Users.Add(user);
    await _context.SaveChangesAsync();

    return CreatedAtAction(nameof(GetUser), new { id = user.Id }, user);
  }

Is there expected PostUser?
return CreatedAtAction(nameof(PostUser), new { id = user.Id }, user);

Marc • Apr 17 '23

Check your code formatting. On iOS Chrome at least it’s garbled.

Francesco Ciulla • Apr 17 '23

do you mean the brackts?

Marc • Apr 17 '23

We see:

Let's create two more users, make a POST request to localhost:8080/api/users.

`json
{
"name": "bbb",
"email": "bbb@mail"
}
`

Francesco Ciulla • Apr 17 '23

oh there was a trailing backtick. solved thanks.

SikNik • Aug 5 '23

Thanks for the cool tutorial, also watched your video thanks very much!

Not sure if anyone else picked this up from the walkthrough guide on this page above, at the section where we get users? Its pointing to port 8000 which is invalid and the users only return on port 8080, which is correct in accordance with our configs...

The guide here on this page just says otherwise...

📝 Get all users
To get all users, make a GET request to localhost:8000/api/users.

The output should be something like that:

Francesco Ciulla • Nov 3 '23

oh I will check that, thank you! maybe I was using a different port on that specific part!

Bartek • Apr 20 '23

You could also add validation for User type to prevent incorrect data and reject request on start, not during writing to database. Obviously that will give you ability to check other things such as e.g. format of e-mail addresses.

Francesco Ciulla • Apr 20 '23

that would probably be a good idea

BringABlazer • Apr 19 '23

Very nice - just a question of if it is on purpose that you skipped the explanation of your docker files?

Francesco Ciulla • May 8 '23

fixed, thanks

VladisS-Vostok2000 • May 14 '23

I repeated all steps this awesome guide, but face the problem with creating a user:
MessageText: relation "users" does not exist
I fixed it renaming all colums and table to lower case, and it works.