Tech Junkie Blog - Real World Tutorials, Happy Coding!: Hour 13 ASP.NET Core : Add NorthwindContext To Startup Class And Create Database

Thursday, August 22, 2019

Hour 13 ASP.NET Core : Add NorthwindContext To Startup Class And Create Database

In this post will are going to finally create the database that we have been preparing for in the last previous blog posts.  It's a two step process, first you have to add the NorthwindContext to the application in the Startup class, then you have to run the Entity Framework migration tool.

Here are the steps to create your NorthwindCafe database:

1.  Open the Startup.cs file, then type the following lines in the ConfigureServices method
 
            var connectionString = Configuration["Data:NorthwindContextConnection"];

            services.AddDbContext<NorthwindContext>(options => options.UseSqlServer(connectionString));

The line above gets the connection string from the appSettings.json file that we've created earlier. Then use the AddDbContext method in the services instance.  Dependency injection will take care of the plumbing for you.  Using lamba expression we tell the Entity Framework to use the Sql Sever provider for Entity Framework core.

Make sure you have the following namespaces in your Startup class

using NorthwindCafe.Web.Models;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.EntityFrameworkCore;




2.  Now we can run the dotnet ef tools in the command line, make sure you are at the location of the NorthwindCafe.Web project.  Also before you run the tool in command line, make sure you build the solution first.


3.  In the command line type dotnet ef migrations add InitialDatabase your screen should look like below












4.  Now you have to run another command to actually create the database  type dotnet ef database update to create the NorthwindCafe database in SQL Server







The first command dotnet ef migrations add InitialDatabase creates two files in the "Migrations" folder in the NorthwindCafe.Web project.  These files contains the codes for creating the database and any other subsequent migrations that you will run in the future.  Everytime you run a migration a snapshot is created with the NorthwindContextModelSnapshot
























The second dotnet ef database update command uses the migration script in Visual Studio to update the database.  After you run this command you will see that the NorthwindCafe database has been created.  The amazing thing is that the foreign key constraint has been added for us, because we used the virtual keyword to define our property in our models in this post.






























30 comments:

  1. Home furniture's and wood working makes home more beautiful and attractive. its Christmas aslo i think this site is of great help for us Teds Woodworking

    ReplyDelete
  2. Amazing post and also great suggestions! This publication is very beneficial and great for us. Thanks for discussing valuable details. coronavirus

    ReplyDelete
  3. It's really nice and meaningful. it's really cool blog. Linking is very useful thing. you have really helped lots of people who visit blog and provide them useful information

    ReplyDelete
  4. Thanks for sharing the article. This is really informative. 2nd Corona wave

    ReplyDelete
  5. Helpful information for those who knew nothing about this �� thanks for pulling together and sharing! National Anti-Money

    ReplyDelete
  6. Great job for publishing such a beneficial web site. I was exactly searching for. Thanks for such a post and please keep it up. I am very happy to see your post. Thanks for sharing.
    South africa's News

    ReplyDelete
  7. It was really good work. I really like your thoughts.I personally appreciates for your work.your article is very impressive and helpful for us. Hope you will share these kinds of things with us also in future.
    Apple music launch 1st radio show

    ReplyDelete
  8. Recently, I have started to read a lot of unique articles on different sites, and I am enjoying that a lot. Although, I must tell you that I still like the articles here a lot. They are also unique in their own way. COFI BILL

    ReplyDelete
  9. Thanks for giving us so much shine !!
    Great tips man! Worth reading. To be honest at first sight I thought you’ll use the same old tips people used to write on their blogs, but here I learnt some new things in this key Point, something out of the box!
    OPPO Launches F17 Pro

    ReplyDelete
  10. We will finally create the database that we have been planning for in the previous blog entries in coursework help ukk this post. It's a two-step process: first, add the NorthwindContext to the Startup class of the application, then run the Entity Framework migration tool.

    ReplyDelete
  11. If you don’t believe in writing services, we will change your mind! If you tell us specific instructions, our writer will stick to them. Assignmentdoer here and you will receive the best possible paper.

    ReplyDelete
  12. Typically, carpet needs to be replaced every 10 years or so. Harder surfaces such as wood, tile, and vinyl usually last at least 20 – 25 years. This all depends on your exact circumstances, though. To ensure that your new flooring lasts as long as you intend it to, make sure to purchase from a high-quality manufacturer and go through all the proper steps for maintenance.

    ReplyDelete
  13. Ramma foundation repair crew of experienced workers hand-dig all foundation and weeping tile projects to ensure maximum reliability of the repairs without the need for expensive machinery that runs the risk of property damage.

    ReplyDelete
  14. Very interesting subject, appreciate it for posting.

    my web site :온라인바카라

    ReplyDelete
  15. QuickBooks is best software in the market for managing accounting task if you are looking sofware solution then contact at
    QuickBooks Customer Service for technical support

    ReplyDelete
  16. Great Article you can also find information about Quickbooks Solution
    at QuickBooks Customer Service

    ReplyDelete
  17. Ucuz, kaliteli ve organik sosyal medya hizmetleri satın almak için Ravje Medya sitesini tercih edebilir ve sosyal medya hesaplarını hızla büyütebilirsin. Ravje Medya ile sosyal medya hesaplarını organik ve gerçek kişiler ile geliştirebilir, kişisel ya da ticari hesapların için Ravje Medyayı tercih edebilirsin. Ravje Medya internet sitesine giriş yapmak için hemen tıkla: https://www.ravje.com
    İnstagram takipçi satın almak için Ravje Medya hizmetlerini tercih edebilir, güvenilir ve gerçek takipçilere Ravje Medya ile ulaşabilirsin. İnstagram takipçi satın almak artık Ravje Medya ile oldukça güvenilir. Hemen instagram takipçi satın almak için Ravje Medyanın ilgili sayfasını ziyaret et: instagram takipçi satın al
    Tiktok takipçi satın al istiyorsan tercihini Ravje Medya yap! Ravje Medya uzman kadrosu ve profesyonel ekibi ile sizlere Tiktok takipçi satın alma hizmetide sunmaktadır. Tiktok takipçi satın almak için hemen tıkla: tiktok takipçi satın al

    ReplyDelete
  18. This is an excellent article. I used to be visiting this blog on a regular basis and I'm impressed! Very useful information, especially the last section:). I have been looking for this information for a long time.
    Thank you for your time and consideration, and best wishes. 10 common smartphone problems and sollutions

    ReplyDelete
  19. Our uk writers for papers have inside and out experience in every one of the configurations, which never allowed them to pay attention research paper think twice about quality. They can assist you with finishing your school paper under the time furthest reaches of accommodation.

    ReplyDelete
  20. The experts we have here are all paper bosses and phd holders who incredibly center around design, style, and language to write my assignment for me online remain on understudy's assumptions. Thusly, this permits our essayists to further develop their composing abilities and execution consistently.

    ReplyDelete
  21. very nice Content. visit now: https://www.typebeautyinc.com/

    ReplyDelete
  22. Thanks for sharing this informative piece of information visit my website https://www.leopardscourier.com

    ReplyDelete
  23. Say goodbye to guesswork and hello to Amazon PPC domination! Our advance keyword search PPC for Amazon PPC isn't just a tool; it's your secret sauce for turning clicks into cash. Ready to outsmart the competition? Buckle up, because your keywords are about to take the express lane to success

    ReplyDelete

Search This Blog