/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 vote274 views1 answer
Fixed angle unity
C#Unity
3 votes259 views1 answer
Difference two list c#
C#
0 vote270 views1 answer
Wpf app how to get all elements which are exposed to script
C#
0 vote254 views1 answer
Dynamics 365 create record c#
C#
0 vote227 views1 answer
Entity framework linq join two tables
C#
0 vote254 views1 answer
How to print text to screen in c#
C#
0 vote271 views1 answer
How can I return image from controller asp.net
C#
20 votes291 views2 answers
How to generate random letters in C#
C#
0 vote194 views1 answer
How to set an expiry date on a program
C#
2 votes272 views2 answers
How to save a c# dictionary
C#