static void Main(string[] args) { var dbContextOptions = new DbContextOptionsBuilder <DeadLoadsDbContext>() .UseSqlServer("server=localhost; database=Build_IT_DeadLoads; Integrated Security=SSPI;"); var deadLoadsContext = new DeadLoadsDbContext(dbContextOptions.Options); var unitOfWork = new DeadLoadsUnitOfWork(deadLoadsContext, new CategoryRepository(deadLoadsContext), new SubcategoryRepository(deadLoadsContext), new MaterialRepository(deadLoadsContext)); //var materialRepo = unitOfWork.Materials; foreach (var category in unitOfWork.Categories.GetAllAsync().Result) { Console.WriteLine(category.Name); foreach (var subcategory in unitOfWork.Subcategories .GetAllSubcategoriesForCategoryAsync(category.Id).Result) { Console.WriteLine(" " + subcategory.Name); foreach (var material in unitOfWork.Materials .GetAllMaterialsForSubcategoryAsync(subcategory.Id).Result) { Console.WriteLine(" " + material.Name); } } } var categories = deadLoadsContext.Categories; foreach (var category in categories) { Console.WriteLine(category.Name); foreach (var subcategory in deadLoadsContext.Subcategories .Where(s => s.CategoryId == category.Id)) { Console.WriteLine(" " + subcategory.Name); foreach (var material in deadLoadsContext.Materials .Where(s => s.SubcategoryId == subcategory.Id)) { Console.WriteLine(" " + material.Name); } } } deadLoadsContext.Dispose(); Console.ReadLine(); }
public MaterialRepository(DeadLoadsDbContext context) : base(context) { }
public SubcategoryRepository(DeadLoadsDbContext context) : base(context) { }