private static void SeedContacts(this MusicTutorAPIDbContext context, string dataPath) { var jsonString = File.ReadAllText(dataPath); var contacts = JsonSerializer.Deserialize <Contact[]>(jsonString); context.Contacts.AddRange(contacts); }
public static int SeedDatabase(this MusicTutorAPIDbContext context, string dataDirectory) { // if (!(context.GetService<IDatabaseCreator>() as RelationalDatabaseCreator).Exists()) // throw new InvalidOperationException("The database does not exist. If you are using Migrations then run PMC command update-database to create it"); var numInstruments = context.Instruments.Count(); if (numInstruments == 0) { //the database is empty so we fill it from a json file var seedDir = Path.Combine(dataDirectory, SeedFileSubDirectory); context.SeedInstruments(Path.Combine(seedDir, "instruments.json")); context.SeedContacts(Path.Combine(seedDir, "contacts.json")); context.SaveChanges(); } return(numInstruments); }
public static void DevelopmentEnsureCreated(this MusicTutorAPIDbContext db) { db.Database.EnsureCreated(); }
public InstrumentGenController(MusicTutorAPIDbContext context) { _context = context; }