APIs in .NET – Part 2 – The Database

Posted on July 25, 2023 by Jesse Liberty

As noted in part 1 of this series, I will be building an application specifically to explore building APIs. To get started, I’ll want to build a back-end database. The application we’ll be simulating is a car dealership. Customers can list a car for sale, or look through cars they might buy.

We want to keep things very simple, so we will create a single table for now: Car

Car will have six columns

  • id (int primary key)
  • make (varchar 50)
  • model (varchar 50)
  • model_year (int)
  • price (decimal)
  • deleted (int)

By marking id as primary key you ensure two things: no two cars will have the same id, and each added row will have an incremented value. The deleted column allows us to have “soft” deletes — that is, we mark a row deleted but do not remove it from the table.

We can now insert a few rows:

insert into car
(make, model, model_year, price, deleted)
values ('Subaru', 'Imprezza', 2024 ,35500, 0),
('Subaru','Outback',2024,42000, 0),
('Prius','C',2022,25000, 0)

Note: I highly recommend the book SQL Pocket Guide (O’Reilly, Alice Zhao) for looking up how to do all the SQL operations I’ll show in these blog entries.

With this table, we can create endpoints for the CRUD (Create Read Update Delete) operations and more (e.g., obtaining a list of available vehicles).

In the next post, we’ll build our first endpoint to get a list of available cars.

About Jesse Liberty

Jesse Liberty has three decades of experience writing and delivering software projects and is the author of 2 dozen books and a couple dozen online courses. His latest book, Building APIs with .NET will be released early in 2025. Liberty is a Senior SW Engineer for CNH and he was a Senior Technical Evangelist for Microsoft, a Distinguished Software Engineer for AT&T, a VP for Information Services for Citibank and a Software Architect for PBS. He is a Microsoft MVP.
This entry was posted in API, Essentials. Bookmark the permalink.

111 Responses to APIs in .NET – Part 2 – The Database

← Older Comments
Newer Comments →
  11. gioielli idee regalo uomo raffinato says:
    May 18, 2025 at 1:13 pm

    When buying a swimming pool pump, your pump can have a ‘Maximum Stream Rate’ in the specifications tab.

    Reply
  15. pitsist pesu says:
    May 15, 2025 at 10:21 pm

    Esta página tem definitivamente toda a informação que eu queria sobre este assunto e não sabia a quem perguntar. Este é o meu primeiro comentário aqui, então eu só queria dar um rápido

    Reply
  16. 二手女鞋 says:
    May 15, 2025 at 4:39 pm

    Very interesting topic, regards for posting.

    Reply
  18. 出售二手内衣 says:
    May 15, 2025 at 6:20 am

    Next time I read a blog, I hope that it won’t fail me as much as this one. After all, Yes, it was my choice to read, however I really thought you would probably have something useful to talk about. All I hear is a bunch of whining about something that you could fix if you were not too busy looking for attention.

    Reply
  35. cuenta abierta en Binance says:
    May 4, 2025 at 8:56 pm

    Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?

    Reply
  45. Wuta Booty Fulashh ONLY FANS LEAKED says:
    April 28, 2025 at 3:06 pm

    Persian Doll Gia – Whos Madison – Gia Khavari Only Fans Leaked Fansly Leaks Mega Folder Download Link ( https://urbancrocspot.org/ucs-leaks-archive/ )

    Reply
  46. Lexi Doll xXx ONLY FANS LEAKED says:
    April 28, 2025 at 9:48 am

    K Zaye Only Fans Leaked Fansly Leaks Mega Folder Download Link ( https://urbancrocspot.org/ucs-leaks-archive/ )

    Reply
  47. Korina Kova ONLY FANS LEAKED says:
    April 27, 2025 at 4:26 pm

    Semaj Media FANSLY Only Fans Leaked Fansly Leaks Mega Folder Download Link ( https://urbancrocspot.org/ucs-leaks-archive/ )

    Reply
  48. Lunita Skye ONLY FANS LEAKED says:
    April 27, 2025 at 1:15 pm

    SlimAssTink – SlimGoesRounds Only Fans Leaked Fansly Leaks Mega Folder Download Link ( https://urbancrocspot.org/ucs-leaks-archive/ )

    Reply
  49. SazonDePuertoRicoINC ONLY FANS LEAKED says:
    April 26, 2025 at 9:11 pm

    Kim Lifts Only Fans Leaked Fansly Leaks Mega Folder Download Link ( https://urbancrocspot.org/ucs-leaks-archive/ )

    Reply
  50. Ms Fiiire FANSLY ONLY FANS LEAKED says:
    April 26, 2025 at 8:10 pm

    Kim Lifts Only Fans Leaked Fansly Leaks Mega Folder Download Link ( https://urbancrocspot.org/ucs-leaks-archive/ )

    Reply
← Older Comments
Newer Comments →

Leave a Reply

Your email address will not be published. Required fields are marked *