These are the first two. I’ve got more coming! If you don't have a Pluralsight subscription, grab a free guest pass and you'll have have access since these are part of the subset of guest pass content along with a ton of other great videos....
Read More...Entries categorized 'Data Access' ↓
Two Introductory VS2010 Entity Framework Videos on Pluralsight on Demand
Thursday, March 11 2010 - Data Access
If timestamp is deprecated, why do none of the current db tools support rowversion?
Thursday, March 11 2010 - Data Access
Perhaps the title of this blog post will suffice, but I just wanted to highlight this problem. If you were to look up the timestamp data type in the SQL Server 2008 documentation, this is waht you will find within the topic article: “The timestamp syntax is deprecated. This feature will be removed in...
Read More...Crystal Reports and Visual Studio 2010
Friday, February 19 2010 - Data Access
If like me, you have a “can’t live with it, can’t live without it” relationship with Crystal Reports and have made a significant investment in reporting with their tools, you might be digging around the VS2010 RC looking for Crystal. CR has been embedded into Visual Basic and Visual Studio for many versions...
Read More...Looking for Astoria aka ADO.NET Data Services aka WCF Data Services in VS2010?
Friday, February 19 2010 - Data Access
Remember... the data service is an item template, not a project template….and that it’s been renamed to WCF Data Services. After you create a project (I usually use an empty web app to host the service), you can find the template in the Web section. Or just use the handy search feature in...
Read More...EF4 Breaking Change: EF4 inner joins affect eager loading many to many
Thursday, February 18 2010 - Data Access
Hooray! Turns out it was a bug ("unintended breaking change) and it's getting fixed for RTM! :) [ see Connect submission and Microsoft's response ] Great catch George! This is an edge case that I had not noticed, but was brought to my attention this morning in an email from Dave Russell who pointed...
Read More...Where are the EF4 providers?
Wednesday, February 17 2010 - Data Access
Thanks to Danny Simmons ' comment below clarifying that the provides that support EF3.5 will still work for EF4 " just without new provider affecting features like model first." As far as I can tell, and confirmed by Fabio Pandolfo (@fabiopand on twitter) who is also on the hunt, DevArt's Oracle...
Read More...Entity Framework Lazy Loading by Context or by Property?
Tuesday, February 16 2010 - Data Access
When Entity Framework finally brought in support for Lazy Loading, there were still complaints. The lazy loading in EF4 is context based, not property based as defined by some of the other ORMs. (I’m not sure which ones or how many.) I was thinking about this today and realized that EF does, in...
Read More...Small Change in EF Loading Behavior from VS2008
Monday, February 15 2010 - Data Access
In the process of updating my book, I have to recheck every statement and every line of code. A lot has changed. It’s as though I were writing the whole thing from scratch. Here’s a small but notable change that I found. In .NET 3.5 you cannot Load an EntityReference for an Added entity even...
Read More...Defining Constraints in an EF4 model that don’t exist in the database
Sunday, February 14 2010 - Data Access
In the first version of Entity Framework, if you wanted to create a PK/FK association between entities where there was no such constraint defined in the database you have to manually edit the SSDL (and lose that edit if you update the model from db). Why would you want to do this? The typical use case...
Read More...Entity Framework ObjectContext and Reporting
Sunday, February 14 2010 - Data Access
I had an email this morning from someone who was having trouble with reports populated using Entity Framework. He was running a report repeatedly but changing the filter. For example, Customers whose last name is Smith , then Customers whose last name is Barber . The problem was that after running the...
Read More...



