Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Entity SQL » Tips   (RSS)

How to Get the Native SQL from an EntityCommand

With the Beta 3 release, Entity Framework is introducing an easy way to get the native SQL from an EntityCommand. There was public API to get to the native SQL, but the pattern was too obscure, and I don’t want to go into detail. Let’s discuss the new

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

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

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.
 
Page view tracker