/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

2 votes296 views2 answers
How to play sound effect in unity fmod
C#Unity
57 votes393 views6 answers
Unity find objects with tag
C#
31 votes284 views4 answers
C# convert string to datetime any format
C#
0 vote284 views2 answers
Write N lines with M numbers each that describe the layout of the second layer in the way shown above
C#
0 vote320 views1 answer
Dapper c# insert range
C#
0 vote297 views2 answers
.net Core Get File Request
C#
1 vote292 views1 answer
C# verify in class exist in list
C#
0 vote325 views1 answer
Get all viewsheet revit api
C#
0 vote300 views1 answer
Unity get camera
C#
0 vote354 views1 answer
On collision enter by layer 2d unity
C#Unity