/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 vote255 views1 answer
Get current location latitude and longitude in xamarin - NAYCode.com
C#
0 vote252 views1 answer
Asp.net core authorization default policy
C#
4 votes312 views1 answer
Unity mouse look script 2021
C#Unity
0 vote243 views1 answer
C# make file writable
C#
0 vote254 views2 answers
C# list remove by index
C#
4 votes290 views1 answer
C# change label forecolor code
C#
1 vote278 views1 answer
Find sum of multiples of a number
C#
-2 votes205 views1 answer
Tryparse string to int c#
C#
3 votes263 views2 answers
Get property value from object c#
C#
0 vote306 views1 answer
Unity customize hierarchy window
C#Unity