LINQ to SQL从结果中省略字段，但仍将其包含在where子句中

基本上我正在尝试在LINQ to SQL中做到这一点;

SELECT DISTINCT a,b,c FROM table WHERE z=35

我已经试过了，(c# code)

(from record in db.table
select new table {
    a = record.a,
    b = record.b,
    c = record.c
}).Where(record => record.z.Equals(35)).Distinct();

但是当我以这种方式从表对象中删除列z时，我会得到以下异常;

绑定错误:Member 'table。投影中找不到Z

我不能返回字段z，因为它会使我的distinct无用。任何帮助都是感激的，谢谢。

编辑:

这是一个更全面的例子，包括PredicateBuilder的使用，

var clause = PredicateBuilder.False<User>();
clause = clause.Or(user => user.z.Equals(35));
foreach (int i in IntegerList) {
    int tmp = i;
    clause = clause.Or(user => user.a.Equals(tmp));
}
var results = (from u in db.Users
               select new User {
                   a = user.a,
                   b = user.b,
                   c = user.c
               }).Where(clause).Distinct();

Edit2:

非常感谢每个人的评论和回答，这是我最终的解决方案，

var clause = PredicateBuilder.False<User>();
clause = clause.Or(user => user.z.Equals(35));
foreach (int i in IntegerList) {
    int tmp = i;
    clause = clause.Or(user => user.a.Equals(tmp));
}
var results = (from u in db.Users
               select u)
               .Where(clause)
               .Select(u => new User {
                   a = user.a,
                   b = user.b,
                   c = user.c
               }).Distinct();

Where后面跟着Select的顺序是至关重要的

(from record in db.table
where record.z == 35
select new table {
    a = record.a,
    b = record.b,
    c = record.c
}).Distinct();

(from record in db.table
where record.z == 35
select new table {
    a = record.a,
    b = record.b,
    c = record.c
}).Distinct();