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. Annabelle's avatar Annabelle says:

    Paylaşım güzelmiş.
    diyarbakır escort ararken buraya denk geldim.
    İşime yaradı.
    Devamını beklerim.

    Taake a look at my website Annabelle

  2. Danielhic's avatar Danielhic says:

    Выполнение домашнего работ помогает усвоить материал, пройденный в школе.
    Это тренирует навыки независимой деятельности и поиска данных.
    Систематическое выполнение домашних заданий воспитывает чувство самодисциплины и планирования.
    Домашние задания позволяет взрослым понимать прогресс и пробелы ученика в обучении.
    Геометрия 7 класс: решения Мерзляк

  3. Danielhic's avatar Danielhic says:

    Подготовка домашних задания закрепляет темы, пройденный в классе.
    Такая практика развивает навыки независимой деятельности и обработки информации.
    Систематическое делание домашних заданий воспитывает чувство ответственности и организованности.
    Домашняя работа позволяет родителям видеть успехи и трудности ученика в учёбе.
    ГДЗ по русскому языку 2 класс (Школа России)

  4. Ulysses's avatar Ulysses says:

    Paylaşım güzelmiş.
    diyarbakır escort bayan ararmen buraya denk geldim.

    Gerekli bilgiyi aldım.
    Sağ olun.

    My homepage – Ulysses

  5. Westonfussy's avatar Westonfussy says:

    Reputation management is the deliberate process of influencing public perception of a brand or person.
    It involves actively tracking what is being said about you on the internet.
    The goal is to highlight favorable information and mitigate any damaging feedback or criticism.
    This frequently includes engaging with online reviews on different websites.
    https://forum.reallusion.com/Users/3283065/repuhouse
    A vital part is managing search engine results for relevant queries.
    Effective reputation management helps establish credibility and safeguard a strong brand image.
    Ultimately, it is an crucial practice for any contemporary business or public figure.

  6. Westonfussy's avatar Westonfussy says:

    Online reputation management is the strategic process of influencing public perception of a brand or person.
    It involves continuously monitoring what is being said about you on the internet.
    The goal is to promote favorable information and address any negative feedback or criticism.
    This often includes engaging with online reviews on various websites.
    https://lit.link/repuhouse
    A vital part is optimizing search engine listings for relevant queries.
    Effective reputation management helps establish credibility and protect a strong digital image.
    Ultimately, it is an crucial practice for any modern organization or public figure.

  7. I used to be recommended this web site by means of my cousin. I am not sure whether this put up is
    written by way of him as no one else understand such detailed approximately my trouble.
    You are wonderful! Thanks! เบทฟิก88

  8. Betflix's avatar Betflix says:

    Everything is very open with a clear explanation of the issues.

    It was really informative. Your site is extremely helpful.

    Thanks for sharing!

  9. Franksnomo's avatar Franksnomo says:

    Срочный скупка машин является всё очень популярной опцией.
    Это дает шанс владельцу быстро обрести деньги за транспорт.
    Многих подкупает отсутствие времени на долгие переговоры с покупателями.
    Компании оценивают машину на месте и называют адекватную стоимость.
    Подобный метод избавляет от хлопот с оформлением и обещает надежность сделки.
    https://beteiligung.hafencity.com/profile/kenigauto39/

  10. Franksnomo's avatar Franksnomo says:

    Срочный скупка машин является всё более популярной опцией.
    Это позволяет продавцу моментально обрести наличные за транспорт.
    Автовладельцев подкупает необходимость тратить времени на долгие переговоры с покупателями.
    Компании оценивают авто на месте и предлагают реальную цену.
    Подобный метод избавляет от хлопот с бумажной волокитой и обещает безопасность операции.
    https://www.amino.dk/members/kenigauto39/default.aspx

  11. Franksnomo's avatar Franksnomo says:

    Срочный выкуп машин является всё более востребованной опцией.
    Это позволяет владельцу моментально получить деньги за автомобиль.
    Многих подкупает отсутствие времени на долгие поиски с клиентами.
    Фирмы оценивают машину на месте и предлагают реальную цену.
    Подобный подход освобождает от сложностей с бумажной волокитой и гарантирует надежность операции.
    https://acomics.ru/-kenigauto39

  12. betflix 888's avatar betflix 888 says:

    Thank you a bunch for sharing this with all of us you really know what you are talking approximately!
    Bookmarked. Please additionally seek advice from my website =).
    We can have a link change agreement among us
    betflix 888

  13. betflix's avatar betflix says:

    My brother suggested I might like this website. He was totally right.
    This post truly made my day. You can not imagine simply how much time I had spent
    for this information! Thanks! betflix

  14. Richardquatt's avatar Richardquatt says:

    Dressing well creates a strong first impression.
    A outfit communicates loudly before a person even speak a single word.
    It boosts your personal self-esteem and mood noticeably.
    A put-together look signals professionalism in the office.
    https://a2.megakazan.ru/premiata-sneakers/
    Fashionable choices let you to showcase your unique identity.
    Others often perceive well-dressed people as more successful and trustworthy.
    Ultimately, investing in your style is an valuable step in your personal brand.

  15. Richardquatt's avatar Richardquatt says:

    Looking well projects a strong first impression.
    Your outfit communicates loudly before you actually say a single word.
    This enhances your own self-esteem and mindset significantly.
    A put-together look signals professionalism in the office.
    https://r5.balmain1.ru/7tbayk3MPWzX/
    Stylish choices allow you to showcase your individual identity.
    Others often perceive well-dressed individuals as more capable and trustworthy.
    Ultimately, investing in your wardrobe is an valuable step in yourself.

  16. Richardquatt's avatar Richardquatt says:

    Looking well creates a strong first impression.
    Your attire speaks loudly before you actually say a single word.
    It enhances your own confidence and mood noticeably.
    Your polished look signals professionalism in the workplace.
    https://n4.vladtoday.ru/wzEYHdC6spm/
    Stylish choices allow you to express your unique personality.
    Others often perceive stylish individuals as more capable and trustworthy.
    Ultimately, putting effort in your style is an investment in your personal brand.

  17. Richardquatt's avatar Richardquatt says:

    Dressing well creates a strong first impression.
    A outfit communicates volumes before a person even say a word.
    This boosts your personal self-esteem and mood noticeably.
    Your put-together appearance conveys professionalism in the workplace.
    https://r2.balmain1.ru/FUZVbF/
    Fashionable choices let you to showcase your individual identity.
    People often perceive well-dressed people as more successful and trustworthy.
    Therefore, putting effort in your style is an valuable step in yourself.

  18. Richardquatt's avatar Richardquatt says:

    Looking stylish creates a positive first impression.
    Your attire communicates volumes before a person actually speak a single word.
    It boosts your personal confidence and mindset noticeably.
    A polished look conveys competence in the office.
    https://links.mvmedia.ru/Gd72OJo/
    Fashionable clothing let you to showcase your individual identity.
    People often judge well-dressed individuals as more capable and trustworthy.
    Therefore, investing in your wardrobe is an investment in your personal brand.

  19. Katrice's avatar Katrice says:

    บทความนี้ อ่านแล้วเพลินและได้สาระ ค่ะ
    ผม เพิ่งเจอข้อมูลเกี่ยวกับ เรื่องที่เกี่ยวข้อง
    ซึ่งอยู่ที่ Katrice
    สำหรับใครกำลังหาเนื้อหาแบบนี้

    มีตัวอย่างประกอบชัดเจน
    ขอบคุณที่แชร์ คอนเทนต์ดีๆ นี้
    และหวังว่าจะได้เห็นโพสต์แนวนี้อีก

  20. Richardquatt's avatar Richardquatt says:

    Dressing stylish projects a positive first impression.
    Your attire communicates loudly before a person even speak a single word.
    It boosts your personal self-esteem and mindset significantly.
    A put-together appearance conveys competence in the office.
    https://blog.balmain1.ru/coccinelle-iskusstvo-nosit-schaste/
    Fashionable choices allow you to express your individual personality.
    Others often judge well-dressed individuals as more capable and trustworthy.
    Therefore, putting effort in your style is an investment in your personal brand.

  21. Richardquatt's avatar Richardquatt says:

    Looking well projects a positive first impression.
    Your outfit communicates loudly before you even speak a single word.
    It boosts your personal self-esteem and mindset noticeably.
    A polished look conveys professionalism in the workplace.
    https://a5.gucci1.ru/HdE2u44fZ/
    Stylish choices allow you to showcase your individual personality.
    People often judge stylish people as more successful and reliable.
    Therefore, investing in your wardrobe is an investment in your personal brand.

  22. wow388's avatar wow388 says:

    I could not resist commenting. Very well written!

  23. Richardquatt's avatar Richardquatt says:

    Looking well projects a strong first impression.
    A outfit speaks volumes before you even speak a single word.
    It boosts your personal confidence and mindset significantly.
    A polished appearance conveys professionalism in the office.
    https://z1.sochidaily.ru/7HZXC3Ul/
    Fashionable choices allow you to showcase your unique identity.
    Others often judge stylish individuals as more successful and trustworthy.
    Ultimately, putting effort in your style is an valuable step in yourself.

  24. Betflix's avatar Betflix says:

    Good post. I learn something totally new and challenging on sites I stumbleupon every day.
    It’s always useful to read articles from other authors and practice a little
    something from their websites.

  25. Richardquatt's avatar Richardquatt says:

    Looking well creates a positive first impression.
    Your attire speaks volumes before a person even say a word.
    This boosts your personal confidence and mindset significantly.
    Your put-together appearance signals professionalism in the workplace.
    https://bm4.irkpress.ru/RyQQKNVHXfZm/
    Stylish clothing let you to express your individual personality.
    Others often judge stylish people as more capable and reliable.
    Therefore, investing in your style is an investment in yourself.

  26. WilliamCig's avatar WilliamCig says:

    Premium watches continue to hold strong appeal despite the rise of modern gadgets.
    They are often seen as a symbol of status and refined taste.
    Expert workmanship plays a major role in their lasting value.
    Many luxury watches are produced using premium components.
    https://linkingdirectory.com/author/arabicbezel-87659/
    They also represent a long tradition passed down through generations.
    For collectors, these watches can serve as both practical items and collectible pieces.
    Classic aesthetics allows them to stay relevant across changing fashion trends.
    As a result, luxury watches continue to interest buyers around the world.

  27. WilliamCig's avatar WilliamCig says:

    Luxury watches continue to remain popular despite the rise of digital devices.
    They are often seen as a mark of success and refined taste.
    Craftsmanship plays a major role in their lasting value.
    Many luxury watches are produced using carefully selected materials.
    https://app.readthedocs.org/profiles/AromaCodex/
    They also represent a long tradition passed down through generations.
    For collectors, these watches can serve as both practical items and collectible pieces.
    Timeless design allows them to stay relevant across changing fashion trends.
    As a result, luxury watches continue to interest buyers around the world.

  28. Betflix's avatar Betflix says:

    This post is genuinely a good one it assists new web viewers, who are wishing for blogging.

  29. Spot on with this write-up, I truly think this web site needs a lot more attention. I’ll probably
    be returning to read through more, thanks for the
    advice!

  30. Richardquatt's avatar Richardquatt says:

    Looking well projects a strong first impression.
    A outfit communicates loudly before a person even say a word.
    This boosts your personal confidence and mindset significantly.
    A polished look signals competence in the workplace.
    https://bookmarks.balmain1.ru/0XMntcnU/
    Fashionable clothing allow you to showcase your individual personality.
    Others often perceive well-dressed people as more capable and reliable.
    Ultimately, putting effort in your style is an investment in your personal brand.

  31. betflik's avatar betflik says:

    Hello very nice blog!! Guy .. Beautiful ..
    Superb .. I will bookmark your blog and take the
    feeds also? I am satisfied to seek out so many useful info here within the put up, we’d like work out extra strategies in this regard, thank
    you for sharing. . . . . . betflik

  32. Richardquatt's avatar Richardquatt says:

    Looking stylish creates a strong first impression.
    A outfit communicates volumes before a person even speak a single word.
    It enhances your own self-esteem and mindset significantly.
    Your polished appearance signals competence in the workplace.
    https://sites.google.com/view/sumkiprada/index
    Fashionable choices allow you to express your individual personality.
    People often perceive well-dressed individuals as more successful and reliable.
    Therefore, investing in your wardrobe is an valuable step in yourself.

  33. Richardquatt's avatar Richardquatt says:

    Dressing well creates a positive first impression.
    A attire speaks loudly before a person actually say a single word.
    It enhances your personal self-esteem and mood significantly.
    A polished appearance conveys professionalism in the workplace.
    https://b.balenciager.ru/GeUvkp/
    Fashionable choices allow you to express your individual identity.
    Others often judge stylish individuals as more capable and trustworthy.
    Therefore, putting effort in your style is an investment in yourself.

  34. Richardquatt's avatar Richardquatt says:

    Dressing stylish creates a positive first impression.
    A outfit communicates loudly before you actually say a single word.
    This enhances your own confidence and mindset significantly.
    A put-together look signals professionalism in the workplace.
    https://catalogue.mvmedia.ru/NPwkFfKYT/
    Stylish clothing allow you to express your unique personality.
    Others often judge stylish people as more capable and trustworthy.
    Therefore, investing in your wardrobe is an valuable step in your personal brand.

  35. Richardquatt's avatar Richardquatt says:

    Looking well projects a positive first impression.
    Your outfit speaks loudly before a person even say a word.
    It boosts your personal confidence and mindset noticeably.
    A polished appearance conveys competence in the office.
    https://n2.sneakero.ru/ilzBW4P/
    Stylish clothing let you to express your unique identity.
    Others often perceive well-dressed people as more successful and reliable.
    Therefore, putting effort in your style is an valuable step in your personal brand.

  36. Richardquatt's avatar Richardquatt says:

    Dressing well projects a positive first impression.
    A outfit speaks loudly before you even say a single word.
    This boosts your own confidence and mindset significantly.
    Your polished look conveys professionalism in the workplace.
    https://mez.ink/lepodium
    Fashionable clothing allow you to showcase your individual personality.
    Others often perceive well-dressed individuals as more capable and trustworthy.
    Ultimately, investing in your style is an valuable step in yourself.

  37. Richardquatt's avatar Richardquatt says:

    Looking stylish projects a positive first impression.
    A outfit speaks volumes before you actually speak a word.
    It enhances your own self-esteem and mood noticeably.
    A put-together appearance signals professionalism in the office.
    https://urls.vladtoday.ru/FLi6cWT3gtn/
    Stylish clothing allow you to showcase your unique personality.
    Others often perceive well-dressed individuals as more successful and trustworthy.
    Therefore, investing in your style is an investment in yourself.

  38. Richardquatt's avatar Richardquatt says:

    Looking well projects a strong first impression.
    Your outfit speaks volumes before you even speak a single word.
    It enhances your own confidence and mindset significantly.
    A polished appearance conveys professionalism in the workplace.
    https://n1.mvmedia.ru/Tcppqxr/
    Fashionable choices let you to express your individual personality.
    People often perceive stylish people as more capable and reliable.
    Therefore, putting effort in your wardrobe is an investment in yourself.

  39. Bernd's avatar Bernd says:

    Thanks for sharing your thoughts on Van eskort bayan. Regards

    My page … Bernd

  40. Betflik's avatar Betflik says:

    Howdy! I know this is somewhat off topic but I was wondering which blog platform are you using for this website?
    I’m getting sick and tired of WordPress because I’ve had issues with hackers and I’m looking at alternatives for
    another platform. I would be great if you could point me in the direction of a good
    platform.

  41. flix888's avatar flix888 says:

    บทความนี้ มีประโยชน์มาก ค่ะ
    ผม ไปเจอรายละเอียดของ ข้อมูลเพิ่มเติม

    สามารถอ่านได้ที่ flix888
    น่าจะถูกใจใครหลายคน
    มีตัวอย่างประกอบชัดเจน
    ขอบคุณที่แชร์ คอนเทนต์ดีๆ นี้
    และอยากเห็นบทความดีๆ แบบนี้อีก

  42. thc mints's avatar thc mints says:

    I tried a hardly products from Tillmans Tranquils – indica gummies and in reality liked the entire experience. The gummies have a clean leaning, smooth texture, and accordant quality. The flavors perceive fundamental, and the portioned servings create it unreserved to settle upon what works in return you. Their packaging looks premium and entire lot feels thoughtfully made. A solid make with products that are enjoyable and reliable.

  43. Isabelle's avatar Isabelle says:

    We stumbled over here coming from a different web page and thought I
    may as well check things out. I like what I see so now i’m following you.
    Look forward to looking over your web page again.

    Feel free to surf to my blog – Isabelle

  44. 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.

  45. Получение вида на жительство в другой стране имеет большое значение.
    Этот статус даёт законную возможность на постоянное проживание в нужной державе.
    виза за минет в ОАЭ
    Такое разрешение гарантирует полный доступ к национальному здравоохранительному обслуживанию и образованию.
    Наличие вида на жительство существенно упрощает процедуру банковского обслуживания и открытия своего дела.
    В конечном счёте, данное удостоверение является важнейшим этапом к ПМЖ или даже второму гражданству.

  46. OLanepiliA's avatar OLanepiliA says:

    Amazing! Its truly remarkable article, I have got much clear idea on the topic of from this post.
    byueuropaviagraonline

  47. Stake Casino's avatar Stake Casino says:

    WOW just what I was searching for. Came here by searching
    for stake casino

  48. HaroldJousy's avatar HaroldJousy says:

    Продуманный внешний вид имеет большое значение в самовыражении.
    Она дает возможность выразить характер.
    Удачный внешний вид поддерживает самооценку.
    Одежда часто становится частью визуального контакта.
    https://bookmarks.chenews.ru/redirect.php?id=QXHN5UI9dYMz
    Кроме того, продуманный гардероб упрощает выбор в повседневных делах.
    Со временем внимание к стилю воспитывает чувство меры.
    В итоге стильная одежда остается элементом современного образа жизни.

  49. Winstongog's avatar Winstongog says:

    Even when it’s out of focus, health remains the foundation of how we function.
    Health is talked about nonstop, but seldom examined with care.
    We try to squeeze ourselves into systems that were never made for us.
    Every change is a form of communication from within.
    Our systems adapt and recalibrate day by day.
    Awareness turns vague sensations into understandable signals.
    Awareness makes ordinary moments feel more real.
    This kind of insight rarely comes from strict rules and rigid plans.
    If you’re tired of shallow tips and ready for something deeper.
    To approach health as a conversation, not a checklist.
    It’s about understanding rather than urgency.
    Each insight brings us closer to what health actually means.
    That crossroads—between feeling and knowledge—is where real insight lives.
    These deeper processes become easier to see through kamagra oral jelly storage.

  50. Winstongog's avatar Winstongog says:

    Day after day, health quietly steers how we feel, choose, and respond.
    Even with endless guidelines, many people feel more lost than supported.
    Bodies speak in personal signals, but advice is often broad and generic.
    Every change is a form of communication from within.
    Our systems adapt and recalibrate day by day.
    Awareness turns vague sensations into understandable signals.
    Over time, health stops feeling like an outside target and becomes part of identity.
    When we release perfection, clarity often appears on its own.
    If you’re tired of shallow tips and ready for something deeper.
    This is a simple invitation to come back to yourself.
    And letting balance appear naturally, in its own time.
    When we listen carefully, health becomes an unfolding story, not a single result.
    That crossroads—between feeling and knowledge—is where real insight lives.
    Have you ever considered how this connects to fildena active ingredient.

Leave a Reply

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