How to get values in some column?

[john]

I have a Customer class with CustomId, CustomerName, Age, Sex, BirthDate. If I only want to retrieve CustomerId and Age column, how can I write code for filling Customer class with two columns?

[Doroteya]

Hello John,

The best way to retrieve a subset of columns from a given class is by LINQ. The necessary statement should look like this:

IList<Customer> result = (from customers in dbContext.Customers
           select new Customer
            {
                CustomerId = customer.CustomerID,
                Age = customer.Age
            }).ToList();

In addition, the How to: Read a Subset of Columns article gives a detailed, step-by-step answer to your question.

If you experience any difficulties or have other questions, do not hesitate to get back to us.

Kind regards,
Doroteya
the Telerik team