Click here to Skip to main content
12,882,639 members (25,842 online)
   

LINQ

 
AnswerRe: LINQ or ADO.NET ? Pin
Richard MacCutchan19-Aug-12 23:03
mvpRichard MacCutchan19-Aug-12 23:03 
AnswerRe: LINQ or ADO.NET ? Pin
thatraja20-Aug-12 0:39
mvpthatraja20-Aug-12 0:39 
GeneralRe: LINQ or ADO.NET ? Pin
manijasmine20-Aug-12 8:07
membermanijasmine20-Aug-12 8:07 
AnswerRe: LINQ or ADO.NET ? Pin
Kolkata .NET8-Mar-13 5:45
memberKolkata .NET8-Mar-13 5:45 
Questionhow to load and save an xml document using linq Pin
owobs15-Aug-12 1:57
memberowobs15-Aug-12 1:57 
AnswerRe: how to load and save an xml document using linq Pin
Wayne Gaylard15-Aug-12 2:16
mentorWayne Gaylard15-Aug-12 2:16 
QuestionCreating a dynamic where clause Pin
Simon_Whale9-Aug-12 0:06
memberSimon_Whale9-Aug-12 0:06 
AnswerRe: Creating a dynamic where clause Pin
Pete O'Hanlon9-Aug-12 0:22
protectorPete O'Hanlon9-Aug-12 0:22 
Simon, this is your lucky day. First of all, let's change your initial query like this:
var PeopleRecordsSearch = from SomePeople in Person()
                                          join SomeClient in Client() on SomePeople.PersonID equals SomeClient.PersonID
                                          select SomePeople;
Now, to search on the postcode, do this:
var postcodeSearch = (from people in PeopleRecordsSearch
where people.Postcode == Postcode
select people).ToList();
Similarly, to do your postcode search do this:
var surnameSearch = (from people in PeopleRecordsSearch
where people.Surname.Contains(Surname)
select people).ToList();
This works because the first query is actually an IQueryable, which means that it isn't executed (this is known as deferred execution). The beauty about this is that you can create a base query, and then refine it at a later stage.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos


CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 0:26
memberSimon_Whale9-Aug-12 0:26 
GeneralRe: Creating a dynamic where clause Pin
BobJanova9-Aug-12 2:11
memberBobJanova9-Aug-12 2:11 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 3:10
memberSimon_Whale9-Aug-12 3:10 
GeneralRe: Creating a dynamic where clause Pin
Pete O'Hanlon9-Aug-12 3:40
protectorPete O'Hanlon9-Aug-12 3:40 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 3:44
memberSimon_Whale9-Aug-12 3:44 
QuestionLinq where dates question Pin
Member 78188928-Jul-12 13:23
memberMember 78188928-Jul-12 13:23 
AnswerRe: Linq where dates question Pin
Pete O'Hanlon8-Jul-12 19:51
protectorPete O'Hanlon8-Jul-12 19:51 
AnswerRe: Linq where dates question Pin
BobJanova9-Jul-12 1:41
memberBobJanova9-Jul-12 1:41 
AnswerRe: Linq where dates question Pin
Matt T Heffron11-Jul-12 8:41
memberMatt T Heffron11-Jul-12 8:41 
AnswerRe: Linq where dates question Pin
Matt T Heffron27-Jul-12 14:35
memberMatt T Heffron27-Jul-12 14:35 
Questionlinq to sql connection string name Pin
rachel_m6-Jul-12 6:31
memberrachel_m6-Jul-12 6:31 
AnswerRe: linq to sql connection string name Pin
BobJanova9-Jul-12 1:42
memberBobJanova9-Jul-12 1:42 
QuestionConvert SQL to LINQ Pin
divesh123-Jul-12 9:47
memberdivesh123-Jul-12 9:47 
QuestionRe: Convert SQL to LINQ Pin
Naerling12-Jul-12 6:01
memberNaerling12-Jul-12 6:01 
AnswerRe: Convert SQL to LINQ Pin
thatraja20-Aug-12 0:32
mvpthatraja20-Aug-12 0:32 
AnswerRe: Convert SQL to LINQ Pin
Emmanuel Medina Lopez18-Sep-12 8:40
memberEmmanuel Medina Lopez18-Sep-12 8:40 
QuestionLinq to sql , one column is inserting NULL value , Pin
ooffooooo19-Jun-12 20:59
memberooffooooo19-Jun-12 20:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170422.1 | Last Updated 4 Mar 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid