static void Main(string[] args)
{
using (var context = new ViewsContext())
{
context.People.Add(new Person()
{
Address = new Address
{
City = "Warsaw",
Street = "Dubois"
},
Name = "John",
Surname = "Kowalski"
});
context.SaveChanges();
var people = context.Set <PeopleView>().AsQueryable().ToList();
foreach (var view in people)
{
Console.WriteLine($"{view.PersonId} {view.Name} {view.Surname} {view.City} {view.Street}");
}
}
}
public void StartUp()
{
var optionsBuilder = new DbContextOptionsBuilder <ViewsContext>();
optionsBuilder.UseSqlite("Filename = Views.db");
_db = new ViewsContext(optionsBuilder.Options);
}
