public static async void UseSeed(this IApplicationBuilder app) { IServiceScope scope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope(); PgsqlContext context = scope.ServiceProvider.GetService <PgsqlContext>(); IRepository repository = scope.ServiceProvider.GetService <IRepository>(); IConfiguration configuration = scope.ServiceProvider.GetService <IConfiguration>(); using (context) { // Crea la BD si no existe context.Database.Migrate(); // ejecuta los seeds necesarios en la BD // se deben agregar bool runSeed = bool.Parse(configuration.GetValue <string>("Seed")); if (runSeed) { if (!context.Student.Any()) { StudentSeed studentSeed = new StudentSeed(repository); await studentSeed.Run(); } } } }
private void pgsqlExport_Click(object sender, RoutedEventArgs e) { var db = PgsqlContext.CreateConnection(); db.Database.EnsureCreated(); Scene psqlScene = db.Scene.FirstOrDefault(s => s.SceneId == Scene.Instance.SceneId); if (psqlScene != null) { System.Windows.Forms.DialogResult dialogResult = System.Windows.Forms.MessageBox.Show( "May be this scene already exists in PostgreSQL database." + " Psql scene name: " + psqlScene.Name + " This scene name: " + Scene.Instance.Name + " Are you sure you want insert it?", "Think about it!", System.Windows.Forms.MessageBoxButtons.YesNo); if (dialogResult == System.Windows.Forms.DialogResult.Yes) { Console.WriteLine("testing1"); Scene.Instance.SceneId = db.Scene.Last().SceneId + 1; Console.WriteLine("testing2"); } else if (dialogResult == System.Windows.Forms.DialogResult.No) { return; } } List <Scene> list = db.Scene.ToList(); Console.WriteLine("algo"); db.Scene.Add(Scene.Instance); list = db.Scene.ToList(); Console.WriteLine("algo"); db.SaveChanges(); }
public StudentsController(PgsqlContext context, ILogger iLogger, IMapper mapper, IRepository repository) { Repository = repository; Logger = iLogger; Mapper = mapper; }