‫نحوه پیاده سازی ساختار پیشرفته جستجو بوسیله Linq بر روی SQL Databse

It was a legacy enterprise project and I was asked to improve its “advanced” filtering capabilities.

Before they had something like this:

But wanted something like this: