/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 votes360 views2 answers
Ontriggerenter2d
C#
0 vote345 views1 answer
Recorrer list c#
C#
0 vote328 views1 answer
Run Tasks in Parallel
C#
0 vote336 views1 answer
Vb.net drag window without titlebar
C#
1 vote305 views2 answers
Declare enum c#
C#
0 vote351 views1 answer
Exception e is null c#
C#
0 vote319 views1 answer
Unity change fixed timestep in code
C#
0 vote309 views1 answer
How to use external resource.resx file in c#
C#
0 vote329 views1 answer
Godot Duplicate 'global::System.Runtime.Versioning.TargetFrameworkAttribute'
C#
1 vote337 views1 answer
C# detect if string has a nubmer and store it
C#