static async Task Main(string[] args) { using (var db = new MailsAndSendersDbModel(new DbContextOptionsBuilder <MailsAndSendersDbModel>().UseSqlServer(Utils.ConnectionString).Options)) { await db.Database.EnsureCreatedAsync(); var senderscount = await db.Senders.CountAsync(); var recipientscount = await db.Recipients.CountAsync(); var serverscount = await db.Servers.CountAsync(); var messagescount = await db.Messages.CountAsync(); var taskscount = await db.SenderTasks.CountAsync(); Console.WriteLine($"Servers count={serverscount}"); Console.WriteLine($"Senders count={senderscount}"); Console.WriteLine($"Recipients count={recipientscount}"); Console.WriteLine($"Messages count={messagescount}"); Console.WriteLine($"SenderTasks count={taskscount}"); if (serverscount == 0) { await db.Servers.AddRangeAsync(new List <Server> { new Server { Name = "smtp.yandex.ru", Address = "yandex.ru", Port = 587, Login = "******", Password = "******" } , new Server { Name = "smtp.mail.ru", Address = "mail.ru", Port = 465, Login = "******", Password = "******" } , new Server { Name = "smtp.gmail.com", Address = "gmail.com", Port = 587, Login = "******", Password = "******" } }); db.SaveChanges(); } if (recipientscount == 0) { await db.Recipients.AddAsync(new Recipient { Name = "Полятыкина Татьяна", Address = "*****@*****.**" }); db.SaveChanges(); } if (senderscount == 0) { await db.Senders.AddAsync(new Sender { Name = "Полятыкина Татьяна", Address = "*****@*****.**" }); await db.Senders.AddAsync(new Sender { Name = "Tester", Address = "*****@*****.**" }); await db.Senders.AddAsync(new Sender { Name = "Geek test", Address = "*****@*****.**" }); db.SaveChanges(); } } Console.ReadLine(); }
public MainWindowViewModel(IMailService mailService, MailsAndSendersDbModel mailsAndSendersDb) { _mailService = mailService; _mailsAndSendersDb = mailsAndSendersDb; _mailsAndSendersDb.Database.EnsureCreated(); }