IT:AD:EF:Queries

• (UP)

  • IT:AD:EF:Concepts
    • db__model__or_code_first
    • IT:AD:EF:Concepts:Associations
    • IT:AD:EF:Concepts:Configuration
    • IT:AD:EF:Concepts:DbContext versus ObjectContext
    • IT:AD:EF:Concepts:EDMX File
    • IT:AD:EF:Concepts:State Tracking
  • IT:AD:EF:FAQ
    • can_i_create_self_tracking_entities_in_.net35_
    • how_does_one_install_t4_syntax_highlighting_
    • what_about_datasets_and_datatables_
  • IT:AD:EF:HowTo
    • IT:AD:EF:HowTo/Configure the App.Config Settings
    • IT:AD:EF:HowTo:Access ObjectContext from DbContext
    • IT:AD:EF:HowTo:Build up queries progressively using AND and OR statements
    • IT:AD:EF:HowTo:Create a database from the Model
    • IT:AD:EF:HowTo:Create a Model from a Database
    • IT:AD:EF:HowTo:Include Related Entities in Queries
    • IT:AD:EF:HowTo:Increment Counters
    • IT:AD:EF:HowTo:Keep the Same Connection
    • IT:AD:EF:HowTo:Log the SQL Statements
    • IT:AD:EF:HowTo:Move the Generation of Entities to a Domain.Entities Assembly
    • IT:AD:EF:HowTo:Optimize
    • IT:AD:EF:HowTo:Perform Hierarchical Queries
    • IT:AD:EF:HowTo:Queries/Compare Null or Empty Strings
    • IT:AD:EF:HowTo:Query
    • IT:AD:EF:HowTo:Second Level Caching
    • IT:AD:EF:HowTo:Self Tracking Entities over WCF
    • IT:AD:EF:HowTo:Update the Model after Database Changes
    • IT:AD:EF:HowTo:Use a DbContext across Threads
    • IT:AD:EF:HowTo:Use Transactions
    • IT:AD:EF:HowTo:Work with Multiple Diagrams per Model
    • IT:AD:EF:HowTo:Work with Proxies
    • IT:AD:EF:HowTo:Work with Stored Procs
    • IT:AD:EF:HowTo:Work with the POCO Entity Template
  • IT:AD:EF:Querying
    • IT:AD:EF:Querying:Stored Procedures
  • IT:AD:EF/Glossary
  • IT:AD:EF:DatabaseFirst
  • IT:AD:EF:ModelFirst
  • IT:AD:EF:Queries
  • IT:AD:EF:Transactions
  • modelfirst_ste_over_wcf
  • Resources

## Loading of Graphs (Lazy v. Explicit Loading of related tables) ##

Related entities can be loaded implicitly (lazy loading) or explicitly.

See Queries

## Returning Anonymous / 'mini-Entities' ##

As expressed here: LINQ one can return smaller objects:

//using anonymous objects:
data.Where(x=>x.Last =="Smith").Select(x=>new F=x.First, L=x.Last).Dump();
//using specific objects:
data.Where(x=>x.Last =="Smith").Select(x=>new Y F=x.First, L=x.Last).Dump();