Entity Framework Tutorials – ASP.NET

The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. See the Get Started page for information on using EF with other technologies, including ASP.NET. The ASP.NET team recently produced a great set of tutorials on creating web applications with the Entity Framework. … Read more

Microsoft SQL Server has a new connectivity portal page!

The Microsoft SQL Server team is working on a portal page that brings together common resources and community links for all data access providers to Microsoft SQL Server.  We’d like your feedback on how useful you will find it and what else you’d like to see included.  Although, at this time we’re concentrating on bringing… Read more

Walkthrough: POCO Template for the Entity Framework

It is now recommended to use the DbContext template described in this blog post. It will generate simpler POCO entities and a context class derived from DbContext which provides a simpler API. The POCO Template can be used to generate persistence ignorant entity types from an Entity Data Model. The goal of this walkthrough is… Read more

Walkthrough: Test-Driven Development with the Entity Framework 4.0

This walkthrough will demonstrate how to use the new Plain Old CLR Object (POCO) support in Entity Framework 4.0 to develop an application using Test-Driven Development (TDD). In the first release of EF, entity classes had to inherit from EntityObject or implement one of the EF interfaces, which meant your classes had to have direct… Read more

Feature CTP Walkthrough: Code Only for the Entity Framework (Updated)

This post covers Code Only improvements in the CTP3 release for VS 2010 Beta2. This walkthrough shows how you can change the default model like specifying property facets and navigation property inverses as well change the default mapping by changing the default inheritance strategy and table and column names. You can learn more about Code-Only… Read more

Feature CTP Walkthrough: POCO Templates for the Entity Framework

The following post refers to an old version of the POCO Template. You can find information about the POCO Template for Visual Studio 2010 RTM here Creating a Database using Model First 1 – Open the POCOWalkthru project This project is a Console Application that has two files, “Program.cs” and “Blogging.edmx”. The “Blogging.edmx” is a… Read more

Feature CTP Walkthrough: Self Tracking Entities for the Entity Framework (Updated)

The goal of this walkthrough is to demonstrate a basic scenario for the use of the Self-Tracking Entities feature of Entity Framework. Self-Tracking Entities consist on a set of code generation templates based on Text Template Transformation Toolkit (T4) technology that is used to generate entity types that have the ability to record changes on… Read more

How Referential Integrity Works

Referential integrity is a database constraint that ensures consistency between coupled tables.  Referential integrity holds if any field in a table that is declared as a foreign key contains only values from a parent (primary) table’s primary key. Entity Framework (EF) supports referential integrity constraints (RIC).  For example: it is possible to define model with… Read more

Entity Framework Breaking Changes – Visual Studio 2008 & .NET 3.5 SP1 Beta

For the release of SP1 Beta, several breaking changes were made to the Entity Framework. Below is a description of these changes and a mitigation for resolving the breaking change against previous releases.   Schema Changes( covers CSDL, SSDL and ProviderManifest Xml formats)   1.       Attribute name for Default changed to Default values   Beta… Read more

Database Vendors and 3rd Party Providers Support

CoreLab: “Core Lab provides high-quality solutions for native connectivity, database design and management for Oracle, MySQL, PostgreSQL, and SQLite. Due to intensive use of design time features and advanced technologies, the ADO.NET data providers from Core Lab simplify development of database applications to the level where it is completely easy to understand and use.”  … Read more