Click here to Skip to main content
15,907,392 members
Home / Discussions / C#
   

C#

 
GeneralRe: extending a special case of a generic type Pin
Alexander Kindel6-Jan-18 2:39
Alexander Kindel6-Jan-18 2:39 
AnswerRe: extending a special case of a generic type Pin
jschell6-Jan-18 6:06
jschell6-Jan-18 6:06 
GeneralRe: extending a special case of a generic type Pin
Alexander Kindel6-Jan-18 8:28
Alexander Kindel6-Jan-18 8:28 
GeneralRe: extending a special case of a generic type Pin
jschell8-Jan-18 14:59
jschell8-Jan-18 14:59 
QuestionProblem with click event of a button on C # Pin
BEN SBAI5-Jan-18 13:41
BEN SBAI5-Jan-18 13:41 
AnswerRe: Problem with click event of a button on C # Pin
Jim Meadors5-Jan-18 16:06
Jim Meadors5-Jan-18 16:06 
AnswerRe: Problem with click event of a button on C # Pin
OriginalGriff5-Jan-18 20:04
mveOriginalGriff5-Jan-18 20:04 
AnswerRe: Problem with click event of a button on C # Pin
BillWoodruff5-Jan-18 21:33
professionalBillWoodruff5-Jan-18 21:33 
GeneralRe: Problem with click event of a button on C # Pin
OriginalGriff5-Jan-18 21:46
mveOriginalGriff5-Jan-18 21:46 
GeneralRe: Problem with click event of a button on C # Pin
BillWoodruff6-Jan-18 2:46
professionalBillWoodruff6-Jan-18 2:46 
QuestionDisabling events of objects stored in array Pin
Pogoodill5-Jan-18 2:32
Pogoodill5-Jan-18 2:32 
AnswerRe: Disabling events of objects stored in array Pin
OriginalGriff5-Jan-18 3:14
mveOriginalGriff5-Jan-18 3:14 
GeneralRe: Disabling events of objects stored in array Pin
Pogoodill5-Jan-18 3:55
Pogoodill5-Jan-18 3:55 
AnswerRe: Disabling events of objects stored in array Pin
OriginalGriff5-Jan-18 4:59
mveOriginalGriff5-Jan-18 4:59 
GeneralRe: Disabling events of objects stored in array Pin
Pogoodill5-Jan-18 6:13
Pogoodill5-Jan-18 6:13 
AnswerRe: Disabling events of objects stored in array Pin
BillWoodruff6-Jan-18 2:12
professionalBillWoodruff6-Jan-18 2:12 
AnswerRe: Disabling events of objects stored in array Pin
Gerry Schmitz6-Jan-18 6:55
mveGerry Schmitz6-Jan-18 6:55 
QuestionGet current point in time in recurring time interval. Pin
Member 136084655-Jan-18 2:10
Member 136084655-Jan-18 2:10 
AnswerRe: Get current point in time in recurring time interval. Pin
Ralf Meier5-Jan-18 2:38
mveRalf Meier5-Jan-18 2:38 
AnswerRe: Get current point in time in recurring time interval. Pin
Gerry Schmitz6-Jan-18 7:06
mveGerry Schmitz6-Jan-18 7:06 
QuestionHow to fetch master detail data using EF and LINQ Pin
Mou_kol5-Jan-18 0:15
Mou_kol5-Jan-18 0:15 
AnswerRe: How to fetch master detail data using EF and LINQ Pin
Vincent Maverick Durano5-Jan-18 2:20
professionalVincent Maverick Durano5-Jan-18 2:20 
Your example should should theoretically work. Here's an example using join with syntax-based query in EF:

C#
var order = (from o in _ctx.order
                 join od in _ctx.orderdetails on o.OrderID equals od.OrderID
                 where o.OrderID == _OrderID).ToList();


To select specific fields, you could either use an anonymous type object like this:

C#
var order =  _ctx.order
            .Include(x => x.orderdetails)
            .Where(x => x.OrderID== _OrderID)
            .Select(x => new
            {
                 OrderID = x.OrderID,
                 SomeColumn = x.SomeColumn1,
                 SomeColumn2 =  x.SomeColumn1
            }).ToList();	 


Or use a strongly-typed object like this:

C#
var order =  _ctx.order
            .Include(x => x.orderdetails)
            .Where(x => x.OrderID== _OrderID)
            .Select(x => new OrderDetail
            {
                 OrderID = x.OrderID,
                 SomeColumn = x.SomeColumn1,
                 SomeColumn2 =  x.SomeColumn1
            }).ToList();	 


Noticed that the Select clause now use the OrderDetail. The OrderDetail is just a class that holds the properties that you want to use in your query.

For more information and examples on EF, I would recommend you to head over to the official documentation here: Entity Framework | Microsoft Docs[^]
GeneralRe: How to fetch master detail data using EF and LINQ Pin
Mou_kol6-Jan-18 6:08
Mou_kol6-Jan-18 6:08 
GeneralRe: How to fetch master detail data using EF and LINQ Pin
Vincent Maverick Durano8-Jan-18 15:33
professionalVincent Maverick Durano8-Jan-18 15:33 
QuestionPetaPoco (T4 Template) in .Net Core 2.0 for MSql : - SerializationException in generating Database.cs Pin
J Kaur4-Jan-18 15:18
J Kaur4-Jan-18 15:18 

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.