Convert this sql command to c# linq

by 

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();

More Related Contents:

  1. Multiple “order by” in LINQ
  2. C# LINQ find duplicates in List
  3. How to do SQL Like % in Linq?
  4. How to filter nested collection Entity Framework objects?
  5. Linq with group by having count
  6. LINQ Partition List into Lists of 8 members [duplicate]
  7. LINQ Between Operator
  8. LINQ OrderBy versus ThenBy
  9. What’s the difference between IQueryable and IEnumerable [duplicate]
  10. Can LINQ be used in PowerShell?
  11. Use LINQ to concatenate multiple rows into single row (CSV property)
  12. Linq-to-entities – Include() method not loading
  13. PowerShell equivalent of LINQ Any()?
  14. Instantiating a context in LINQ to Entities
  15. conditional include in linq to entities?
  16. LINQ not updating on .SubmitChanges()
  17. Linq To Entities – how to filter on child entities
  18. Expose IQueryable Over WCF Service
  19. writing a custom comparer for linq groupby
  20. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  21. Entity Framework, Code First and Full Text Search
  22. How LINQ works internally?
  23. LINQ OrderBy not ordering .. changing nothing .. why?
  24. Simple Linq query has duplicated join against same table?
  25. OrderBy descending in Lambda expression?
  26. LINQ Include vs Join. Are they equivalent?
  27. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  28. If condition in LINQ Where clause
  29. LINQ: How to convert the nested hierarchical object to flatten object
  30. Fun (?) with Linq Expressions in extension methods

Leave a Comment