|
Hi,
How i need to write this query with linq-
<br />
SELECT Id<br />
From Persons<br />
WHERE FirstName IN ('Name1', 'Name2', 'Name3')<br />
i don't know how to translate the IN statment.
Can someone please help me?
|
|
|
|
|
As far as I know: you can't. That's a limitation of LINQ.
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
|
Make an in memory collection of your list and then join it in LINQ.
That said, LINQ sucks, use SQL.
|
|
|
|
|
Can you please explain?
|
|
|
|
|
"IN" isn't any better in SQL. There's no easy way to implement IN clause in .NET when interacting with database.
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: That said, LINQ sucks, use SQL.
I've always wanted to here another developer say that! In fact, I would love for codeproject to do a survey on how many developers even use LINQ.
The mind is like a parachute. It doesn’t work unless it’s open.
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: That said, LINQ sucks, use SQL.
LINQ to SQL yes kind of sucks for me too.
But LINQ to objects(lists, collections etc) rocks and also LINQ to XML rocks.
At least for me.
I bug
|
|
|
|
|
In general you should never have a list in memory large enough for LINQ to be beneficial. And specifically, for the cases where you should, a specialized data structure is more appropriate. LINQ only solves one problem and that problem is how to sell MS licenses to companies.
That being said, I am guilty of using LINQ on rare occasions.
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: In general you should never have a list in memory large enough for LINQ to be beneficial
Yeah I know that. You're right(not left).
But even on a smaller list I very much prefer:
var something = from rec in datas
where rec.SomeProp >= SomeValue
select new { Name = rec.Name, Amount = rec.Amont;}
than creating a new type/class for that incomplete data type and then manually yielding/foreachingMDL
I'm not happy with anything slower than a BinarySearch so I too create
very specialized data/object model(s).
But for add on's or temporary stuff I prefer Linq over manual creation.
I bug
modified on Thursday, August 12, 2010 6:37 PM
|
|
|
|
|
Write your own extension method, if it's that important to ya...
public static bool IsIn(this object obj, params object[] args)
{
foreach (object a in args)
if (obj == a) return true;
return false;
}
Or something like that.
|
|
|
|
|
Hi,
Look up "Contains" for a linq statement. That inserts an "IN" statement for SQL.
|
|
|
|
|
from p in Persons where new string[]{"Name1","Name2","Name3"}.Contains(p.FirstName) select p.Id
|
|
|
|
|
Hi
In ASP.Net how to get the end user host name when they make any request to my web site? So that i can filter them at HttpModule level by allowing people from one particular domain can only access my website.
|
|
|
|
|
|
My thingies aren't up , I got an error !
I know nothing , I know nothing ...
|
|
|
|
|
|
Then Raise Shields! Arm Photon Torpedoes! And Damn the Tribbles to hell!
Alternatively, you could try giving a little detail for those of us that can't read minds...
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
Stark DaFixzer wrote: My thingies aren't up , I got an error !
Quoted for posterity. Now, what the hell are you on?
|
|
|
|
|
your thingies will hang around as always
|
|
|
|
|
See you doctor about a prescription for Viagra.
|
|
|
|
|
That's the problem, he did and now it's lasted for more than four hours
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
OK , I have a computer a white one
And I got that little software thing , and when I click it; it didn't work , I click it and didn't work
I click it and didn't work , I click and didn't work , I click and didn't work ,
I click it and didn't work , I click and didn't work , I click and didn't work
I click it and didn't work , I click and didn't work , I click and didn't work
all I got are some gibberish written over it now. It's gray
The little thing saying "OK". But I think it didn't talking the truth.
I know nothing , I know nothing ...
|
|
|
|
|
Stark DaFixzer wrote: I have a computer a white one
Why do we care what color computer you have?
Stark DaFixzer wrote: I click it and didn't work , I click and didn't work
Being vague once was more than enough.
Stark DaFixzer wrote: I got that little software thing
Care to be more specific?
Stark DaFixzer wrote: all I got are some gibberish written over it now
Strange, I'm getting the same thing.
Stark DaFixzer wrote: The little thing saying "OK". But I think it didn't talking the truth.
Sure it is. Everything will be ok. Just bring your towel and don't panic!
|
|
|
|
|
Put the drugs down and walk away from the computer. The voices will stop after a few hours...trust me.
|
|
|
|
|
hello
How can you compile say for example SomeProgram.exe, which references A.dll/B.dll/C.dll, into one single executable/exe which includes the dll as embedded resources as well (i.e. no separate dll, just single exe)
Thanks
dev
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
