/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

3 votes139 views2 answers
How to freeze x and y position in rb2d with code unity
C#
7 votes139 views1 answer
Unity 2d jump
C#
5 votes149 views2 answers
Read xml file c#
C#
10 votes150 views2 answers
Convert array from string to int c#
C#
0 vote146 views1 answer
C# base vs this
C#
-1 vote148 views1 answer
Find first occurrence of character in string
C#
5 votes136 views2 answers
Rigidbody velocity c# unity
C#
0 vote134 views1 answer
What dotnet command does
C#
1 vote147 views1 answer
C# copy file to system folder
C#
0 vote143 views1 answer
Dotnet.com
C#