C# 6 and .NET Core 1.0: Modern Cross-Platform Development by Mark J. Price

Author:Mark J. Price
Language: eng
Format: epub, pdf
Publisher: Packt Publishing

This is due to a feature of EF known as lazy loading.

Uncomment the logging line and rerun the application. You will notice that when the code accesses the Products property, EF automatically checks to see whether they are loaded. If not, EF loads them for us "lazily."

For example, just before outputting the count of seafood products, this query is executed:

SELECT [Extent1].[ProductID] AS [ProductID], [Extent1].[ProductName] AS [ProductName], [Extent1].[SupplierID] AS [SupplierID], [Extent1].[CategoryID] AS [CategoryID], [Extent1].[QuantityPerUnit] AS [QuantityPerUnit], [Extent1].[UnitPrice] AS [UnitPrice], [Extent1].[UnitsInStock] AS [UnitsInStock], [Extent1].[UnitsOnOrder] AS [UnitsOnOrder], [Extent1].[ReorderLevel] AS [ReorderLevel], [Extent1].[Discontinued] AS [Discontinued] FROM [dbo].[Products] AS [Extent1] WHERE [Extent1].[CategoryID] = @EntityKeyValue1 -- EntityKeyValue1: '8' (Type = Int32, IsNullable = false) -- Executing at 30/08/2015 14:16:26 +01:00 -- Completed in 0 ms with result: SqlDataReader Seafood has 12 products.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.