|
So I gave her a grocery list in LINQ
var query_where1 = (
from item in Grocery.Store
where item.Price < 1.99
where item.Fresh == true
where item.Type.Contains("Produce")
select item).Take(5);
Which she really didn't care for; and I followed up with it in SQL
SELECT TOP 5 *
FROM Grocery.Store
WHERE Price < 1.99
AND Fresh = 1
AND Type = 'Produce'
I think she understands now
|
|
|
|
|
I know what you mean, I prefer to use the Linq methods as well - the Linq syntax is just a PITA to read.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
+1 
|
|
|
|
|
Please forgive my lack of markdownability....
|
|
|
|
|
My girlfriend asked me why I cursed at LINQ and I told her to get in the kitchen and make me a sandwich.
|
|
|
|
|
But she had to do the shopping first so she could make the sandwich...
I didn't dare want to make her do UNION's with the bakery and the cheese factory
|
|
|
|
|
I do wish SQL would allow multiple WHEREs in place of ANDs -- just to assist with developing queries I'm working on in SSMS and I want to experiment with various WHERE clauses.
|
|
|
|
|
I can see it both ways, when I'm in SSMS and playing with WHERE options I end up with
SELECT * FROM Table
WHERE
-- FirstName = 'Herman'
-- AND
LastName = 'Munster'
|
|
|
|
|
Right, so sometimes I wind up making
SELECT * FROM Table
WHERE 1=1
AND LastName = 'Munster'
just so I have flexibility while I experiment.
|
|
|
|
|
And how would you handle ORs?
|
|
|
|
|
In the water, of course...(stroke! stroke! stroke!....) 
__________________
Lord, grant me the serenity to accept that there are some things I just can’t keep up with, the determination to keep up with the things I must keep up with, and the wisdom to find a good RSS feed from someone who keeps up with what I’d like to, but just don’t have the damn bandwidth to handle right now.
© 2009, Rex Hammock
modified 28-Apr-17 17:46pm.
|
|
|
|
|
I hardly ever need to. Sometimes a I need an IN, but rarely an OR. And I'm not saying remove AND and OR, just make any additional WHEREs act as ANDs.
|
|
|
|
|
When I'm testing out filters I'm usually starting with WHERE 1=1 and add all conditions with an AND.
But I can see what you're getting at.
<edit>Just as you answered to Madmyche</edit>
|
|
|
|
|
Don't take them for granted. Making them read code and all.
|
|
|
|
|
MadMyche wrote: I think she understands now
or:
(select bacon).take(all) 
Marc
Latest Article - Merkle Trees
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
I would throw an Flavor Overflow Exception at pound #10 error
|
|
|
|
|
That's why it's called programming and not laymen language.
|
|
|
|
|
Girlfriend 1, MadMyche 0
Get ready to pay up.
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
Looks to me just a simple matter of different syntax. One does not appear to be any more succinct or easier to read than the other.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
DavidCrow wrote: One does not appear to be any more succinct
One appears blatantly more succinct.
Swap the simple example for a real query and you'll be seeing complete proza.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Don't use that convoluted Linq syntax and instead just use the static methods. Code looks way cleaner that way.
|
|
|
|
|
Why Type = 'Produce' became item.Type.Contains("Produce")?
Shouldn't it become item.Type == "Produce" ?
|
|
|
|
|
(singing) "America. Russia. Spain and France..."
I've always wanted to be a Country singer!  
|
|
|
|
|
It's not spam.
It's not trolling.
It's KSS.
Still, there must surely be a way to report you for this and induce punishment.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
KSS?! Not a country I've heard of...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
