Resources on ADO.NET Entity Framework 6

Resources on ADO.NET Entity Framework 6

Rate This
  • Comments 0

New Features in EF6

These are some of the more notable new features in EF6. For a complete list of changes see Version History.

Async Query & Save (EF Designer & Code First)
Asynchronous query and save using the async and await keywords.

Connection Resiliency / Retry Logic (EF Designer & Code First)
Automatically retry any commands that fail due to connection breaks .

Logging and Intercepting Database Operations (EF Designer & Code First)
Anytime EF sends a command to the database this command can be intercepted by application code .

Code-Based Configuration (EF Desigener & Code First)
Code-based configuration is achieved by creating a subclass of DbConfiguration .

Custom Code First Conventions (Code First only)
Write your own conventions to help avoid repetitive configuration. For more advanced scenarios you can use Model-Based Conventions.

Code First Insert/Update/Delete Stored Procedures (Code First only)
Configure EF to use stored procedures to update data.

Testing with a Mocking Framework (EF Designer & Code First)
Create test doubles using a mocking framework (such as Moq).

Testing with Your Own Test Doubles (EF Designer & Code First)
Write your own in-memory implementation of your context and DbSets .

Working with Transactions (EF Designer & Code First)
Learn how to control the use of trasactions with Entity Framework.

Connection Management (EF Designer & Code First)
Learn how to control connection open/close and work with existing database connections.

Customizing the Migrations History Table (Code First only)
Customize the definition of the __MigrationHistory table.

Custom Migrations Operations (Code First only)
Create additional operations to be used in your code-based migrations .

Dependency Resolution (EF Desigener & Code First)
Lower level building blocks that enable the Code-Based Configuration feature.

   

Learn More About Setting Up Your Model

Which Workflow Should I Use
Find out about the EF Designer and Code First and which one is best for you.

Connections and Models
Learn how EF works out which database to connect to and how to calculate the model.

Connection Resiliency / Retry Logic (EF6 onwards)
Automatically retry any commands that fail due to connection breaks .

Performance Considerations
Find out how to get the best performance out of Entity Framework.

Pre-Generated Mapping Views
Improve application warm-up time with pre-generated mapping views.

Working with Microsoft SQL Azure
There are a number of characteristics of SQL Azure that need to be taken into account when using EF.

Entity Framework Power Tools
The EF Power Tools provide a preview of features that are being considered for the main EF tooling.

Code-Based Configuration (EF6 onwards)
Code-based configuration is achieved by creating a subclass of DbConfiguration .

Configuration File Settings
EF allows a number of settings to be configured from your applications configuration file.

Dependency Resolution (EF Desigener & Code First)
Lower level building blocks that enable the Code-Based Configuration feature.

Glossary
Definition of terms that are commonly used when talking about Entity Framework.

Creating a Model with Code First

These topics are specific to models created using EF Code First.

Code First to a New Database
Use Code First to define your model in code and then generate a database.

Code First to an Existing Database
Use Code First to create a code based model that maps to an existing database.

Conventions
Find out about the conventions Code First uses to build your model.

Custom Code First Conventions (EF6 onwards)
Write your own conventions to help avoid repetitive configuration. For more advanced scenarios you can use Model-Based Conventions.

Data Annotations
Data Annotations provide a simple way to configure your model by applying attributes to your classes.

Fluent API - Configuring/Mapping Properties & Types
Learn how to configure properties/types and the columns/tables they map to using the Fluent API.

Fluent API - Configuring Relationships
Find out how to configure relationships and the foreign key constraints they map to using the Fluent API.

Fluent API with VB.NET
This walkthrough shows how to use the fluent API in VB.NET projects.

Code First Insert/Update/Delete Stored Procedures (EF6 onwards)
Configure EF to use stored procedures to update data.

Enum Support (EF5 Onwards)
The domain classes that make up your Code First model can contain enum properties.

Spatial Data Types (EF5 Onwards)
The DbGeography and DbGeometry types can be used in your model. Also see the information about provider support for spatial types.

Code First Migrations
Learn more about upgrading, downgrading and creating SQL scripts with Code First Migrations.

Code First Migrations in Team Environments
Learn how to successfully use migrations when working in a team of developers.

Automatic Code First Migrations
Automatic migrations allow you to upgrade your database without code-based migrations in your project.

Customizing the Migrations History Table (Code First only)
Customize the definition of the __MigrationHistory table.

Custom Migrations Operations (EF6 onwards)
Create additional operations to be used in your code-based migrations .

Migrate.exe
Use migrate.exe to apply migrations to a database from a command line.

Defining DbSets
Discover the various options for defining DbSets on your derived context.

Creating a Model with the EF Designer

These topics are specific to models created using the EF Designer.

EF Designer to a New Database (Model First)
Use Model First to define your model using boxes and lines and then generate a database.

EF Designer to an Existing Database (Database First)
Use Database First to create a boxes and lines model that maps to an existing database.

Complex Types
Find out how to group properties on your entities into complex types.

Associations/Relationships
Learn how to configure relationships in your model.

Enum Support (EF5 Onwards)
Using the EF Designer you can now add enum properties to your entities.

Spatial Data Types (EF5 Onwards)
The DbGeography and DbGeometry types can be used in your model. Also see the information about provider support for spatial types.

TPT Inheritance Pattern
Learn how to implement the Table-per-Type (TPT) inheritance pattern in your model.

TPH Inheritance Pattern
Learn how to implement the Table-per-Hierarchy (TPH) inheritance pattern in your model.

Query with Stored Procedures
Use stored procedures to load data from the database.

Stored Procedures with Multiple Result Sets
Use stored procedures with multiple result sets to load data from the database.

Insert, Update & Delete with Stored Procedures
Use stored procedures to insert, update and delete data.

Map an Entity to Multiple Tables (Entity Splitting)
Learn how to map the properties of an entity to columns in multiple tables.

Map Multiple Entities to One Table (Table Splitting)
Learn how to map the columns of a table to properties in multiple entities.

Table-Valued Functions (EF5 onwards)
Table-valued functions (TVFs) in your database can be used with models created using the EF Designer.

Multiple Diagrams per Model (EF5 onwards)
The EF Designer allows you to have several diagrams that visualize subsections of your overall model.

Defining Queries
A defining query is like a view that is defined in your model, rather than the database.

Code Generation Templates
Find out how to customize the code that is generated from your model.

Reverting to ObjectContext
New models created in VS2012 generate code that uses DbContext, but you can revert to ObjectContext.

EDMX Files
Covers properties of EDMX files and specification of the xml format (including CSDL, SSDL & MSL).

   

Learn More About Using Your Model

Working with DbContext
Guidance on how to manage instances of your context class.

Querying/Finding Entities
Learn how to retrieve data from the database using LINQ and the Find method.

Async Query & Save (EF6 onwards)
Asynchronous query and save using the async and await keywords.

Logging and Intercepting Database Operations (EF6 onwards)
Anytime EF sends a command to the database this command can be intercepted by application code .

Working with Relationships
Find out how to access and manipulate data using relationships.

Loading Related Entities
EF supports the eager, lazy and explicit loading patterns for loading related data.

Working with Local Data
Access your in-memory entity instances and the additional information EF is tracking about them.

N-Tier Applications
Learn how to use Entity Framework to build N-Tier applications, including Self-Tracking Entities.

Raw SQL Queries
Find out how to load data from a raw SQL query directly against the database.

Optimistic Concurrency Patterns
Learn about the various strategies for dealing with concurrency exceptions in EF.

Working with Proxies
Proxies derive from your entities and override virtual properties to enable features such as lazy loading.

Automatic Detect Changes
Find out what detect changes is and when you may want to disable automatic detect changes..

No-Tracking Queries
No-tracking allows you to query for entities without having the results be tracked by the context.

The Load Method
Load entities from the database into the context without immediately doing anything with those entities.

Add/Attach and Entity States
Get familiar with adding and attaching entities and setting entity states in disconnected/N-Tier scenarios.

Working with Property Values
Find out how to access the current, original and database values for your entity instances.

Testing with a Mocking Framework (EF6 onwards)
Create test doubles using a mocking framework (such as Moq).

Testing with Your Own Test Doubles (EF6 onwards)
Write your own in-memory implementation of your context and DbSets .

Working with Transactions (EF6 onwards)
Learn how to control the use of trasactions with Entity Framework.

Connection Management (EF6 onwards)
Learn how to control connection open/close and work with existing database connections.

API Documentation
Find out more about a particular namespace, class, property or method in Entity Framework.

   

Using EF With Other Technologies

ASP.NET MVC
EF provides the M (Model) in MVC.

ASP.NET Web API
Use EF and ASP.NET Web API to build HTTP services that reach a broad range of clients.

ASP.NET Web Forms
Find out how to perform data access in your Web Forms application using EF.

Data Binding with WPF (Windows Presentation Foundation)
Learn how to create a master/detail window with WPF data binding using EF for data access.

Data Binding with WinForms (Windows Forms)
Learn how to create a master/detail window with WinForms data binding using EF for data access.

Leave a Comment
  • Please add 4 and 8 and type the answer here:
  • Post