• A quick overview
• Projects included

The EF Test Console project cleanly lays out an extensible data layer that uses Entity Framework.

• Exposes a set of static classes that can be used to test the various behavioural features of Entity Framework.

• This is the Web application that exposes the data through the ApiControllers. Demonstrates async api controller methods.

• This project exposes the Repository, BaseRepository and IUnitOfWork interfaces.

• Contains the actual repository implementations

• Contains all the POCO classes generated by the Entity Framework POCO class generator

• Some unit tests around the repositoryies

• Test

• EF Power tools: Generate code first classes in visual studio
• Entity Framework Profiler

• Demonstrate power of the Linq to Enitities LinqProvider
  • Show Matt Warren's blog / Profile
• Lazy load entities
  • Query caching vs. second level caching
• Deep load entities
• Select with projection into an anonymous type
• Select with projection into an anonymous type - Deep load by exposing referenced entity on anonymous type
• Select with projection into an anonymous type - referenced entity property identified (Deep load)

• DbSet.Find looks up entity from cache by default

• The standard command set
  • update-database - Verbose
  • add-migration [Migration Name]
  • enable-migrations -force

• http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/handling-concurrency-with-the-entity-framework-in-an-asp-net-mvc-application

• Creating a model from an old database download "Entity Framework Power Tools beta 4"

• Right click on project --> EntityFramework -> re-engineer code first

  • select DB in dialogue and click generate

• Download EF6 : http://entityframework.codeplex.com/SourceControl/latest

Install-Package xunit.runner.visualstudio

• Download Adventure works DB from http://msftdbprodsamples.codeplex.com/

• Start up performance

• General performance of save changes

#Testing Entity Framework Using NugetPackages by Rowan Miller

• See test project SEE - TODO : COMPLETE

• Use EF Profiler in Talk

• Modifying Transaction block around Select Queries using extension methods

• Download the EF6 code base and run various unit tests

  • Demonstrate basic select

• Focus on Linq, change tracking, DbMigrations, unit of work features in slide

  • features which happen to be supported in EF7

• Complete and test DBMigrator Test for generating SQL

• Provide interceptor for logging in EfTestConsole.Config file

• Complete ProductController Unit Test with MockDbSet

• Complete/FIX WebApi project with ProductRepository UnitOfWork integration

• List Performance tricks in PowerPointSlides

• Complete DB Migration for FullTextSearch

• Complete Command Interceptor for Soft Deletes

• Add Example for DB Execution strategy and logging

• Highlight Linq Provider classes and tests in EF source

• Add EF7 demo project

• Add micro ORM performance mentric tests

• Add concurrency check in BaseRepository

#Web Api project extensions

• Add Serilog and Seqlog packages

Advanced scenarios http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/advanced-entity-framework-scenarios-for-an-mvc-web-application // Talk about serialisation performance in EF vs Dapper

Getting and building the EF runtime https://entityframework.codeplex.com/wikipage?title=Getting%20and%20Building%20EF%20Runtime

• TODO : Complete API with DI and Resitory UnitofWork integration

http://www.entityframeworktutorial.net/entityframework6/introduction.aspx

http://www.farreachinc.com/blog/far-reach/2014/01/09/entity-framework-part-5-ef6-new-features

http://www.farreachinc.com/blog/far-reach/2013/09/26/entity-framework-query-optimizations

https://channel9.msdn.com/Events/TechEd/NorthAmerica/2014/DEV-B417#fbid=

https://github.com/rowanmiller

#Resources

• Entity Framework 6 Open Source http://entityframework.codeplex.com/ https://entityframework.codeplex.com/wikipage?title=Getting%20and%20Building%20EF%20Runtime
• Entity Framework 7 Open Source https://github.com/aspnet/EntityFramework
• Matt Warren’s Blog – How to build a linq provider http://blogs.msdn.com/b/mattwar/archive/2007/07/30/linq-building-an-iqueryable-provider-part-i.aspx
• EF Power Tools https://visualstudiogallery.msdn.microsoft.com/72a60b14-1581-4b9b-89f2-846072eff19d
• EF Patterns / Handling Concurrent Transactions / Advanced scenarios http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/handling-concurrency-with-the-entity-framework-in-an-asp-net-mvc-application http://mehdi.me/ambient-dbcontext-in-ef6/ http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/advanced-entity-framework-scenarios-for-an-mvc-web-application
• Performance Tips https://msdn.microsoft.com/en-gb/data/hh949853.aspx http://www.farreachinc.com/blog/far-reach/2013/09/26/entity-framework-query-optimizations http://www.dotnet-tricks.com/Tutorial/entityframework/J8bO140912-Tips-to-improve-Entity-Framework-Performance.html
• Benchmark Demo Code Taken From https://github.com/FransBouma/RawDataAccessBencher
• Rowan Miller and Julie Lerman’s Blog https://github.com/rowanmiller http://thedatafarm.com/blog/