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 datatype,i 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 done,but 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 also,but it is giving error at List

Lakshmanan Sethu Sankaranarayan · Answer

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

LINQ

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (8)