nerdexam
Microsoft

70-516 · Question #166

You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL. The Product entity in the LINQ to SQL model contains a field named Productlmage. The Productlmage field holds a…

The correct answer is C. Set the Delay Loaded property on the Productlmage property of the Product entity to True. Lazy loading is configured in the LINQ to SQL designer by selecting an entity and then, in the Properties window, setting the Delay Loaded property to true.The Delay Loaded property indicates that you want lazy loading of the column. CHAPTER 4 LINQ to SQL Lesson 1: What Is LINQ…

Implementing Data Access

Question

You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL. The Product entity in the LINQ to SQL model contains a field named Productlmage. The Productlmage field holds a large amount of binary data. You need to ensure that the Productlmage field is retrieved from the database only when it is needed by the application. What should you do?

Options

  • ASet the Update Check property on the Productlmage property of the Product entity to Never.
  • BSet the Auto-Sync property on the Productlmage property of the Product entity to Never.
  • CSet the Delay Loaded property on the Productlmage property of the Product entity to True.
  • DWhen the context is initialized, specify that the Productlmage property should not be retrieved

How the community answered

(25 responses)
  • A
    12% (3)
  • B
    8% (2)
  • C
    76% (19)
  • D
    4% (1)

Explanation

Lazy loading is configured in the LINQ to SQL designer by selecting an entity and then, in the Properties window, setting the Delay Loaded property to true.The Delay Loaded property indicates that you want lazy loading of the column. CHAPTER 4 LINQ to SQL Lesson 1: What Is LINQ to SQL? Eager Loading vs. Lazy Loading (page 254)

Topics

#LINQ to SQL#deferred loading#Delay Loaded#binary data

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice