1.Topics‎ > ‎Dot.Net‎ > ‎

E.Entity Framework

  1. What is Entity Framework
    1. Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. 
    2. It eliminates the need for most of the data-access code that developers usually need to write.
  2. When to use Entity Framework 
    1. When you need an ORM Mapper .
    2.  Particulalry useful while building application based on LINQ and RESFull services.
  3. Perquisite 
    1. Visual Studio 2010
  4. Getting Started 
    1. Watch a Simple Demo Videos 
      1. Introducing Entity Framework
      2. Entity Framework Database First
      3. Entity Framework Code First to an Existing Database
      4. Entity Framework Code First to a New Database
      5. Additional Videos (Optional to get Started) 
    2. Read some overview Tutorials
      1. None
    3. Hands On Lab 
      1. http://msdn.microsoft.com/en-us/data/gg427655
    4. More Resources 
      1. TODO
  5. Advance Topics
    1. TODO
  6. Related Technologies 
    1. ASP.Net Web API
    2. WCF Data Service
  7. Related Tools
    1. Developer Tools
      1. EF Power Tools
      2. EF Profiler
      3. ORM Profiler
      4. LINQPad
      5. LLBLGen Pro
      6. Huagati DBML/EDMX Tools
      7. Entity Developer
    2. Third Party Connectors and Drivers
      1. MySQL Connector/NET
      2. Oracle Data Provider for .NET
      3. Progress DataDirect Connect
      4. VistaDB
      5. Devart
      6. OpenLink Software
      7. IBM
      8. Sybase SQL Anywhere
      9. Sybase Adaptive Server Enterprise
      10. Phoenix Software Solutions
      11. Synergex
      12. Firebird
      13. Npgsql
  8. Best Practices (Dos and Don`t Dos) 
    1. TODO
  9. Recommended Books
    1. Beginners 
      1.  Programming Entity Framework By Julie Lerman                      [For server side development]
      2. Programming Entity Framework: DbContext By Julie Lerman      [For Client Side Data query]
    2. Expert 
      1. Entity Framework 4.0 Recipes: A Problem-Solution Approach     [For Real Life Problems]
    3. Guru 
      1. Essential LINQ By Charlie Calvert, Dinesh Kulkarni                    [Core Fundamentals]
  10. Discussions (FAQs) 
    1. Code First vs Database First
      1. Code First should be use to develop business model when data base is not already in place and development is starting from scratch
      2. If Database already exist then prefer to  start with database first model.
    2. EF Vs Repository Patterns
      1. As for as possible we should avoid using Repository without any valid justification.
      2. ORM solution like EF itself based on Repository and Unit of work patterns
      3. http://ayende.com/blog/3955/repository-is-the-new-singleton
      4. http://programmers.stackexchange.com/questions/180851/why-shouldnt-i-use-the-repository-pattern-with-entity-framework
  11. Additional References
    1. Home Page : http://msdn.microsoft.com/en-us/data/ef.aspx