.ToList - 'IEnumerable<dynamic>' does not contain a definition for 'ToList'

Question

User379720387 posted

holdIps is a IEnumberable<dynamic> holding a series of IP addresses

holdIps.ToList() gives an exception "'IEnumerable<dynamic>' does not contain a definition for 'ToList' and no accessible extension method 'ToList' accepting a first argument of type 'IEnumerable<dynamic>'"

var holdIps = db.Query("SELECT DISTINCT regIp FROM ProfileHOLD");

if (holdIps.ToList().Contains(trueIP)) { isHoldIp = true; }

I have a using System.Linq;

Answer 1

User475983607 posted

The raw query syntax does not look correct.  What version of Entity Framework are you using?

Answer 2

User379720387 posted

It is not EF.

Just a WebMatrix WebPages IEnumerable.

Answer 3

User475983607 posted

Perhaps check if the query returned any results but the error indicates you are missing a LINQ extension reference..

var holdIps = db.Query("SELECT DISTINCT regIp FROM ProfileHOLD");
isHoldIp = holdIps.Any(m => m == trueIP);

Answer 4

User-719153870 posted

Hi wavemaster,

System.Linq can be .net framework version affected. I suggest you could check the target framework of your current project maybe it's too old, if is then update to the latest version available.

Or are you using the Microsoft Webmatrix which is not supported instead of VS? If so, you should update your develop environment then, try Visual Studio.

Best Regard,

Yang Shen

Answer 5

User379720387 posted

It appears that a Web Pages IEnumerable cannot be used with .Contains

Changing my query over to Linq.

Yes, I am using VS, just mentioned WebMatrix in conjunction with Web Pages to make it clear what I have. Web Pages by itself does have very little explanatory value.