如何在C＃中使用单个查询来做到这一点？

I want to make passive them if a date is earlier than today from the recorded dates within database with update command.How can I do that by using single query in C#?I want to make passive them if a date is earlie