/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

5 votes122 views1 answer
Unity projectile spread
C#Unity
7 votes143 views4 answers
C# append to file
C#
0 vote166 views1 answer
Download and run exe c# 1 button
C#
18 votes153 views6 answers
Laravel route redirect
C#
1 vote129 views1 answer
Switch case c# contains
C#
11 votes112 views1 answer
Mouse 2d unity
C#
0 vote171 views1 answer
Sdl quit event not working multiple windows
C#
6 votes133 views1 answer
Net core get remote ip
C#
0 vote110 views3 answers
C# shuffle array
C#
2 votes130 views2 answers
Unity animator check if animation is playing
C#