New Series: Creating APIs in .NET

While I’m still happily ensconced at CNH Industrial, I have changed my job. I’m no longer writing mobile applications (for the first time in about 7 years!) but rather am writing APIs using ASP.NET Core and C#. -The plan is to have a book on creating APIs (how-to, best practices, patterns, etc.) next year. In the interim, I’ll be writing a series of blog posts covering such topics as how to get started, software and tools you’ll need, REST, and much more.

As part of this series, I’ll create a dead-simple real-world example of a car selling and buying application, suggested by Daniel Brevitt (technical editor of .NET MAUI For C# Programmers). This application will consist of four major parts:

  • The backend SQL Server database
  • The front end for administrators (for inventory, etc.)
  • The front end for customers (for buying or selling)
  • The API that connects the front end to the back end

We’ll create a very simple SQL database using SQL Server and SSMS, and take advantage of Dapper: a simple ORM (Object Relational Model). We will not cover Entity Framework as our focus will be on the APIs, not the back end.

Similarly, the front end will be a very simple application — though at first I’ll simply use Postman rather than building out the front end. In fact, given how important and powerful Postman is, I may never get around to building a real front-end. Getting familiar with the Postman is more important for our purposes.

We will build three types of APIs

  • Traditional APIs built using controllers in ASP.NET Core and .NET 7/8
  • Minimal APIs
  • Azure Functions

My focus in the first posts will be on the first two types, so that we can work locally without having to use Azure for now (there are tools for working with Azure functions locally, but we’ll hold off on that). In fact, we’ll create such a simple database that you can recreate it locally (and I’ll put all the code for this series up on GitHub).

For these posts, I anticipate developing on Windows using:

  • Visual Studio 2022
  • C# – probably nothing more advanced than C# 7 or 8, though bits of later versions may appear from time to time
  • SQL Server (latest)
  • SQL Server Management Studio (SSMS) that comes with SQL Server
  • Postman (latest)
  • Dapper (latest)
  • AutoMapper

All of the software we’ll be using is free (the community editions are fine).

In the next post I’ll create the database and its preliminary tables.

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.

762 Responses to New Series: Creating APIs in .NET

  1. บทความนี้ อ่านแล้วเพลินและได้สาระ ครับ
    ผม เพิ่งเจอข้อมูลเกี่ยวกับ หัวข้อที่คล้ายกัน
    ดูต่อได้ที่ เกมสล็อต
    เผื่อใครสนใจ
    เพราะอธิบายไว้ละเอียด
    ขอบคุณที่แชร์ บทความคุณภาพ นี้
    และหวังว่าจะมีข้อมูลใหม่ๆ มาแบ่งปันอีก

  2. Thomasblari's avatar Thomasblari says:

    Ordering medications online is very convenient.
    You can browse at any hour with no stepping out of home.
    Online pharmacies let you quickly check prices and locate the lowest price.
    Your order are shipped straight to your doorstep, cutting time and hassle.
    iMedix clinic directory
    There’s no need to wait in long queues at a brick-and-mortar store.
    When dealing with chronic illnesses, auto reorders make therapy hassle‑free.
    In short, online ordering for medicine saves your time and peace of mind.

  3. Thomasblari's avatar Thomasblari says:

    Getting medications online is incredibly handy.
    It’s possible to shop 24/7 with no leaving home.
    Online pharmacies let you easily compare prices and find the lowest deal.
    The meds are shipped straight to your door, cutting time and effort.
    nizagara uses
    There is no requirement to stand in long lines at a local pharmacy.
    For long-term conditions, auto refills make treatment stress‑free.
    To sum up, online shopping for meds preserves your time and energy.

  4. Thomasblari's avatar Thomasblari says:

    Buying medications online is extremely convenient.
    You can shop at any hour without leaving your house.
    Online drugstores allow you to easily check costs and locate the best price.
    The order are sent directly to your address, cutting time and effort.
    CYP3A4 inhibitors sildenafil
    There is no requirement to wait in annoying queues at a brick-and-mortar store.
    When dealing with chronic illnesses, auto reorders make treatment stress‑free.
    Overall, digital ordering for medicine preserves your time and energy.

  5. Randynek's avatar Randynek says:

    https://fleximedsindia.shop/# top 10 pharmacies in india

  6. ShanepiliA's avatar ShanepiliA says:

    The clarity of your writing style makes a huge difference when dealing with information like this, and I truly appreciate how you managed to keep the focus entirely on the core details from the beginning to the very end.

    site de paris sportif hors arjel

  7. winpot's avatar winpot says:

    I couldn’t refrain from commenting. Well written!

  8. OctavioAmoub's avatar OctavioAmoub says:

    Easy North RX: Easy North RX – Easy North RX

  9. ShanepiliA's avatar ShanepiliA says:

    The way this post is written makes the discussion feel well explained, interesting, and easygoing while also keeping the topic easy for readers to follow closely.

    casino en ligne avec retrait immediat

  10. JamesSog's avatar JamesSog says:

    MexiCare Direct: buy drugs online – pharmacy mexico online

  11. LhanepiliA's avatar LhanepiliA says:

    Thank you for sharing these thoughtful and balanced observations. The neutral presentation makes it extremely easy to process the information and understand the big picture.

    casino en ligne avec retrait instantane

  12. OctavioAmoub's avatar OctavioAmoub says:

    Easy North RX: Easy North RX – canadian pharmacy ed medications

  13. JamesSog's avatar JamesSog says:

    india pharmacy: Online medicine home delivery – top-rated online pharmacies

  14. EarnestCor's avatar EarnestCor says:

    It is always a pleasant surprise to come across an article that delivers precisely what it promises. Your unbiased breakdown of the facts is both refreshing and incredibly useful, providing a solid foundation for anyone interested in learning more.

    site de paris sportif hors arjel

  15. Jerrywex's avatar Jerrywex says:

    Easy North RX Easy North RX Easy North RX

  16. Josephned's avatar Josephned says:

    ivermectin nz Stromectol ivermectin

  17. Josephned's avatar Josephned says:

    ivermectin lotion price Institute for Clinical Pharmacology & Safety ivermectin cost canada

  18. ShanepiliA's avatar ShanepiliA says:

    It is refreshing to read something that is just straightforward and informative, without any unnecessary fluff, and I wanted to make sure I left a comment to acknowledge the solid effort that went into producing this written material.

    купить inmode Plus/Forma

  19. Rodneybox's avatar Rodneybox says:

    liraglutide price us obesity science

  20. TimothySet's avatar TimothySet says:

    is rybelsus a glp-1 AMRI

  21. Rodneybox's avatar Rodneybox says:

    semaglutide and thyroid liraglutide

  22. BrianTed's avatar BrianTed says:

    us obesity science https://usobesityscience.org/tirzepatide-analysis/ liraglutide price

  23. mood gummies's avatar mood gummies says:

    A CBD balm from this brand has a effortless, equable consistency that spreads easily. The container is consolidated and travel-friendly, and the lid closes securely. The scent is incandescence and botanical, which makes it pleasant to camouflage b confine nearby.

  24. BrianTed's avatar BrianTed says:

    Advancing Clinical Research in Metabolic Health and Weight Management https://usobesityscience.org/liraglutide-studies/ does blue cross blue shield cover rybelsus

  25. BrianTed's avatar BrianTed says:

    liraglutide https://usobesityscience.org/glp-1-agonists/ how do you take rybelsus

  26. Registrera's avatar Registrera says:

    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?

  27. rich711's avatar rich711 says:

    This is really interesting, You are a very skilled blogger. I have joined your rss feed and look forward to seeking more of your excellent post. Also, I have shared your site in my social networks!

  28. IsmaelNiz's avatar IsmaelNiz says:

    I truly enjoy how this post connects several thoughtful points in such a balanced and thoughtful way, because it creates room for different opinions while still keeping the discussion active, insightful, simple to follow, and genuinely worth reading for anyone reading through it carefully.

    free spins no deposit

  29. SamuelVef's avatar SamuelVef says:

    The flavor options for the sake of these CBD gummies and https://www.nothingbutcanna.net/products/mood-gummies are impressive. Each wedge tastes logical degree than overly counterfeit, and the nature is pleasantly chewy. The crock seals tensely, which keeps them alternative and easy as pie to aggregate for longer periods.

  30. hiteBize's avatar hiteBize says:

    На этом конкретном сайте представлена полезная информация.
    Здесь можно найти немало полезного для решения задач.
    Данный ресурс поможет освоить в разных темах.
    Советуем подробно ознакомиться с представленные здесь данные.
    https://telegra.ph/Moncler-12-25

  31. hiteBize's avatar hiteBize says:

    На этом конкретном ресурсе содержится полезная информация.
    На этом портале вы сможете найти много ценного для своего развития.
    Данный источник способен помочь освоить в разных вопросах.
    Предлагаем внимательно ознакомиться с представленные на этом сайте данные.
    https://sites.google.com/view/brand-history/dior

  32. TimothyMic's avatar TimothyMic says:

    https://mensrxguide.org/# Cialis 20mg price

  33. Kennethcrame's avatar Kennethcrame says:

    Buy Tadalafil 10mg MensRxGuide – Tadalafil price

  34. SamuelVef's avatar SamuelVef says:

    A CBD balm and https://www.nothingbutcanna.net/products/indica-gummies from this maker has a orderly, even consistency that spreads easily. The container is consolidated and travel-friendly, and the lid closes securely. The smell is light and botanical, which makes it pleasant to commemorate last nearby.

  35. ClintSig's avatar ClintSig says:

    Cheap Viagra 100mg Cheap Viagra 100mg – sildenafil 50 mg price

  36. TravisBub's avatar TravisBub says:

    The features and color of this best mushroom gummies look entirely and cultured, with no cloudiness or residue. The nerve pours smoothly, and the cap seals tightly. Inclusive, it feels like a thoughtfully made commodity designed with je sais quoi in mind.

  37. Jessegaf's avatar Jessegaf says:

    http://liraglutideglp1.com/# liraglutide fast delivery

  38. JoshuaNet's avatar JoshuaNet says:

    cheap liraglutide LiraglutideGlp1 glp-1

  39. IsmaelNiz's avatar IsmaelNiz says:

    Hello, for all time i used to check blog posts here in the early hours in the daylight, since i enjoy to gain knowledge of more and more.
    บาคาร่า

  40. RogerEmbow's avatar RogerEmbow says:

    ivermectin uk ivermectin generic name ivermectin 9 mg

  41. jydoll's avatar jydoll says:

    ラブドール 予想よりも小さいラブドールのガイド別名通常よりも小さいセックス人形、リトルセックス人形

  42. RogerEmbow's avatar RogerEmbow says:

    Viagra online price Sildenafil Vip buy viagra here

Leave a Reply

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