Data Retreival in Linq to Entities

See more:

C#

SQL

LINQ

server

Hello,

I am writing a small application. This contains only one table called master. This contains about 280 fields and i am using Linq to Entities to use.

Following is the code.

List<Master> dataAcc = new List<Master>();
       public MainWindow()
       {
           InitializeComponent();
           dataAcc = Getmembers();
        }

       public List<Master> Getmembers()
       {
           BillingEntities billEntity = new BillingEntities(DataAccess.GetConnectionStringForSelectedPractice("MyDB"));

           List<Master> dataAccount = (from p in billEntity.DataAccounts
                                            where p.Duplicate == false
                                            select p
                                            ).Take(1000).ToList<Master>();

           return dataAccount;


       }

Actually i need only three columns out of 280 columns but Linq to Entities is not accepting to write code in the following way as like linq to sql.

 List<master> dataAcc = new List<Master>();
        public MainWindow()
        {
            InitializeComponent();
            dataAcc = Getmembers();
         }

        public List<master> Getmembers()
        {
            BillingEntities billEntity = new BillingEntities(DataAccess.GetConnectionStringForSelectedPractice("MyDB"));

            List<master> dataAccount = (from p in billEntity.DataAccounts
                                             where p.Duplicate == false
                                             select new Master
{
  AcctNumber = p.AcctNumber,
  Name = p.Name,
  BirthDay = p. DOB
}
).Take(1000).ToList<master>();

return dataAccount;
}

Is it possible to acheive this????

chowdary.</master></master></master></dataaccount></dataaccount>