EDM Metadata Samples

http://code.msdn.microsoft.com/EdmMetadataSamples

EDM Metadata Samples is a small web application that you can use to explore Entity Framework’s metadata API and the Entity Data Model.

ADO.NET Entity Framework Query Samples

http://code.msdn.microsoft.com/EFQuerySamples

ADO.NET Entity Framework Query Samples is a small Windows Forms program which contains several basic Entity SQL and LINQ to Entities queries against that NorthwindEF Entity Data Model (a modified version of Northwind).

Its goal is to help you learn the features of the different query languages available in the Entity Framework, and to let you visualize how the results and the translated store queries look like.

UPDATE: Visual Basic version of the sample is now available in the Downloads section.

The project supports querying multiple backends. Included are:

• SQL Server 2000 using SqlClient
• SQL Server 2005 using SqlClient
• SQL Server 2008 using SqlClient
• SQL Server Compact 3.5 SP1
• EFSampleProvider http://code.msdn.microsoft.com/EFSampleProvider
• EFOracleProvider http://code.msdn.microsoft.com/EFOracleProvider

Previous versions of these samples can be found at CodePlex.com

ADO.NET Entity Framework Documentation Samples

http://code.msdn.microsoft.com/EFDocSamples

Resource Page Description
The ADO.NET Entity Framework samples that accompany the Entity Framework documentation on MSDN. This is the download location for the CourseManager project that you create when you complete the Entity Framework quickstart. You will also find other Entity Data Model tools walkthrough projects as well as the samples described in the Entity Framework documenation.

This resource page contains the following Entity Framework documentation samples and projects in both Visual Basic and C#:

File Name	Description
CourseManager.zip	The CourseManager Windows forms application created by completing the Entity Framework quickstart.
HRSkillsCombined.zip	This is a Visual Studio 2008 solution that contains both a Windows forms project and an ASP.NET project. Both samples demonstrate data binding to entity objects. The ASP.NET sample uses the EntityDataSource control for data binding.
AdWksSalesWinDataBind.zip	The AdventureWorks Data Binding sample demonstrates data binding that uses the Entity Framework. This application displays and modifies SalesOrderDetail entities associated with SalesOrderHeader entities.
ResearchCollaborationAssistant.zip	The Annotation and Research Collaboration Tool aids research and collaboration by creating reference annotations and contact entities that can be searched for both relevant Web pages and people associated with topics or search texts.

Click the Issue Tracker tab to report issues with any of these documentation samples. Click the Click to Rate and Give Feedback link in an individual help topic to provide feedback on the Entity Framework documentation itself.

Servers and Services tracks recorded at TechDays 2009 Belgium

http://www.microsoft.com/belux/techdays/2009/track.aspx?tid=servers_services&engine=MSDN

In this track you will find sessions on SQL Server 2008, SharePoint Server (MOSS), Windows Workflow Foundation (WF) and Windows Communication Foundation (WCF) in .NET Framework 3.5. Claims and authentication is also addressed as well as the Azure Services Platform.

Building RESTful Applications with Microsoft Tools

Applications today are expected to expose their data and consume data-centric services via REST. In this session we discuss ADO .NET Data Services and see how we can REST enable your application. Then you will learn how to leverage existing skills related to LINQ and data access to customize the behavior, control-flow, security model and experience of your data service. Then switching gears we will focus on consuming of REST services from any platform (including Ruby on Rails) using Visual Studio and LINQ to REST. We will then see how to enable data-binding to traditional ASP.NET controls as well as Silverlight. We will conclude with developing offline applications with the ability to sync back to the online data service.

Session level: 300

Building Workflow Services in .NET Framework 3.5

About creating business processes in Workflow Foundation and integration with other applications using WCF. The Workflow first approach vs. the Contract first approach. The use of the wsHttpContextBinding. Big demo of a real life scenario based where a public webapplication start a process, internal applications are communicating with the process and at the end thirdparty services are called.

Session level: 300

Enhancing the SharePoint Developer Experience

This session will focus on best practices for SharePoint development based on lessons learnt. You will learn how to approach SharePoint development to build solutions in an effective way. This is not only about knowing the right tools and techniques to speed up the SharePoint development process but also about how to avoid mistake and making the correct design decisions.

Session level: 300

Inside the Architecture of the Podcasting Kit for SharePoint

Join this session to know more about the design of the Podcasting Kit for SharePoint, how SharePoint Server 2007 is used out of the box, and which components have been developed and how: rating, commenting and rating, native Zune support, Silverlight 2.0 for playback and robust upload, streaming, grid view, mobile views etc… Scaling, performance and deployment will also be discussed. We’ll also share lessons learned from the current Academy Mobile implementation within Microsoft.

Session level: 300

Putting authentication in its place: claim-based identity, services and Geneva

The code that takes care of authentication is traditionally one of the nastiest spot of every distributed application. The current situation derives from multiple causes, from tightly coupling with specific technologies to trusting non-experts to write security code. Microsoft has been among the thought leaders who proposed a strategic solution to the problem, the Identity MetaSystem and its claim based identities, achieving vast consensus across the industry. Come to this session to learn how you can finally put that vision in practice thanks to the new “Geneva” products line.

Session level: 300

SQL Server 2008 for Developers

Lynn’s demo-filled presentation will give .NET developers an overview of the numerous new capabilities in SQL Server 2008: from support for Spatial Data types to a mechanism to store SQL BLOB data using the NTFS file system, and several things in between. There are also improvements in the area of SQL CLR and XML, Reporting Services, etc. This presentation will take a technical dive into the new things you will find in SQL Server 2008. Lynn’s sessions are always highly interactive, educational and a lot of fun.

Session level: 300

WCF Tips & Tricks

Applications communicating over the Internet or being provided in the cloud need certain infrastructure functionalities. Authentication, authorization, powerful communication options and support for workflows seem to be a common need. Microsoft’s .NET Services – as part of the overall Azure Services platform – offer exactly all this with their Access Control Service, Service Bus and Workflow Service. In this session Christian Weyer sheds a light on how these services fit into the Azure picture, how they work and fit together in a practical manner, based on first experiences in customer projects.

Session level: 300

ADO.NET Entity Framework & LINQ to Relational Data

http://code.msdn.microsoft.com/adonetefx/

Entity Framework Toolkits & Extensions

Source code libraries and design time tools that extend the reach and augment the development experience of the Entity Framework.

EF Extensions Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1 (Visual Basic and C# versions available)
The ADO.NET Entity Framework Extensions library includes utilities that make querying stored procedures, creating typed results from DB data readers and state tracking external data much easier in the Entity Framework. A sample application demonstrates several patterns using these utilities, including stored procedures with multiple result sets, materialization of CLR types, and registering entities in the Entity Framework state manager.

eSqlBlast (Entity SQL Tools and Samples Page) Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1
eSqlBlast aids authoring, executing, and visualizing ad-hoc Entity SQL queries against arbitrary EDM models. The tools of the eSqlBlast suite may be used interactively, from the command line, or embedded in other programs. The eSqlBlast suite also contains XSL transformation scripts for rendering CSDL and its own raw XML format.

Perseus: Entity Framework EntityBag Compatible with beta versions of Entity Framework only
Perseus is a small project designed to explore ways for exchanging graphs of Entity Framework entities over WCF web services.

Entity Framework Lazy Loading Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1 (Visual Basic and C# versions available)
This sample shows how to use code generation to add support for transparent lazy loading to Entity Framework. It includes code generator (EFLazyClassGen), supporting library (Microsoft.Data.EFLazyLoading) and sample test applications.

EdmGen2.exe New!
EdmGen2 is a command-line tool for the Microsoft ADO.NET Entity Framework that is able to read and write the EDMX file format, as well as translate between EDMX and CSDL, SSDL & MSL file formats.

Persistence Ignorance (POCO) Adapter for Entity Framework V1 Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1 (Visual Basic and C# versions available)
EF POCO Adapter enables Plain Old CLR Objects (POCOs) to be tracked using released version of Entity Framework V1 using automatically generated adapter objects. It consist of a code generator, supporting library and a test suite and examples.

Tracing and Caching Provider Wrappers for Entity Framework Compatible with .NET Framework 3.5 SP1, Visual Studio 2008 SP1 and Visual Studio 2010 Beta1
Demonstrates how to implement wrapping providers which add interesting functionality (caching and tracing) to an EF application.

Entity Framework Samples

Sample source code and projects showing how specific tasks can be completed using the Entity Framework.

Sample Entity Framework Provider for Oracle Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1
This Sample Provider works with Oracle 10g by wrapping System.Data.OracleClient APIs. It uses the same technique as Entity Framework Sample Provider which wraps System.Data.SqlClient. Sample Entity Framework Provider for Oracle is compatible with Entity Framework released as part of .NET Framework 3.5 SP1. Its goal is to showcase some techniques that provider writers targeting database engines other than SQL Server can use. This is just a sample and its use in a production environment is strongly discouraged.

Entity Framework Documentation Samples Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1
The ADO.NET Entity Framework samples that accompany the Entity Framework documentation on MSDN. This is the download location for the CourseManager project that you create when you complete the Entity Framework quickstart. You will also find other Entity Data Model tools walkthrough projects as well as the samples described in the Entity Framework documenation.

Entity Framework Sample Provider Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1
The Sample Provider wraps System.Data.SqlClient and demonstrates the new functionality an ADO.NET Provider needs to implement in order to support the ADO.NET Entity Framework

• • Provider Manifest
  • EDM Mapping for Schema Information
  • SQL Generation

Entity Framework Query Samples Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1 (Visual Basic and C# versions available)
The Entity Framework Query Samples is a small Windows Forms program that contains several basic Entity SQL and LINQ to Entities queries against that NorthwindEF Entity Data Model (based on a modified version of Northwind).
Its goal is to help you learn the features of the two query languages supported by EF and visualize how the results and the translated store query look like.

Entity Data Model Metadata Samples Compatible with .NET Framework 3.5 SP1 and Visual Studio 2008 SP1
EDM Metadata Samples is a small web application that you can use to explore Entity Framework’s metadata API and the Entity Data Model.

Sample EDMX Code Generator
The goal of the Sample EDMX Code Generator is to provide you with enough insight into how the ADO.NET Entity Designer generates code in Visual Studio and hopefully give you a head start with some sample source code.

SketchPad
A simple drawing editor that allows you to create elementary geometric shapes–lines and circles–and model them as entities using either the Entity Framework or LINQ to SQL. Think of it as a ‘Notepad for Shapes’–you can create, read, and delete shapes, and use the built-in spatial index to search for entities by attribute value. A command-line argument allows you to switch between the Entity Framework and LINQ to SQL runtime for the model.

LINQ to SQL Samples

TPT Inheritance with LINQ to SQL New!
This sample demonstrates a technique for implementing the TPT (Table per Type) object mapping model in a LINQ to SQL context.

SketchPad
A simple drawing editor that allows you to create elementary geometric shapes–lines and circles–and model them as entities using either the Entity Framework or LINQ to SQL. Think of it as a ‘Notepad for Shapes’–you can create, read, and delete shapes, and use the built-in spatial index to search for entities by attribute value. A command-line argument allows you to switch between the Entity Framework and LINQ to SQL runtime for the model.

Entity Framework Learning Tools

Tools that help you in learning Entity Framework concepts.

EF Mapping Helper
Entity Framework mapping helper lets you create sample mapping files for the set of scenarios you are interested in. It’s a great tool for a deeper understanding for how schema files are defined for complex mapping scenarios in Entity Framework.

ADO.NET Entity Framework Extensions

http://code.msdn.microsoft.com/EFExtensions/

Home

The ADO.NET Entity Framework Extensions library includes utilities that make querying stored procedures, creating typed results from DB data readers and state tracking external data much easier in the Entity Framework. A sample application demonstrates several patterns using these utilities, including stored procedures with multiple result sets, materialization of CLR types, and registering entities in the Entity Framework state manager. Overview Utilities are included to simplify: Execution of store commands via the ObjectContext. Connection lifetime management. State management of entities from external sources. Materialization of arbitrary CLR types given a data reader or DB command. Stored procedure mapping: Multiple result sets. Column renames, polymorphic results and nested structures via the materialization service. Getting and setting key values for entity references. Rewrite InvocationExpressions in LINQ queries and expressions. Requirements Visual Studio 2008 SP1. http://msdn.microsoft.com/en-us/vsts2008/products/cc533447.aspx Other resources The following post introduces the EFExtensions API and includes a walkthrough of the sample application: http://blogs.msdn.com/meek/archive/2008/03/26/ado-entity-framework-stored-procedure-customization.aspx For additional information on multiple result sets and relationships, see: http://blogs.msdn.com/meek/archive/2008/12/07/stored-procedures-and-first-class-relationships-in-the-entity-framework.aspx For additional information on InvocationExpression rewriting, see: http://blogs.msdn.com/meek/archive/2008/12/07/invocationexpression-and-linq-to-entities.aspx

Last edited Dec 7 2008 at 7:22 PM by cmeek, version 9