Click here to Skip to main content
       

LINQ

 
AnswerRe: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin PinmemberRichard Deeming22-Oct-12 2:19 
QuestionLINQ PinmemberJabbarJahambana3-Oct-12 22:04 
AnswerRe: LINQ PinprotectorPete O'Hanlon3-Oct-12 22:22 
AnswerRe: LINQ PinmemberProgramFOX5-Oct-12 5:33 
AnswerRe: LINQ Pinmemberemma926-Dec-12 6:23 
AnswerRe: LINQ Pinmembertunheo24-Dec-12 22:17 
GeneralMessage Automatically Removed PinmemberMahesh Sellamuthu12-Feb-13 20:09 
Suggestionlinq to sql obtain foreign key value Pinmembersc 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 Pinmemberrs_engg5-Sep-12 3:43 
Questionminus returned value during executing a insert stored procedure PinmemberMember 870070423-Aug-12 5:37 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberWes Aday23-Aug-12 6:00 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberBobJanova23-Aug-12 6:14 
QuestionLINQ or ADO.NET ? Pinmemberpashmakjoon19-Aug-12 10:11 
AnswerRe: LINQ or ADO.NET ? PinmvpRichard MacCutchan19-Aug-12 23:03 
AnswerRe: LINQ or ADO.NET ? Pinmvpthatraja20-Aug-12 0:39 
GeneralRe: LINQ or ADO.NET ? Pinmembermanijasmine20-Aug-12 8:07 
AnswerRe: LINQ or ADO.NET ? PinmemberKolkata .NET8-Mar-13 5:45 
Questionhow to load and save an xml document using linq Pinmemberowobs15-Aug-12 1:57 
AnswerRe: how to load and save an xml document using linq PinmentorWayne Gaylard15-Aug-12 2:16 
QuestionCreating a dynamic where clause PinmemberSimon_Whale9-Aug-12 0:06 
AnswerRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 0:22 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 0:26 
GeneralRe: Creating a dynamic where clause PinmemberBobJanova9-Aug-12 2:11 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 3:10 
GeneralRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 3:40 

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
Web04 | 2.8.140721.1 | Last Updated 27 Jun 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid