Convertin Linq to Object to a generic object problems

Question

0.00/5 (No votes)

See more:

I'm having a problem with a conversion from linq to generic object, and it just fails here, I've others linqs querys and they work just fine.

I don't find where the bug is and I've tried several ways to do the same. The code that is failing is this:

SQL

var queryT = from proc in DataContext.Procedimentos
                                 join ass in DataContext.Assistencias on proc.assistencia equals ass.codigo
                                 join mac in DataContext.Maquinas on ass.maquina equals mac.SN
                                 where ass.maquina == maq.SN
                                 select proc;

C#

foreach (object procce in queryT)
                            {
                                Procedimento proccess = (Procedimento)procce;
                                TimeSpan span = proccess.fim.Subtract(proccess.inicio);
                                tempo = tempo + span.TotalHours;
                            }

throws InvalidCastException in the foreach instrution

but when in debug mode I write in the watch (object)queryT.First() and it works

Posted 10-Nov-10 3:42am

angelikPhil

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

angelikPhil · Answer 1 · 2010-11-10T04:00:00

Solution 1

Ok, found the problem, the problem was not in that code, but in the SQL table, one field had a different type from the class Procedimento...

Everything works now

Posted 10-Nov-10 4:00am

angelikPhil

#realJSOP · Answer 2 · 2010-11-10T04:01:00

Try this:

List<object> queryT = null;
queryT = (from proc in DataContext.Procedimentos
          join ass in DataContext.Assistencias on proc.assistencia equals ass.codigo
          join mac in DataContext.Maquinas on ass.maquina equals mac.SN
          where ass.maquina == maq.SN
          select proc).ToList();

foreach...</object>