Solved

Linq To EF - Too Good?

Posted on 2011-02-22
3
387 Views
Last Modified: 2013-11-11
I don't like to look a gift-horse in the mouth, but...Customers-Invoices, tables+EF objects. I make a request for list Invoices, watching SQL Profiler like hawk, get the list, QuickWatch on one Invoice, see the related Customer object, pop the + sign, and I get the Customer full object, but I don't see any action in the profiler????
Where is it getting the data from?
(I'm no expert on SQL Profiler, I'm using the freebie one AnjLab with two Events selected only, SQLBatchStart + SQLBatchComplete )
0
Comment
Question by:Silas2
3 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 125 total points
ID: 34952134
The commands won't be run as a batch. You need to be watching for statement based events, although i'm not sure precisely what they will be named in the AnjLab version.
0
 
LVL 10

Assisted Solution

by:John Claes
John Claes earned 125 total points
ID: 34952172
Entity framework gets his data Through the folowing application Name : .Net SCLCLient Data Provider
RPC:Completed gives you the query that has ran

I'm using the standard template in the Profiler.
0
 
LVL 62

Expert Comment

by:Fernando Soto
ID: 34952410
It depends on how the query was set up to include or not to include child entities. Can you post the code you used including the instantiation of the ObjectContext.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Error on link 14 40
C# Single Form 8 29
Where can I ask about my ASP.NET MVC project? 6 23
How to join on ID, with prefix? 15 0
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now