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.






























28 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. Your blog is very effective and valuable. I am very glad to read your blog. I hope you will soon share your next post about this discussion. Healthcare network

    ReplyDelete
  11. 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
  12. 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
  13. 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
  14. Growing up, I was an extremely energetic child and was in great shape because of it. But in my 20s, I gained a whopping 35 kilos because I was feeling stressed. That really took a toll on my confidence, but I remained determined and ltimately took matters into my own hands. fitness with dina

    ReplyDelete
  15. 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
  16. It is truly a nice and useful piece of info. I am glad that you simply shared this useful information with us. Please keep us informed like this. Thank you for sharing.
    Moviesflix

    ReplyDelete
  17. I seriously love your website.. Excellent colors & theme.
    Did you create this amazing site yourself? Please reply back as I’m attempting to create my own site
    and want to know where you got this from or just what the theme is named.
    Cheers!

    Review my webpage - 대구오피

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

    my web site :온라인바카라

    ReplyDelete
  19. 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
  20. Great Article you can also find information about Quickbooks Solution
    at QuickBooks Customer Service

    ReplyDelete
  21. 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
  22. I’m more than happy to uncover this web site. I want to to thank you for your time just for this fantastic read!! I definitely loved every part of it and I have you saved as a favorite to look at new information on your website.
    카지노커뮤니티

    wep.

    ReplyDelete

Search This Blog