Welcome to MSDN Blogs Sign in | Join | Help

November 2007 - Posts

Wednesday, November 21, 2007 1:09 PM

How to Do Custom Mapping Using Entity SQL Views

This post was intended to be a reply to this question http://forums.microsoft.com/msdn/showpost.aspx?postid=2440161&siteid=1 on the Entity Framework forum, but its size exceeds the forum server limit. Besides, it’s useful in general. So I decided
Posted by Zlatko Michailov | 1 Comments
Monday, November 19, 2007 2:08 PM

LINQ to Entities: Compiled Queries

Last Friday I blogged about making local variables behave consistently in LINQ to Entities queries . And the solution I recommended was compiled queries. But just today I realized that I haven’t blogged about compiled queries in general yet. The main
Posted by Zlatko Michailov | 3 Comments
Friday, November 16, 2007 4:21 PM

Behavior of Variables in LINQ to Entities Queries

LINQ is very nice about referencing local variables without any additional declaration. When I ran my first such LINQ to Entities query, I was ecstatic. The next moment I was puzzled – are the values of those variables picked at compile-time and later
Posted by Zlatko Michailov | 2 Comments
Friday, November 16, 2007 2:31 PM

How to Parse an EntityDataReader

2007.12.18 : Please accept my apologies – today I discovered (and fixed) two bugs in the parsing code. One is a silly error. The other is that collections should be treated as primitive types and refs with regard to the number of fields. The code bellow
Posted by Zlatko Michailov | 2 Comments
Friday, November 16, 2007 12:18 PM

XSL Transformation of CSDL into HTML

The attached XSL script neatly renders an Entity Framework CSDL file into HTML. Below is the NorthwindEF model that we’ve been using for our samples, rendered using that XSL script: Northwind Entity Sets Entity Types Complex Types Associations Entity
Posted by Zlatko Michailov | 0 Comments
Filed under: ,

Attachment(s): csdl.xsl
Thursday, November 01, 2007 11:36 AM

Entity SQL Tip #1

A well defined query against a well defined entity data model does not need JOIN . Navigation properties in combination with nesting sub-queries should be used instead. These latter constructs represent task requirements much more closely than JOIN does.
Posted by Zlatko Michailov | 0 Comments
 
Page view tracker