LINQ

Sasi Reddy

12y1.6kLINQ

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Biswa Pujarini Mohapatra12y ago
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 Reddy12y ago
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 Mohapatra12y ago
can you try as per Jagantahan comment. if not please paste the error here
Jaganathan Bantheswaran12y ago
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
}
Sasi Reddy12y ago
Hi Pujarini, Samething i done,but no use ,it is giving error
Biswa Pujarini Mohapatra12y ago
List basicdetails = (from records in db.NCBAccountDocuments
where records.CustomerReferenceNo == CustomerId
select records.documenttype ).ToList();
Sasi Reddy12y ago
I have done like that also,but it is giving error at List
Lakshmanan Sethu Sankaranarayan12y ago
Please mention the column name in records.columnname)ToList().