
Also, I would like to avoid inline SQL if possible. My question is, how can I make this work so that I am filtering the addresses on the database? I would like to remove the foreach look so that the NPoco query only brings back the filtered data from the database. And we have to make sure data remains consistent throughout the application.
#Npoco idatabase updateasync software#
As software or applications evolve and improve over the time, your database must as well. Person.Addresses = (x => x.Status = AddressStatus.Active).ToList() Introduction As a software developer at some point, you might have to deal with database migrations in one way or another.
#Npoco idatabase updateasync code#
My code looks a bit like this, and it works.



I am using IncludeMany and the Reference attribute to get a table with the related list.
