forum

Home / DeveloperSection / Forums / Convert a list to a string list

Convert a list to a string list

Anonymous User 2805 29-Mar-2014

var listID = from Ines in ineContext.IneDetailRecords

select Ines.InePIN.ToString().ToList();

string PIN = something;

if(!listID.Contains(PIN))

// save it to DB

InePIN is a cloumn in SQL Server DB, the type is varchar(20).

The exception is:

Instance argument: cannot convert from 'System.Linq.IQueryable<System.Collections.Generic.List<char>>' to 'System.Linq.ParallelQuery<string>'

Updated on 29-Mar-2014

I am a content writter !

Can you answer this question?

Answer

29-Mar-2014

Hi Ankita,

You need to apply the ToList method on result of query but not on the selected column i.e Ines.InePIN.ToString().ToList()

Change

var listID = from Ines in ineContext.IneDetailRecords
 select
Ines.InePIN.ToString().ToList();

var listID = (from Ines in ineContext.IneDetailRecords
 select
Ines.InePIN.ToString()).ToList();