LINQ

Question

documenttype customerId 1 ............ 2 ............... 3 .............. I have to retrieve documenttype values based on customerId using linq.how to do that?. List basicdetails = (from records in db.NCBAccountDocuments where records.CustomerReferenceNo == CustomerId select records).ToList(); I done like that but it is retrieving all column values.I need only one column value .please help me

Jaganathan Bantheswaran · Answer

Try something like this var basicdetails = (from records in db.NCBAccountDocuments where records.CustomerReferenceNo == CustomerId select new { DocType = records.documenttype }).ToList(); Then access it like foreach(var detail in basicdetails) { // detail.DocType }

Biswa Pujarini Mohapatra · Answer

oh then this is your code then List basicdetails = (from records in db.NCBAccountDocuments where records.CustomerReferenceNo == CustomerId select newDBLayer.Models.NCBAccountDocument{documenttype =records.documenttype }).ToList();

Sasi Reddy · Answer

Hi Pujarini I tried as per Jaganathan but my requirement is basicdetails should be as List var basicdetails = (from records in db.NCBAccountDocuments where records.CustomerReferenceNo == CustomerId select new { DocType = records.documenttype }).ToList(); Instead of Var datatypei need List

Biswa Pujarini Mohapatra · Answer

can you try as per Jagantahan comment. if not please paste the error here

Sasi Reddy · Answer

Hi Pujarini Samething i donebut no use it is giving error

Biswa Pujarini Mohapatra · Answer

List basicdetails = (from records in db.NCBAccountDocuments where records.CustomerReferenceNo == CustomerId select records. documenttype ).ToList();

Sasi Reddy · Answer

I have done like that alsobut it is giving error at List

Lakshmanan Sethu · Answer

Please mention the column name in records.columnname)ToList().