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.

Unknown's avatar

About Jesse Liberty

** Note ** Jesse is currently looking for a new position. You can learn more about him at https://jesseliberty.bio Thank you. 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, is now available wherever you buy your books. Liberty was a Team Lead and Senior Software Engineer for various corporations, 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 13 year Microsoft MVP.
This entry was posted in API, Essentials. Bookmark the permalink.

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

← Older Comments
Newer Comments →
  2. ljubiti se's avatar ljubiti se says:
    July 25, 2025 at 10:55 am

    vykřiknout a říct, že mě opravdu baví číst vaše příspěvky na blogu.

  3. rabljeni ženski čevlji's avatar rabljeni ženski čevlji says:
    July 24, 2025 at 5:29 am

    الاستمرار في توجيه الآخرين.|Ahoj, věřím, že je to vynikající blog. Narazil jsem na něj;

  4. criar uma conta binance's avatar criar uma conta binance says:
    July 24, 2025 at 4:37 am

    Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.

  5. kuukautishousut's avatar kuukautishousut says:
    July 23, 2025 at 12:33 pm

    |Hello to all, for the reason that I am actually keen of

  6. Utwórz konto na Binance's avatar Utwórz konto na Binance says:
    July 23, 2025 at 12:39 am

    I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

  7. дамско бельо's avatar дамско бельо says:
    July 21, 2025 at 8:05 am

    reading this weblog’s post to be updated daily.

  8. γυναικεία εσώρουχα's avatar γυναικεία εσώρουχα says:
    July 19, 2025 at 11:22 am

    gruppe? Der er mange mennesker, som jeg tror virkelig ville

  9. μεταχειρισμένα γυναικεία παπούτσια's avatar μεταχειρισμένα γυναικεία παπούτσια says:
    July 17, 2025 at 5:59 am

    مرحبًا، أعتقد أن هذه مدونة ممتازة. لقد عثرت عليها بالصدفة ;

  10. begagnade damskor's avatar begagnade damskor says:
    July 16, 2025 at 6:27 am

    This design is incredible! You definitely know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Fantastic job. I really loved what you had to say, and more than that, how you presented it. Too cool!

  11. 슬롯추천's avatar 슬롯추천 says:
    July 14, 2025 at 5:56 pm

    Keep on working, great job!

  12. hacer el amor's avatar hacer el amor says:
    July 10, 2025 at 1:40 am

    Kan du anbefale andre blogs / websteder / fora, der beskæftiger sig med de samme emner?

  13. Открыть учетную запись в binance's avatar Открыть учетную запись в binance says:
    July 8, 2025 at 8:31 pm

    Thank you, your article surprised me, there is such an excellent point of view. Thank you for sharing, I learned a lot. https://accounts.binance.com/kz/register-person?ref=DB40ITMB

  14. mutandine usate in vendita's avatar mutandine usate in vendita says:
    July 7, 2025 at 12:41 am

    It contains fastidious material.|I think the admin of this website is actually working hard in favor of his site,

  15. idea regalo ragazzo 12 anni's avatar idea regalo ragazzo 12 anni says:
    June 28, 2025 at 10:41 am

    magnificent issues altogether, you simply received a new reader.What would you recommend about your submit that you just made some days in the past?Any certain?

  16. Crea un account binance's avatar Crea un account binance says:
    June 11, 2025 at 7:11 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?

  17. 토토사이트 모음's avatar 토토사이트 모음 says:
    June 8, 2025 at 4:26 am

    The blogs you produce are really of good quality. I love to read your writings and shall come again to check out the latest posts. 카지노사이트 추천

  18. 토토사이트's avatar 토토사이트 says:
    June 8, 2025 at 4:25 am

    You have done a great job. I will definitely dig it and personally recommend to my friends. I am confident they will be benefited from this site. Feel free to visit my website, thank you!토토사이트

  19. 토토사이트's avatar 토토사이트 says:
    June 8, 2025 at 4:25 am

    I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. Feel free to visit my website, thank you!
    파워볼사이트

  20. 슬롯사이트's avatar 슬롯사이트 says:
    June 8, 2025 at 4:25 am

    Yeah! This is very interesting post. I look forward for seeking more on your website. Feel free to visit my website, thank you!파워볼사이트

  21. https://www.casinositezone.com/'s avatar https://www.casinositezone.com/ says:
    June 8, 2025 at 4:24 am

    Captivating post. I Have Been contemplating about this issue, so an obligation of appreciation is all together to post. Completely cool post.It ‘s greatly extraordinarily OK and Useful post. Feel free to visit my website, thank you!
    파워볼사이트

  22. 바카라사이트's avatar 바카라사이트 says:
    June 8, 2025 at 4:24 am

    Your work is great, and I appreciate it. I look forward to reading more useful blogs from you. Thank you for providing us with such valuable information. Feel free to visit my website, thank you!신용카드현금화

  23. 소액결제 현금화's avatar 소액결제 현금화 says:
    June 8, 2025 at 4:24 am

    Excellent item. Very interesting over study. I actually adulate toward study this a polite portion. Thanks! maintenance rocking. 안전놀이터

  24. 토토사이트's avatar 토토사이트 says:
    June 8, 2025 at 4:23 am

    Thank you for posting such a great article! I found your website perfect for my needs. Feel free to visit my website, thank you!카지노사이트

← Older Comments
Newer Comments →

Leave a Reply

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