EF making duplicate calls to database

Thu, 11 Jun 2009 22:11:56 Z

Hey,
I've got a really simple line of code that is supposed to grab all carriers in my database:

var

entities = db.Carrier.ToList();

For some reason, it's calling the database twice when executing this line of code, in profiler I see 2 instances of:

SELECT
[Extent1].[CarrierId] AS [CarrierId],
[Extent1].[CarrierName] AS [CarrierName],
[Extent1].[EmailAddress] AS [EmailAddress],
[Extent1].[CreateDate] AS [CreateDate],
[Extent1].[ModifiedDate] AS [ModifiedDate]
FROM [dbo].[Carrier] AS [Extent1]

Why is this happening and how do I get around it? I was under the impression that if you call db.Carrier, that shouldn't call the database at all until you call .ToList() on it, then it makes 1 call, but certainly not 2??

Even if I break it up and do this, it doesn't call the db on the first line but calls it twice on line 2 when just doing the .ToList()...

var

query = db.Carrier.Where(x => x.CarrierId > 0);

var entities = query.ToList();

Thanks for any help on this...

EF making duplicate calls to database

Fri, 12 Jun 2009 06:27:02 Z

How are you determining that it's calling the database twice?

- Danny

This posting is provided "AS IS" with no warranties, and confers no rights.

EF making duplicate calls to database

Fri, 03 Jul 2009 04:41:00 Z

I'm going to go ahead and mark this question as answered, but if you have a follow-up question, please unmark it as answered and provide more info.

This posting is provided "AS IS" with no warranties, and confers no rights.