/C#/Selecting multiple columns with linq query and lambda expression

Selecting multiple columns with linq query and lambda expression

public NamePriceModel[] AllProducts()
{
    try
    {
        using (UserDataDataContext db = new UserDataDataContext())
        {
            return db.mrobProducts
                .Where(x => x.Status == 1)
                .Select(x => new NamePriceModel { 
                    Name = x.Name, 
                    Id = x.Id, 
                    Price = x.Price
                })
                .OrderBy(x => x.Id)
                .ToArray();
         }
     }
     catch
     {
         return null;
     }
 }

public class NamePriceModel 
{
    public string Name {get; set;}
    public decimal? Price {get; set;}
    public int Id {get; set;}
}

Source: stackoverflow.com

Similar codes

1 vote105 views1 answer
C# virtual keyword
C#
23 votes97 views3 answers
Unity textmeshpro
C#
0 vote107 views1 answer
C# get list item in random order
C#
35 votes105 views4 answers
C# list length
C#
0 vote117 views1 answer
Special characters regex c#
C#
0 vote105 views1 answer
How-to-add-new-column-with-value-to-the-existing-datatable
C#
0 vote146 views1 answer
Unity Reverse string
C#Unity
1 vote102 views1 answer
C# public static string
C#
18 votes90 views4 answers
C# bytes to string
C#
0 vote103 views1 answer
Pointer in c#
C#