Selecting multiple columns with linq query and lambda expression

Code with bulbul answered on February 10, 2022 Popularity 5/10 Helpfulness 4/10

answer Selecting multiple columns with linq query and lambda expression

Selecting multiple columns with linq query and lambda expression

Comment

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;}
}

Popularity 5/10 Helpfulness 4/10 Language csharp

Source: stackoverflow.com

Tags: c# expression lambda linq multiple-columns

Link to this answer
Share Copy Link

Contributed on Feb 10 2022

Code with bulbul

0 Answers Avg Quality 2/10

Selecting multiple columns with linq query and lambda expression

Contents

More Related Answers

Selecting multiple columns with linq query and lambda expression

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.