Specified cast is not valid exception

Question

4.00/5 (1 vote)

See more:

Hi All,
I am using LINQ query to check ID(eventTypeID) from EventType table.
This is the query which I have written,while debugging it will throw the exception in this line,as 'specified cast is not valid'.

C#

EventType events = db.EventType.Single(f => f.eventTypeID == eventTypeID);

Does any one know why it is so??

Regards
Madhu

Posted 21-Dec-10 23:30pm

madhusudhan.k

Updated 21-Dec-10 23:48pm

Tarun.K.S

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ANSAL P R · Answer 1 · 2010-12-22T05:11:00

Solution 3

Hi Madhu,

Please Try This

EventType events = (from f in db.EventType where f.eventTypeID == eventTypeID select f).Single();

Posted 22-Dec-10 5:11am

ANSAL P R

Updated 23-Dec-10 14:18pm

v2

#realJSOP · Answer 2 · 2010-12-22T00:05:00

Solution 2

Try this:

C#

EventType events = (EventType)(db.EventType.SingleOrDefault(f => f.eventTypeID == eventTypeID));

Posted 22-Dec-10 0:05am

#realJSOP

Updated 22-Dec-10 0:06am

v2

Comments

madhusudhan.k 22-Dec-10 6:12am

Hi John Simmons,
Still it is throwing the same exception.
When I select the line & go to quick watch means it shows the value as 'Expression cannot contains lambda expressions'.

Regards
Madhu

Al-Farooque Shubho · Answer 3 · 2010-12-21T23:54:00

Solution 1

Try using the following (SingleOrDefault() method instead of Single() method):

EventType events = db.EventType.SingleOrDefault(f => f.eventTypeID == eventTypeID);

Posted 21-Dec-10 23:54pm

Al-Farooque Shubho

Comments

madhusudhan.k 22-Dec-10 6:00am

Hi Al-Farooque Shubho,
thanks for ur post. But still it is showing the same exception.
When I select the line & go to quick watch means it shows the value as 'Expression cannot contains lambda expressions'.

Regards
Madhu

Dalek Dave 23-Dec-10 20:19pm

Good Answer.

Specified cast is not valid exception

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Specified cast is not valid exception

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us