Entries tagged with entity framework - Channel 9

Entity Framework 4: Part 1 - Simple Model First

Eric Nelson — Thu, 26 Nov 2009 10:57:00 GMT

This is part 1 of a series of short introductory screencasts to the new features of ADO.NET Entity Framework 4, which is part of .NET 4 and Visual Studo 2010. It was created using Visual Studio 2010 Beta 2.

In this 10 minute screencast I explore the new Model First capability of Entity Framework. Model First allows you to create your Entity Data Model from scratch, focusing on defining the conceptual model from which we can then generate a database schema and mapping.

It is based on the demos I delivered during my Entity Framework session at TechEd Europe in November (DEV305).

Links:

Companion walkthrough on my blog
The relationship between the betas and ctps explained
The related series of blog posts on Entity Framework 4
Entity Framework 4 Resources
My blog, twitter and team twitter

Øredev chit-chat: Dag König and Julia Lerman

Dag König — Mon, 23 Nov 2009 13:03:00 GMT

Dag König talks with Julia Lerman, the Entity Framwork guru and author of the book Programming Entity Framework.

Øredev has its origins and focus on the software development process, from programming to project management. We work to organize an event based on the concept of quality - for learning and networking - Sharing Knowledge.

This year it was held in Malmö, Sweden, 2 – 6 November

Northeast Roadshow - Data Quest

Jim O'Neil — Tue, 14 Jul 2009 14:10:00 GMT

Microsoft is all about options, and there's no shortage of options when it comes to data access! You've got ADO.NET DataSets and DataReaders, LINQ to SQL, Entity Framework, ADO.NET Data Services just to name a few. Each of these technologies can be used - and abused - depending on the context, so this session is geared toward providing guidance on when and how to use (or not) the various options available to you.

You can find the slides and code samples for this session at the Northeast Roadshow Code Gallery.

p&p Data Access Guidance project - 1st drop available now!

ajoy krishnamoorthy — Fri, 19 Jun 2009 07:17:00 GMT

At p&p, we started a project a few months back to provide guidance on how to build data access layers that use common patterns like Repository and Unit of Work using Microsoft's data access technologies. We called this the "Data Access Guidance" project . Don Smith, whom many of you know from his work with the p&p Web Service Factory, is the PM leading this project. The team just posted the very first public drop from this project to CodePlex. You can download it from here.

Download it, install it, play with it and share your feedback.

Thanks

Interview - Andrew Fryer with Mike Taulty on LINQ and DBAs

Mike Taulty — Tue, 28 Apr 2009 17:04:00 GMT

Andrew Fryer of Microsoft UK talking to Mike Taulty at the UK SQL Bits conference around LINQ and the confusion that LINQ can cause amongst DBAs given that the term LINQ appears in conjunction with many things including quite a few that have nothing to do with databases :-)

Projekt Blog Poll: Entity Framework Repository Revisited (Teil 8)

Dariusz Parys — Tue, 28 Apr 2009 03:43:00 GMT

Im 8. Teil wird nochmal ein Entity Framework Repository implementiert. Diesmal mit Mapping auf das eigentliche Objekt Modell.

Mehr zum Projekt Blog Poll ab Mai auf meinem Blog.

Projekt Blog Poll: Repositories - Entity Framework (Teil 4)

Dariusz Parys — Tue, 28 Apr 2009 03:41:00 GMT

Der 4. Teil der Serie beschäftigt sich mit dem Datenzugriff. Welche Technologie soll verwendet werde? Entity Framework, LINQ to SQL oder doch einfach ein Data Reader? Soll ein Domain Modell erstellt werden oder einfach das Entity Data Modell vom Entity Framework benutzt werden? Dieser Teil geht auf die Fragen ein und implementiert die erste Variante mit dem Entity Framework und dem EDM.

Mehr in Kürze auf meinem Blog

10-4 Episode 16: Windows Workflow 4

Ron Jacobs — Thu, 16 Apr 2009 14:09:00 GMT

In this episode of 10-4 we build a "Hello Workflow 4" application. You might have heard that .NET 4 includes an all new Workflow engine - learn how you can not only use Workflow but also do test first style development with it.

10-4 Episode 15: Model-First Development with the Entity Framework 4.0

Jonathan Carter — Wed, 08 Apr 2009 23:05:00 GMT

In this episode of 10-4, we introduce a new tooling enhancement coming with Visual Studio 2010 and the Entity Framework 4.0: model-first development. This feature allows you to create your Entity Data Model from scratch and then generate a database from it, as opposed to reverse engineering your EDM from an existing database.

For more 10-4 episodes, be sure to visit:
http://channel9.msdn.com/shows/10-4

Visual Studio Topic Area on Channel 9:
http://channel9.msdn.com/VisualStudio

Visual Studio 2010 CTP VPC:
http://tinyurl.com/GetCTP

10-4! Over and out!

deCast - Entity Framework Modeling: Importing Select Stored Procedures

Rob Bagby — Fri, 13 Mar 2009 12:32:00 GMT

The Entity Framework supports both select and action stored procedures. We covered action stored procedures in a previous screencast. In this screencast, Rob Bagby will illustrate how to import select stored procedures. However, the entity framework goes beyond simply importing and executing stored procedures. You have the ability to map the result to an entity type which gives you some unique abilities. We will explore some of these abilities in this screencast. You can view a blog post on this subject here.

deCast - Entity Framework Modeling: Mapping Action Stored Procedures

Rob Bagby — Thu, 12 Mar 2009 18:28:00 GMT

For years, you have heard about the benefits of using Stored Procedures to access your database. In this screencast, Rob Bagby will illustrate the default behavior of the Entity Framework when dealing with actions such as insert, update and delete. Rob will then discuss some concerns you may have and how you can address these by mapping in action stored procedures. You can read the blog post about this subject here. Rob will illustrate how to import select stored procedures in another deCast.

deCast - Entity Framework Modeling: Implementing Table Per Hierarchy

Rob Bagby — Wed, 11 Mar 2009 15:57:00 GMT

The Entity Framework provides the ability to model rich conceptual layers that meet the needs of our applications. One such model is table-per-hierarchy inheritance. In this model, the data for a hierarchy are stored in one table. This table has a discriminator column that indicates the "type" of each record. In this screencast, Rob Bagby will illustrate how to implement table-per-hierarchy inheritance with the entity framework. Click here to see Rob's blog post on the same subject.

Silverlight is Ready for Business

Adam Kinney — Tue, 10 Mar 2009 23:34:00 GMT

As proclaimed by Ward Bell from IdeaBlade, "Silverlight is Ready for Business". Business Application development, that is.

Ward walks us through a quick demonstration of building an entity model, querying and displaying data in an editable Silverlight Datagrid. This is all done using their DevForce Silverlight tool which makes this easy but also adds extra functionality like client-side caching binding to anonymous types.

My favorite feature, though, is the ability to run LINQ statements from within the client without having to touch the server. In the rich client application world, this makes development a lot easier and my giddy-ness in the video is genuine not pre-planned.

deCast - Entity Framework Modeling: Implementing Entity Splitting

Rob Bagby — Mon, 09 Mar 2009 13:22:00 GMT

The Entity Framework provides the ability to model rich conceptual layers that meet the needs of our applications. One such model is Entity Splitting. In this model, a single entity in the conceptual layer is mapped to multiple tables in the store. In this screencast, Rob Bagby will illustrate how to implement entity splitting with the entity framework. Click here to see Rob's blog post on the same subject.

deCast - Entity Framework Modeling: Implementing Table Per Type

Rob Bagby — Fri, 06 Mar 2009 14:47:00 GMT

The Entity Framework provides the ability to model rich conceptual layers that meet the needs of our applications. One such model is table-per-type inheritance. In this model, each entity is mapped to a distinct table in the store. Each table contains all of the properties for the entity, as well as a key that maps ultimately to its' root table / entity. In this screencast, Rob Bagby will illustrate how to implement table-per-type inheritance with the entity framework. Click here to see Rob's blog post on the same subject.

US Public Sector Developer Dinner for Partners - Silverlight Business Applications

keydet — Mon, 26 Jan 2009 12:23:00 GMT

This is a recording of the US Public Sector Developer Dinner for Partners covering "Building Business-Focused Applications Using Silverlight 2 and Beyond" held on January 15, 2009 in Reston, Va.

Business-focused applications, sometimes referred to as Line Of Business (LOB) applications, are almost universally about working with data in some shape or form. At it’s a heart, a business app needs:

A way to move data between tiers
A way to shape data (sort, filter, etc.)
A way to bind & display data
A way to soundly apply business logic

What you will learn:

In this session, we’ll start off by discussing approaches to building this kind of functionality TODAY using Silverlight 2. Next, we will give you a peek into how a future version of Silverlight will make building these applications even easier. You will learn about an exciting new technology that is all about making business applications for RIA (Rich Internet Applications) much easier to build. You will hear how we've made n-tier application development as simple as traditional 2-tier, provided application level solutions to developers, and how we're doing all of this with the same .NET platform and tools on both the client and server.

To learn more about US Public Sector Developer Dinner For Partners, visit:

http://tinyurl.com/uspsdevdinner

Follow up resources (links, deck, code) from the dinner are available at:

http ://tinyurl.com/silverlightbizappsdevdinner

US Public Sector Developer Dinner for Partners - .NET Framework 3.5 SP1

keydet — Fri, 23 Jan 2009 11:15:00 GMT

This is a recording of the US Public Sector Developer Dinner for Partners covering .NET Framework 3.5 SP1 held on August 20, 2008 in Reston, Va.

This presentation is a demo focused walkthrough of the new features and functionality in SP1. You will see demonstrations that will include:

Making data access easier with the ADO.NET Entity Framework.
Exposing your data access layer using ADO.NET Data Services
Building “Data Entry” Web-based applications faster than ever using ASP.NET Dynamic Data.
Making AJAX Applications faster with script combining and easier with built in support for handling browser history (i.e. back/forward buttons).
How to achieve up to 40% faster startup performance for your WPF applications and further improve the startup experience using a splash screen.
Reducing the time it takes to deploy your WPF applications using the New .NET Framework Client Profile.
Build services faster using enhancements in WCF.

Entity Framework version 2

Swedish MSDN Team — Mon, 10 Nov 2008 09:39:00 GMT

I den här lilla introduktionsfilmen så visar jag på hur version 2.0 av Entity Framework kan komma att se ut när det gäller rena objektmodeller.

Entity Framework Futures

System — Wed, 29 Oct 2008 16:38:10 GMT

The next version of the Entity Framework adds scenarios in the areas of model driven development, domain driven development, simplicity, and integration. See a preview of production and prototype code for the next version of the Entity Framework as well as a candid discussion with members of the development team.

Tim Mallalieu

Offline-Enabled Data Services and Desktop Applications

System — Wed, 29 Oct 2008 16:37:47 GMT

The ADO.NET Data Services Framework (a.k.a. Project "Astoria") introduced a way of creating and consuming flexible, data-centric REST services. By combining data services with the Microsoft Sync Framework, learn how to create offline-capable applications that have a local replica of their data, how to synchronize that replica with an online data service when a network connection becomes available, and how replicas can be used with the ADO.NET Entity Framework. Also, hear us talk about our plans, see the tools that help client- and server-side setup, and discuss the runtime components and APIs.

Pablo Castro
Pablo is a Software Architect in the SQL Server group at Microsoft. He has worked in various areas of SQL Server and he's currently focused on making data and the web work well together with technologies such as Data Services (Project Astoria).

Developing Applications Using Data Services

System — Wed, 29 Oct 2008 16:37:45 GMT

In the near future, applications will be developed using a combination of custom application code and online building block services, including data-centric services. In this session we discuss advancements in the Microsoft development platform and online service interfaces to enable seamless interaction with data services both on-premises (e.g., ADO.NET Data Services Framework over on-premises SQL Server) and in the cloud (e.g., SQL Server Data Services). Learn how you can leverage existing know-how related to LINQ (Language Integrated Query), data access APIs, data-binding, and more when building applications using online data.

Mike Flasko

ADO.NET Data Services (Astoria) in Visual Studio 2008 SP1

Beth Massi — Tue, 21 Oct 2008 20:07:00 GMT

In this interview Saaid Kahn, a Program Manager on the Visual Studio Pro Tools team, shows us how to create an n-tier application against a database using ADO.NET Data Services (Astoria) and an Entity Data Model, both now available in Visual Studio 2008 Service Pack 1.

ADO.NET Data Services use WCF REST-ful services and provides all the plumbing so you can focus on the program logic by programming against a service proxy. ADO.NET Data Services allow you to easily create data services exposed on the web using URIs to point to pieces of data and simple, well-known formats to represent that data.

Saaid shows us how to create a simple service and then consume it using a Windows client via the "Add Service Reference" dialog in Visual Studio. He also walks through the client proxy methods that work with the data service.

Enjoy,
-Beth Massi, Visual Studio Community

Overview of the EntityDataSource - The new ASP.Net Data Source

bursteg — Mon, 12 May 2008 17:02:19 GMT

Guy Burstein talks about the EntityDataSource – the new ASP.Net Data Source that ships as part of the ADO.Net Entity Framework in Service Pack 1 of Visual Studio 2008 and .Net Framework 3.5. In this video you will get a quick overview of the EntityDataSource and see some additional features you may want to explore later.

If you want a step by step walkthrough of using the EntityDataSource, here is where you can find:

Video Download: Click on the image to play the video (from a streaming file). If you'd prefer to download the WMV and watch it offline, you may do so here.

Christian Kleinerman: SQL Server 2008 for Developers

Dan Fernandez — Fri, 29 Feb 2008 17:50:28 GMT

If you work with SQL Server on a regular basis, either writing custom queries, designing databases, or optimizing queries, this is a must see video as it covers a number of the enhancements to SQL Server 2008 including:

- SQL Management Studio improvements including IntelliSense
- New Data Types for just dates or times (no more storing time when you only need the date)
- New Hierarchical data support .IsDescendent(), that can automatically pull a hierarchical view of data (no more custom recursive queries)
- New Grouping Sets statement which enables you to automatically group dimensions in a query for easy aggregation and reporting
- New Merge statement which provides automatic insert/update semantics for keeping multiple data sources in sync
- New FileStream attribute that enables you to include files that are stored in the server file system, but can be managed by SQL Server
- New data types and support for Geodata and geometry
- New support for optimizing "empty" or row/column tables using the sparse keyword

Expert to Expert: Brian Beckman and Sam Druker - Deep Entity Framework

Charles — Wed, 05 Dec 2007 16:53:29 GMT

You've seen a few conversations on Channel 9 about Microsoft's Brian Beckman recently had a deep technical chat with Sam Druker about the Entity Framework data model and related technologies.

Sam is GM of the Data Programmability Group at Microsoft and also happens to be Brian's boss and former programming colleague. Sam's a very technically-inclined executive... He has to be considering he's a leader in the Microsoft group that makes SQL and the plethora of data-related platform technologies, not to mention that he has to manage the likes of Erik Meijer and Brian Beckman.

This interview is great for two simple reasons. The first reason is that, well, it's a great (and deep, including whiteboarding) conversation between experts that spans many technologies related to SQL and the Entity Framework.

The second reason is that this is the first in a series of interviews on Channel 9 that involve experts in one domain (or many domains, like Brian) who interview other experts in another domain that is not well understood by the interviewer (so, in this case, for example, the venerable Brian Beckman really does not ask any questions that he already knows the answer to. Brian is not an expert in EF, but possesses a very unique perspective in this case given his mathematical tendencies and expert level understanding of things like set theory...). Yours truly, Charles, takes part in the conversation of course, but I'm mainly a camera guy who throws in a random question once and a while. Brian drives this interview.

Like you, I'm in the audience and learning from people who truly understand the deepest levels of a given platform technology. Again, Brian Beckman conducts this interview and I think this is a trend you are going to really enjoy.

Thank you, Brian and Sam!

You'll see more of this class of interview in the future on Channel 9.

Learn. Enjoy.