Solved

Linq To EF - Too Good?

Posted on 2011-02-22
3
390 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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