Entity Framework select distinct name

Question

How can I do this SQL query with Entity Framework    SELECT DISTINCT NAME FROM TestAddresses

User · Answer

The way that  alliswell showed is completely valid  and there s another way      var result   EFContext TestAddresses      GroupBy ta   gt  ta Name       Select ta   gt  ta Key     I hope it ll be useful to someone

User · Answer

Try this   var results    from ta in context TestAddresses                select ta Name  Distinct      This will give you an IEnumerable lt string gt  - you can call  ToList   on it to get a List lt string gt

User · Answer

Entity-Framework Select Distinct Name   Suppose if you are want every first data of particular column  of each group     var data   objDb TableName GroupBy dt   gt  dt ColumnName  Select dt   gt  new   dt Key    ToList                 foreach  var item in data                                var data2  objDb TableName Where dt  gt dt ColumnName  item Key  Select dt  gt new  dt SelectYourColumn   Distinct   FirstOrDefault                      Eg                                           ListBox1 Items Add data2 ColumnName

User · Answer

DBContext TestAddresses Select m   gt  m NAME  Distinct      if you have multiple column do like this   DBContext TestAddresses Select m   gt  new  m NAME  m ID   Distinct      In this example no duplicate CategoryId and no CategoryName i hope this will help you

User · Answer

Entity-Framework Select Distinct Name   Suppose if you are using Views in which you are using multiple tables and you want to apply distinct in that case first you have to store value in variable  amp  then you can apply Distinct on that variable like this one      public List lt Item Img Sal VIEW gt  GetItemDescription int ItemNo                         var Result  db Item Img Sal VIEW Where p   gt  p ItemID    ItemNo  ToList                return Result Distinct   ToList                Or you can try this Simple Example  Public Function GetUniqueLocation   As List Of Integer            Return db LoginUsers Select Function p  p LocID  Distinct   ToList   End Function

User · Answer

use  Select   Distinct    for example  DBContext db   new DBContext    var data  db User Food UserIntakeFood  Select    Distinct

User · Answer

Using lambda expression    var result   EFContext TestAddresses Select m   gt  m Name  Distinct      Another variation using where   var result   EFContext TestAddresses               Where a   gt  a age  gt  10   if you have any condition               Select m   gt  m name  Distinct      Another variation using sql like syntax  var result    from recordset               in EFContext TestAddresses                where a   gt  a city    vijaynagar    if you have any condition                select new                                   recordset name                  Distinct

User · Answer

In order to avoid ORDER BY items must appear in the select list if SELECT DISTINCT error  the best should be var results         from ta in DBContext TestAddresses     select ta Name    Distinct    OrderBy  x   gt  1

[c#] Entity Framework select distinct name

Examples related to c#

Examples related to linq

Examples related to entity-framework

Examples related to distinct