linq to entity distinct

[hcb111]

现在有这样的语句
select value c from AAA as c where 一堆条件 order by id

我的需求是，执行出来的结果又重复项，我想distinct掉，linq to entity中不知道该怎么写。

翻译成sql语句应该是这样

select * from AAA as a where id=(select min(id) from BBB where name=a.name)

[你们是不是在找BUG]

你的问题里面没有distinct操作

[hcb111]

因为我这个写法不是标准的LINQ语句

平时写成
select value c from AAA as c where 一堆条件


怎么样像在SQL里一样，只需要在WHERE条件中加入一段话，那段话该怎么写

[研发群187380948欢迎加入]

where（x=>x.字段名==值）

实在搞不定就下载个转换软件 linq和sql能转换

[bdmh]

http://www.dotblogs.com.tw/dc690216/archive/2009/09/13/10603.aspx

[hcb111]

select * from AAA as a where id=(select min(id) from BBB where name=a.name)

就这句sql翻译成linq to entity，该怎么写？

[q107770540]

var query=from a in db.AAA
where a.id== db.BBB.Where(b=>b.name==a.name).Select(b=>b.id).Min()
select a;

[lhx527099095]

楼上正解

[研发群187380948欢迎加入]

[Quote=引用 3 楼 的回复:]

var query=from a in db.AAA
where a.id== db.BBB.Where(b=>b.name==a.name).Select(b=>b.id).Min()
select a;
[/Quote]去从就加.distinct()

[cass8816]

var q = (from a in b
select a).distinct()

[EnForGrass]

var query=(from a in db.AAA 
          where a.id== db.BBB.Where(b=>b.name==a.name)
          select a).Distinct();

[你的选择B]

/// <summary>
        /// 返回不重复的Customers
        /// </summary>
        public static List<Customers> DistinctSearch()
        {
            List<Customers> customers = null;
            using (NorthwindEntities entity = new NorthwindEntities())
            {
                //以NorthWind为例，查找地区为London，并按照CustomerID升序，且不重复的记录
                customers = entity.Customers.Where(c => c.City == "London").OrderBy(n => n.CustomerID).Distinct().ToList();
            }

            return customers;
        }