Click here to Skip to main content
11,639,765 members (60,160 online)
   

LINQ

 
Suggestionlinq to sql obtain foreign key value Pin
sc steinhayse24-Aug-12 19:40
membersc steinhayse24-Aug-12 19:40 
GeneralRe: linq to sql obtain foreign key value Pin
rs_engg5-Sep-12 3:43
memberrs_engg5-Sep-12 3:43 
Questionminus returned value during executing a insert stored procedure Pin
Member 870070423-Aug-12 5:37
memberMember 870070423-Aug-12 5:37 
AnswerRe: minus returned value during executing a insert stored procedure Pin
Wes Aday23-Aug-12 6:00
memberWes Aday23-Aug-12 6:00 
AnswerRe: minus returned value during executing a insert stored procedure Pin
BobJanova23-Aug-12 6:14
memberBobJanova23-Aug-12 6:14 
QuestionLINQ or ADO.NET ? Pin
pashmakjoon19-Aug-12 10:11
memberpashmakjoon19-Aug-12 10:11 
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 
AnswerRe: Linq to sql , one column is inserting NULL value , Pin
Pete O'Hanlon19-Jun-12 23:55
protectorPete O'Hanlon19-Jun-12 23:55 
GeneralRe: Linq to sql , one column is inserting NULL value , Pin
abdul420-Jun-12 7:04
memberabdul420-Jun-12 7:04 
QuestionRuntime error Could not load file or assemly from Linq Entity constructor Pin
gmeiring17-Jun-12 9:13
membergmeiring17-Jun-12 9:13 
AnswerRe: Runtime error Could not load file or assemly from Linq Entity constructor Pin
Zac Greve12-Aug-12 17:59
memberZac Greve12-Aug-12 17:59 
Questionhow can write linq insert ,update,delete queries Pin
dipen mistry13-Jun-12 1:52
memberdipen mistry13-Jun-12 1:52 
AnswerRe: how can write linq insert ,update,delete queries Pin
Andy_L_J14-Jun-12 19:37
memberAndy_L_J14-Jun-12 19:37 
Questionlinq Pin
Sukanta201213-May-12 1:48
groupSukanta201213-May-12 1:48 
AnswerRe: linq Pin
Richard MacCutchan13-May-12 3:14
mvpRichard MacCutchan13-May-12 3:14 
AnswerRe: linq Pin
amitgajjar4-Jun-12 2:25
memberamitgajjar4-Jun-12 2:25 
AnswerRe: linq Pin
mr.priyank14-Jun-12 18:07
membermr.priyank14-Jun-12 18:07 
AnswerRe: linq Pin
Shelby Robertson 12-Jul-12 4:27
member Shelby Robertson 12-Jul-12 4:27 
JokeRe: linq Pin
Shelby Robertson 17-Jul-12 5:29
member Shelby Robertson 17-Jul-12 5:29 
QuestionRe: linq Pin
Pete O'Hanlon17-Jul-12 5:50
protectorPete O'Hanlon17-Jul-12 5:50 
GeneralRe: linq Pin
Shelby Robertson 17-Jul-12 5:57
member Shelby Robertson 17-Jul-12 5:57 
GeneralRe: linq Pin
csizo1-Aug-12 11:19
membercsizo1-Aug-12 11:19 
AnswerRe: linq Pin
ProgramFOX25-Sep-12 7:24
memberProgramFOX25-Sep-12 7:24 
QuestionWindows Forms, Entity Framework, Data Binding, threading Pin
Dana Gehm19-Apr-12 12:08
memberDana Gehm19-Apr-12 12:08 
QuestionHow can write vb SQL insert code in linq Pin
Member 802221810-Apr-12 1:37
memberMember 802221810-Apr-12 1:37 
AnswerRe: How can write vb SQL insert code in linq Pin
rafaelmartir16-Apr-12 11:25
memberrafaelmartir16-Apr-12 11:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web03 | 2.8.150731.1 | Last Updated 16 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid