EF4 and SQLite monitoring

2011-07-18 Thread Greg Keogh 
On a more sensible subject ... I've been building an app that uses Entity
Framework 4 and SQLite for the data layer. As I reported a few weeks ago,
I'm quite happy with the way the two work together. I guess I must mostly
thank the people who wrote the ADO.NET provider which is nicely compliant.

 

It's nice that EF4 and ORMs generally hide you from the low-level commands
being sent to the database, but as a developer, I'd like to know what the
traffic is down at the lower level. In code I can eager/lazy load related
data, perform complex nested deletes, etc, but I have no idea what's
actually happening under the covers.

 

I can't find any specific hooks in EF4 or SQLite to help me monitor the
underlying database commands, but I'm still looking. Has anyone else looked
into this issue?

 

Greg

Re: EF4 and SQLite monitoring

2011-07-18 Thread Jason Keats 
http://efprof.com/ ?

HTH

On 18/07/2011, at 17:09, "Greg Keogh"  wrote:

> On a more sensible subject ... I’ve been building an app that uses Entity 
> Framework 4 and SQLite for the data layer. As I reported a few weeks ago, I’m 
> quite happy with the way the two work together. I guess I must mostly thank 
> the people who wrote the ADO.NET provider which is nicely compliant.
> 
>  
> 
> It’s nice that EF4 and ORMs generally hide you from the low-level commands 
> being sent to the database, but as a developer, I’d like to know what the 
> traffic is down at the lower level. In code I can eager/lazy load related 
> data, perform complex nested deletes, etc, but I have no idea what’s actually 
> happening under the covers.
> 
>  
> 
> I can’t find any specific hooks in EF4 or SQLite to help me monitor the 
> underlying database commands, but I’m still looking. Has anyone else looked 
> into this issue?
> 
>  
> 
> Greg

RE: EF4 and SQLite monitoring

2011-07-18 Thread Greg Keogh 
http://efprof.com/ ?

 

Looks great, but it’s $305 and I only want to snoop into the underlying 
commands as a learning exercise. Oh, I just noticed it’s written by ‘Ayende’, I 
know that guy. If he has hooked into the EF4 processing flow somehow to create 
this tool, then perhaps I can find the magic hook and do the same thing for 
free on a much smaller scale.

 

Greg

Re: EF4 and SQLite monitoring

2011-07-18 Thread Grant Molloy 
Does that breach copyright?

On Mon, Jul 18, 2011 at 10:36 PM, Greg Keogh  wrote:

> http://efprof.com/ ?
>
> ** **
>
> Looks great, but it’s $305 and I only want to snoop into the underlying
> commands as a learning exercise. Oh, I just noticed it’s written by
> ‘Ayende’, I know that guy. If he has hooked into the EF4 processing flow
> somehow to create this tool, then perhaps I can find the magic hook and do
> the same thing for free on a much smaller scale.
>
> ** **
>
> Greg
>

Re: EF4 and SQLite monitoring

2011-07-18 Thread Stephen Liedig 
You can also buy a subscription which expires after a month.



On 19 July 2011 08:37, Grant Molloy  wrote:

> Does that breach copyright?
>
>
> On Mon, Jul 18, 2011 at 10:36 PM, Greg Keogh  wrote:
>
>> http://efprof.com/ ?
>>
>> ** **
>>
>> Looks great, but it’s $305 and I only want to snoop into the underlying
>> commands as a learning exercise. Oh, I just noticed it’s written by
>> ‘Ayende’, I know that guy. If he has hooked into the EF4 processing flow
>> somehow to create this tool, then perhaps I can find the magic hook and do
>> the same thing for free on a much smaller scale.
>>
>> ** **
>>
>> Greg
>>
>
>

RE: EF4 and SQLite monitoring

2011-07-18 Thread Greg Keogh 
>Does that breach copyright?

So if Ayende uses a documented technique to build a commercial product, then
I use the same technique to build a personal tool with no resemblance to his
... Well, if he claims I'm breaking his copyright, then I'll see him in the
Hague with Geoffrey Robertson defending me - Greg

RE: EF4 and SQLite monitoring

2011-07-18 Thread Greg Keogh 
Last night I found this:

 

Tracing and Caching Provider Wrappers for Entity Framework
 

 

This chap (from Microsoft I think) has written a data provider wrapper which
intercepts all ExecuteReader, ExecuteScalar and ExecuteNonQuery calls and
traces what's happening. This makes perfect sense, but it's quite heavy
handed and I was hoping that there would be a more specific and lightweight
place to hook in, either in SQLite or in EF4. If I try this wrapper provider
out I'll let you know what happens -- Greg

RE: EF4 and SQLite monitoring

2011-07-19 Thread Kirsten Greed 
What about temporarily switching to developer SQL server and looking at the
profiler?

 

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Tuesday, 19 July 2011 3:37 PM
To: 'ozDotNet'
Subject: RE: EF4 and SQLite monitoring

 

Last night I found this:

 

Tracing and Caching <http://code.msdn.microsoft.com/EFProviderWrappers>
Provider Wrappers for Entity Framework

 

This chap (from Microsoft I think) has written a data provider wrapper which
intercepts all ExecuteReader, ExecuteScalar and ExecuteNonQuery calls and
traces what's happening. This makes perfect sense, but it's quite heavy
handed and I was hoping that there would be a more specific and lightweight
place to hook in, either in SQLite or in EF4. If I try this wrapper provider
out I'll let you know what happens -- Greg



__ Information from ESET NOD32 Antivirus, version of virus signature
database 6305 (20110718) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com