How do I return this IQueryable query?

Question

0.00/5 (No votes)

See more:

Hi,

I have this entity query and I want to capture the result so that I can use it in an if else statement or where ever.

C#

private AH_ODS_DB_Entities db = new AH_ODS_DB_Entities();
IQueryable rs = db.Transmitals;
                    rs = db.Transmitals
                            .Select (sl => new Transmital { Serial = sl.Serial })
                            .Where  (sl => sl.Serial == 888)
                            .AsQueryable();

The way I look at it, it can execute the query but it returns an object. I want to put the result in a variable so I can use it in an if else statement or future purposes.

This is in a post method by the way. I am going to be comparing this result from a raw Json post from postman.

Edit:
Serials is a column in the Transmital table.

Posted 20-Apr-15 2:53am

Joshua Masa

Updated 20-Apr-15 3:23am

v3

Add a Solution

Comments

Sascha Lefèvre 20-Apr-15 9:16am

What do you want to get as a result? A collection of "Transmital"-objects?

Joshua Masa 20-Apr-15 9:22am

Yes, the Transmital table objects. Serial, by the way is a column in the Transmital table. I will add this in my question.

1 solution

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)

Sascha Lefèvre · Accepted Answer · 2015-04-20T03:36:00

This would get you a list of new (!) "Transmital"-objects, just like you created new objects in your posted code:

C#

private AH_ODS_DB_Entities db = new AH_ODS_DB_Entities();
List<Transmital> rs = db.Transmitals
                        .Where  (sl => sl.Serial == 888)
                        .Select (sl => new Transmital { Serial = sl.Serial })
                        .ToList();

Of course you would have to know if that's what you need - to me it looks like it might be by mistake. A query that returns the "original" objects would be this:

C#

private AH_ODS_DB_Entities db = new AH_ODS_DB_Entities();
List<Transmital> rs = db.Transmitals
                        .Where  (sl => sl.Serial == 888)
                        .ToList();

And then you could use rs in some if-statement. If all you would want to check in your if-statement was if there are any matching "Transmitals" then you could use a query that returns a bool instead:

C#

private AH_ODS_DB_Entities db = new AH_ODS_DB_Entities();
bool anyMatchingTransmitals = db.Transmitals
                                .Where  (sl => sl.Serial == 888)
                                .Any();

Likewise you could use .Count() instead of .Any() if you're interested in the amount of matching "Transmitals" (the return type would be int instead of bool then).

Does this help?