Convert this sql command to c# linq

Question

I am trying to convert this tSql command to linq query.
I want to group this columns.
Can you help me?

select  vUnit.FK_Unit_ID , Unit.unitNumber, unit.unitTitle , title.featureTitleName
from unit.UnitFeatureValue vUnit
inner join unit.Unit on vUnit.FK_Unit_ID = Unit.ID
inner join unit.FeatureTitle title on vUnit.FK_FeatureTitle_ID = title.ID
where vUnit.FK_Unit_ID = 15 and title.canMoreSelect = 1
group by vUnit.FK_Unit_ID ,unit.unitNumber, unit.unitTitle , title.featureTitleName

Please show us what you tried, and we'll help you get it working. — 15ee8f99-57ff-4f92-890c-b56153, Sep 18 '17 at 17:17
what is the goal of your **group by**, you don't have a count or a sum or anything like that — Victor Hugo Terceros, Sep 18 '17 at 17:18
use your class `new YourClass {...}` instead of just `new {...}` — Matthew Whited, Sep 18 '17 at 19:41
yes i can convert var result to my class. :). with query.First() i can get field name. thanks again Matthew Whited. — user3425037, Sep 18 '17 at 20:29
"[Why is can someone help me not a question](https://meta.stackoverflow.com/questions/284236/why-is-can-someone-help-me-not-an-actual-question)" — EJoshuaS - Stand with Ukraine, Oct 13 '17 at 15:19

Victor Hugo Terceros · Answer 1 · 2017-09-18T19:32:50.980

0

something like this

var result = (from v in vUnit 
join u in unit on v.FK_Unit_ID equals u.ID
join t in title on v.FK_FeatureTitle_ID equals t.ID
where v.FK_Unit_ID == 15 and t.canMoreSelect == 1
select new { v.FK_Unit_ID , u.unitNumber, u.unitTitle , t.featureTitleName }).ToList();

edited Sep 18 '17 at 19:32

answered Sep 18 '17 at 17:24

Victor Hugo Terceros

2,969
3
18
31

explain the downvote please, and propose something better? – Victor Hugo Terceros Sep 18 '17 at 17:28
your join syntax is wrong and this will not do the distinct/grouping – Matthew Whited Sep 18 '17 at 17:29
did you see the original query? does it need a group by? – Victor Hugo Terceros Sep 18 '17 at 17:35
That would depend on the data. but your join syntax is stil wrong. `=` should be `equals` https://learn.microsoft.com/en-us/dotnet/csharp/linq/perform-inner-joins – Matthew Whited Sep 18 '17 at 17:37
(just as a note `=` should be `==` on the where clause and the `(`...`).ToList()` isn't needed. (And kills composability) – Matthew Whited Sep 18 '17 at 17:44

score 0 · Accepted Answer · answered Sep 18 '17 at 17:26

0

var query = (
    from v in dbContext.UnitFeatureValue
    join u in dbContext.Unit on v.FK_Unit_ID equals u.ID
    join t in dbContext.FeatureTitle on v.FK_FeatureTitle_ID equals t.ID
    where v.FK_Unit_ID == 15 && t.canMoreSelect == 1
    select  new {
        v.FK_Unit_ID, 
        u.unitNumber, 
        u.unitTitle, 
        t.featureTitleName,
    }).Distinct();

answered Sep 18 '17 at 17:26

Matthew Whited

22,160
4
52
69

When the SQL has table aliases such as `vUnit` and `title` I recommend using them as the range variables. – NetMage Sep 18 '17 at 17:50
I would recomend not making this mess at all. – Matthew Whited Sep 18 '17 at 17:53
1

That sounds like saying "I would recommend not programming"? Why are you on this site? If you think you have a better approach, shouldn't your answer reflect that? – NetMage Sep 18 '17 at 19:05

Convert this sql command to c# linq

2 Answers2