LINQ to SQL with if语句

using System;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 创建LINQ to SQL上下文
        using (var context = new MyDataContext())
        {
            // 定义查询
            var query = from c in context.Customers
                        where c.Age > 18
                        select c;

            // 根据条件添加额外的过滤条件
            bool isVIP = true;
            if (isVIP)
            {
                query = query.Where(c => c.IsVIP);
            }

            // 执行查询
            var results = query.ToList();

            // 输出结果
            foreach (var customer in results)
            {
                Console.WriteLine(customer.Name);
            }
        }
    }
}