/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

4 votes195 views1 answer
How to set a vector 3 variable in csharp
C#
2 votes187 views1 answer
New color unity
C#
1 vote194 views2 answers
How convert the string time stamp to date in laravel
C#
0 vote188 views1 answer
C# tell if list object is empty
C#
0 vote187 views1 answer
C# accesseurs
C#
0 vote201 views1 answer
C# create dll runtime
C#
0 vote227 views1 answer
Unity create cube in script
C#Unity
0 vote231 views1 answer
C# remove non-alphanumeric characters from string
C#
0 vote230 views1 answer
Request ID: XPBBR4XG1UWuX6fWF08_-jzYkrommVJjO7Os50CTYuZmiw7kMsFUkw==
C#
2 votes204 views1 answer
Import C++ into C#
C#