Click here to Skip to main content
12,998,054 members (59,551 online)
   

LINQ

 
AnswerRe: LinQ: sub items and root in DataTable Pin
Member 1153153721-Mar-15 21:47
memberMember 1153153721-Mar-15 21:47 
QuestionLINQ Query / "between" dates Pin
mebjen18-Nov-12 7:17
membermebjen18-Nov-12 7:17 
AnswerRe: LINQ Query / "between" dates Pin
Matt T Heffron18-Nov-12 12:52
memberMatt T Heffron18-Nov-12 12:52 
QuestionComma separeted text file Pin
marca29212-Nov-12 19:59
membermarca29212-Nov-12 19:59 
AnswerRe: Comma separeted text file Pin
savbace10-Jan-13 22:44
membersavbace10-Jan-13 22:44 
QuestionThe type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin Pin
dotnet9516-Oct-12 14:28
memberdotnet9516-Oct-12 14:28 
AnswerRe: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin Pin
Richard Deeming22-Oct-12 2:19
memberRichard Deeming22-Oct-12 2:19 
QuestionLINQ Pin
JabbarJahambana3-Oct-12 22:04
memberJabbarJahambana3-Oct-12 22:04 
AnswerRe: LINQ Pin
Pete O'Hanlon3-Oct-12 22:22
protectorPete O'Hanlon3-Oct-12 22:22 
AnswerRe: LINQ Pin
ProgramFOX5-Oct-12 5:33
memberProgramFOX5-Oct-12 5:33 
AnswerRe: LINQ Pin
emma926-Dec-12 6:23
memberemma926-Dec-12 6:23 
AnswerRe: LINQ Pin
tunheo24-Dec-12 22:17
membertunheo24-Dec-12 22:17 
GeneralMessage Automatically Removed Pin
12-Feb-13 20:09
memberMahesh Sellamuthu12-Feb-13 20:09 
Suggestionlinq to sql obtain foreign key value Pin
sc steinhayse24-Aug-12 19:40
membersc steinhayse24-Aug-12 19:40 
In a C# 2010 application that I am working on, I want to use linq to sql to update 2 tables in a sql server 2008 database.

I want to do the following:
create new Table1 object ;
InsertOnSubmit(tbl1)
**Table 1 will contain the primary key.
create new Table2 object;
table2 will contain a foreign key column that refers to primary key in
table1 object.
InsertOnSubmit(tbl2)
SubmitChanges()

Before and/or right after the submitchanges() event occurs, I would like to know what the value is for the primary key in table1 and the foreign key value is in table2. I would like to know what the table key value is so I can display this information on reports that will be generated right after the record(s) have been inserted into the database. Thus can you tell me how to determine what the primary key value is for table1 that also refers to the foreign key value in table 2?
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 
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 

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.170622.1 | Last Updated 4 Mar 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid