/*This class will load a sample set of data into the in memory database.*/ public static void Initialize(IServiceProvider serviceProvider) { // Get the database context using (var context = new NuixContext(serviceProvider.GetRequiredService <DbContextOptions <NuixContext> >())) { if (context.Investments.Any()) { return; } context.Investments.Add( new Investment { Id = 1, InvestmentName = "PNC" }); context.Investments.Add( new Investment { Id = 2, InvestmentName = "Google" }); context.Investments.Add( new Investment { Id = 3, InvestmentName = "Microsoft" }); context.Investments.Add( new Investment { Id = 4, InvestmentName = "Apple" }); context.Investments.Add( new Investment { Id = 5, InvestmentName = "Peleton" }); context.InvestmentDetails.Add( new InvestmentDetails { Id = 1, PriceWhenPurchased = 125.75, CurrentPrice = 137.43, DatePurchased = Convert.ToDateTime("5/15/2019"), NumberOfSharesOwned = 500 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 2, PriceWhenPurchased = 2500, CurrentPrice = 2365, DatePurchased = Convert.ToDateTime("1/31/2020"), NumberOfSharesOwned = 25 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 3, PriceWhenPurchased = 232.90, CurrentPrice = 232.50, DatePurchased = Convert.ToDateTime("1/27/2021"), NumberOfSharesOwned = 250 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 4, PriceWhenPurchased = 38.74, CurrentPrice = 137.43, DatePurchased = Convert.ToDateTime("5/25/2017"), NumberOfSharesOwned = 100 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 5, PriceWhenPurchased = 140.69, CurrentPrice = 143.50, DatePurchased = Convert.ToDateTime("1/27/2021"), NumberOfSharesOwned = 750 }); context.SaveChanges(); } }
private NuixContext LoadSampleDatabaseAndReturnContext() { var options = new DbContextOptionsBuilder <NuixContext>() .UseInMemoryDatabase(databaseName: "InvestmentDatabase") .Options; // Get the database context var context = new NuixContext(options); if (context.Investments.Any()) { return(context); } context.Investments.Add( new Investment { Id = 1, InvestmentName = "PNC" }); context.Investments.Add( new Investment { Id = 2, InvestmentName = "Google" }); context.Investments.Add( new Investment { Id = 3, InvestmentName = "Microsoft" }); context.Investments.Add( new Investment { Id = 4, InvestmentName = "Apple" }); context.Investments.Add( new Investment { Id = 5, InvestmentName = "Peleton" }); context.InvestmentDetails.Add( new InvestmentDetails { Id = 1, PriceWhenPurchased = 125.75, CurrentPrice = 137.43, DatePurchased = Convert.ToDateTime("5/15/2019"), NumberOfSharesOwned = 500 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 2, PriceWhenPurchased = 2500, CurrentPrice = 2365, DatePurchased = Convert.ToDateTime("1/31/2020"), NumberOfSharesOwned = 25 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 3, PriceWhenPurchased = 232.90, CurrentPrice = 232.50, DatePurchased = Convert.ToDateTime("1/27/2021"), NumberOfSharesOwned = 250 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 4, PriceWhenPurchased = 38.74, CurrentPrice = 137.43, DatePurchased = Convert.ToDateTime("5/25/2017"), NumberOfSharesOwned = 100 }); context.InvestmentDetails.Add(new InvestmentDetails { Id = 5, PriceWhenPurchased = 140.69, CurrentPrice = 143.50, DatePurchased = Convert.ToDateTime("1/27/2021"), NumberOfSharesOwned = 750 }); context.SaveChanges(); return(context); }