Click here to Skip to main content
15,304,157 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to use linq to write this sql sentence Pin
Dave Kreskowiak15-Oct-13 8:44
mveDave Kreskowiak15-Oct-13 8:44 
GeneralRe: How to use linq to write this sql sentence Pin
Shameel16-Oct-13 19:57
professionalShameel16-Oct-13 19:57 
GeneralRe: How to use linq to write this sql sentence Pin
Dave Kreskowiak17-Oct-13 1:09
mveDave Kreskowiak17-Oct-13 1:09 
GeneralRe: How to use linq to write this sql sentence Pin
Pete O'Hanlon15-Oct-13 20:46
mvaPete O'Hanlon15-Oct-13 20:46 
GeneralRe: How to use linq to write this sql sentence Pin
Shameel16-Oct-13 19:55
professionalShameel16-Oct-13 19:55 
GeneralRe: How to use linq to write this sql sentence Pin
Dave Kreskowiak17-Oct-13 3:25
mveDave Kreskowiak17-Oct-13 3:25 
AnswerRe: How to use linq to write this sql sentence Pin
Mycroft Holmes12-Oct-13 13:30
professionalMycroft Holmes12-Oct-13 13:30 
AnswerRe: How to use linq to write this sql sentence Pin
CodeBlack14-Oct-13 2:46
professionalCodeBlack14-Oct-13 2:46 
you don't have to make join if you have maintained primary and foreign key between parent and child tables.

For example
Parent Table : A
Fields : a1 (pk), a2, a3

Child Table : B
Fields : b1 (pk), a1 (fk), b2, b3

Then your linq query would be as mentioned below :

C#
var t = (from a in Enities.A
         select 
              a.a1, 
              a.a2, 
              a.a3, 
              a.B.b1, 
              a.B.b2, 
              a.B.b3 )

Regards,
CodeBlack

GeneralRe: How to use linq to write this sql sentence Pin
Dave Kreskowiak14-Oct-13 6:32
mveDave Kreskowiak14-Oct-13 6:32 
QuestionPaging in GridControl of DevExpress Pin
nhanlaptrinh11-Oct-13 22:19
Membernhanlaptrinh11-Oct-13 22:19 
AnswerRe: Paging in GridControl of DevExpress Pin
OriginalGriff11-Oct-13 23:43
mveOriginalGriff11-Oct-13 23:43 
QuestionRe: Paging in GridControl of DevExpress Pin
Richard MacCutchan12-Oct-13 2:38
mveRichard MacCutchan12-Oct-13 2:38 
AnswerRe: Paging in GridControl of DevExpress Pin
OriginalGriff12-Oct-13 3:22
mveOriginalGriff12-Oct-13 3:22 
GeneralRe: Paging in GridControl of DevExpress Pin
nhanlaptrinh13-Oct-13 16:18
Membernhanlaptrinh13-Oct-13 16:18 
QuestionExport GridView to Excel cause System.OutOfMemoryException Pin
ptvce11-Oct-13 21:38
Memberptvce11-Oct-13 21:38 
AnswerRe: Export GridView to Excel cause System.OutOfMemoryException Pin
OriginalGriff11-Oct-13 22:14
mveOriginalGriff11-Oct-13 22:14 
GeneralRe: Export GridView to Excel cause System.OutOfMemoryException Pin
ptvce12-Oct-13 0:06
Memberptvce12-Oct-13 0:06 
GeneralRe: Export GridView to Excel cause System.OutOfMemoryException Pin
OriginalGriff12-Oct-13 0:15
mveOriginalGriff12-Oct-13 0:15 
Questionquestion Pin
har9211-Oct-13 19:03
Memberhar9211-Oct-13 19:03 
AnswerRe: question Pin
Abhinav S11-Oct-13 21:24
MemberAbhinav S11-Oct-13 21:24 
AnswerRe: question Pin
Dave Kreskowiak12-Oct-13 4:58
mveDave Kreskowiak12-Oct-13 4:58 
AnswerRe: question Pin
CodeBlack14-Oct-13 3:15
professionalCodeBlack14-Oct-13 3:15 
Questioncoreaudio.dll Pin
binoyvijayan11-Oct-13 4:47
Memberbinoyvijayan11-Oct-13 4:47 
SuggestionRe: coreaudio.dll Pin
Richard MacCutchan11-Oct-13 5:40
mveRichard MacCutchan11-Oct-13 5:40 
GeneralRe: coreaudio.dll Pin
binoyvijayan15-Oct-13 0:05
Memberbinoyvijayan15-Oct-13 0:05 

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.