谢谢看
我的资料
Easting Northing Street Town postcode
123454 887878 main yourTown gh6 0jh
098345 093978 main yourTown gh6 0jh
872982 873839 main yourTown gh6 0jh
849728 938393 south yourTown gh6 8uh
748494 817263 south yourTown gh6 8uh
989893 787878 high yourTown gh6 7mu
889955 992002 high yourTown gh6 7mu
882999 998339 high yourTown gh6 7mu
我的linq声明
return this._uow.Addresses
.Where(a => a.Street.Trim().ToUpper().Contains(street.Trim().ToUpper()))
.Select(a =>
new Street()
{
MapEast = a.MapEast,
MapNorth = a.MapNorth,
Details = a.Street + " " + a.Town + " " + a.PostCode
})
.AsEnumerable();
我只需要出现一条街道,城镇,邮政编码,然后进行东移和北移就可以完成该一项记录。我不关心选择哪个记录。这是通过groupby完成的吗?我一直在用groupby解决这个问题,但无法弄清楚。希望你能帮忙
然后使用分组依据,并以该分组中的第一项为例
.GroupBy(m => new {m.Street, m.Town, m.PostCode)
.Select(g => g.First());//You will get first Address
还是你的情况
.Where(<yourWhereClause>)
.GroupBy(m => new {m.Street, m.Town, m.PostCode})
.Select(m => new Street {
MapEast = m.FirstOrDefault().MapEast,//"random" MapEast
MapNorth = m.FirstOrDefault().MapNorth,//"random" MapNorth
Details = a.Key.Street + " " + a.Key.Town + " " + a.Key.PostCode
});
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句