/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

0 vote312 views1 answer
@using System,System.Core
C#
6 votes308 views4 answers
How to set rigidbody velocity in unity
C#Unity
0 vote329 views1 answer
Loading screen unity
C#Unity
1 vote311 views1 answer
Unity tilemap get all tiles
C#
0 vote289 views1 answer
Lambda Expression to filter a list of list of items
C#
7 votes280 views2 answers
C# Remove String In C#
C#
2 votes278 views1 answer
Setup authorize in swagger .net core
C#
0 vote242 views1 answer
Convert linq query to json format
C#
0 vote272 views1 answer
Count Rows of table using Linq
C#
0 vote311 views1 answer
Unity random.insideunitcircle
C#Unity