Browse by Tags

LINQ to SQL与LINQ to Entities场景之对照

MSDN上最近发表了一篇Elisa Flasko著的文章，比较了LINQ to SQL与LINQ to Entities适用的场景: Introducing LINQ to Relational Data http://msdn2.microsoft.com/en-us/library/cc161164.aspx 作者指出，LINQ to SQL主要的应用场景是针对微软SQL Server数据库的快速开发，这些应用的对象模型与数据库中数据定义的结构间非常类似，几乎有一一对应的映射关系，这样你可以使用LINQ...

Published 2009/7/11 0:04 by 革命

Filed under: Entity Framework, LINQ to Entities, LINQ to SQL

从linq2sql转到ADO.NET Entity Framework

花了一天的时间把项目从linq2sql转到ADO.NET Entity Framework。此项目bs部分工程量不算多，复杂的功能都做在cs部分上，bs只负责基础数据的维护和报表统计，其实用linq2sql也可以满足了，但是linq2sql designer用得实在太不爽了，表少的时候还能应付，现在表增加到70几个了，找个表得找半天，linq2sql desinger也不提供个搜索功能：（前天装好vs2008sp1，试了一下EF designer，增加了Overview窗口和Model browser...

Published 2009/6/19 11:25 by 革命

Filed under: LINQ to Entities, LINQ to SQL

PagedList Sorted Edition

Me and Amr Elsehemy are working together in something and he requested a feature in some APIs I built. In fact he liked the Rob Conery's PagedList that had been modified by Troy Goode . He used it on his jBlogMVC post series about building Blog Engine...

Published 2009/6/16 1:20 by 革命

Filed under: LINQ to Entities, LINQ to SQL

ADO.NET Entity Framework 学习 2

EDMX 1. EDMX Schema 文件可以将EDMX作为XML文件打开，你会发现该文件包含3个主要部分。 Conceptual Models (CSDL) Storage Models (SSDL) Mapping (MSL) 一般情况下，你没有必要手动修改EDMX -XML文件。可视化的EDM 设计器、Mapping Details窗口和Model Browser 窗口包含有上述3个部分，并非常友好地显示整个Entity Data Model模型。当你编译项目时，MSBuild 将从EDMX文件提取CSDL...

Published 2009/6/11 10:07 by 革命

Filed under: Entity Framework, LINQ to Entities

ADO.NET Entity Framework 学习 1

使用实体框架灵活地为数据建模 ADO.NET 实体框架概念最初是在 2006 年作为 ADO.NET vNext 引入的，现在它已准备好要在即将发布的 Visual Studio® 2008 SP1 中大显身手。在历经多年对类似产品的多次失败尝试后，Microsoft 随 Visual Studio 2008 发布了部分适合于对象关系映射 (ORM) 空间的下列两种技术：LINQ to SQL 和 ADO.NET Entity Framework。随着市场逐渐开始采用这些技术...

Published 2009/6/11 10:04 by 革命

Filed under: Entity Framework, LINQ to Entities

InvocationExpression and LINQ to Entities

I talked a little bit about patterns using InvocationExpression in a previous post (you might want to review the post for some context). It turns out my advice wasn’t that easy to implement… Fortunately, the EFExtensions helper library now...

Published 2009/6/10 14:21 by 革命

Filed under: Entity Framework, LINQ to Entities

Stored Procedures and First-Class Relationships in the Entity Framework

A user of the EFExtensions library asked me how to retrieve a set of ‘categories’ and their related ‘products’ through a single stored procedure call. I made some changes to the sample application to illustrate this pattern, but...

Published 2009/6/10 14:20 by 革命

Filed under: Entity Framework, LINQ to Entities

EFExtensions update

The EFExtensions helper library has a few updates: - CreateCommand now respects the CommandTimeout property on ObjectContext . A user of the library reported this bug to me a while ago, and I’m finally getting around to fixing it. - One tricky...

Published 2009/6/10 14:20 by 革命

Filed under: Entity Framework, LINQ to Entities

Using LINQ Expressions to Generate Dynamic Methods II

A beta of Visual Studio 2008 SP1 was released on Monday and the ADO.NET Entity Framework (EF) is now in the box! You can download and install the Beta here . The EF Extensions library has been updated to work with the beta and includes several public...

Published 2009/6/10 14:19 by 革命

Filed under: Entity Framework, LINQ to Entities

Using LINQ Expressions to Generate Dynamic Methods

This week at DevConnections in Orlando, I gave a “deep-dive” talk on LINQ. I wanted to give people a feel for what's possible with the new language features and core APIs in .NET 3.5. I spent most of the talk discussing a single example...

Published 2009/6/10 14:18 by 革命

Filed under: Entity Framework, LINQ to Entities

ADO.Entity Framework: Stored Procedure Customization

The ADO.NET Entity Framework (EF) allows you to map stored procedures to functions that return typed results in the conceptual model. However, when stored procedures results don't match the patterns supported by the EF, reading and tracking results...

Published 2009/6/10 14:17 by 革命

Filed under: Entity Framework, LINQ to Entities

Store commands

You can reuse the connection on an ObjectContext to create a store command as follows: using (MyContext context = new MyContext()) { // In V1 of the EF, the context connection is always an EntityConnection EntityConnection entityConnection = (EntityConnection...

Published 2009/6/10 14:17 by 革命

Filed under: Entity Framework, LINQ to Entities

Materializing typed results

Given a store command, you can manually produce typed results, which EF team calls “result materialization”: turning relational records we get from the store into “real” objects! Here’s some code that takes results from the...

Published 2009/6/10 14:16 by 革命

Filed under: Entity Framework, LINQ to Entities

Tracking results

Using the techniques I’ve described so far, you can retrieve arbitrary CLR objects from store commands, including entities. Entities aren’t very useful if they aren’t tracked however – you cannot modify them or delete them using...

Published 2009/6/10 14:15 by 革命

Filed under: Entity Framework, LINQ to Entities

Multiple result sets

I’ll give one final example that ties together many of the concepts described in this post. Assume we have a stored procedure returning two result sets. The first result set includes a Category instance and the second result set includes all related...

Published 2009/6/10 14:15 by 革命

Filed under: Entity Framework, LINQ to Entities

Syndication

Recent Posts

Tags

Archives

LINQ to SQL与LINQ to Entities场景之对照

从linq2sql转到ADO.NET Entity Framework

PagedList Sorted Edition

ADO.NET Entity Framework 学习 2

ADO.NET Entity Framework 学习 1

InvocationExpression and LINQ to Entities

Stored Procedures and First-Class Relationships in the Entity Framework

EFExtensions update

Using LINQ Expressions to Generate Dynamic Methods II

Using LINQ Expressions to Generate Dynamic Methods

ADO.Entity Framework: Stored Procedure Customization

Store commands

Materializing typed results

Tracking results

Multiple result sets