Yes you can execute PARAMETERIZED sprocs with EF Fluent API Code Only (and more!)

This is really an add-on to this post here. Turns out most people were only thinking that you could execute SQL strings only as opposed to detailed parameterized SQL statements. That’s not correct. It’s all supported and approved. Scenario 1. Using Parameterized SQL statements So this covers selects as well as invoking sprocs. If you…


Estimating the size a cube

where the set of D is dimensions and the set of M is measures. Let F(x) calculate the number of members and G(x) the size of the member.   Debate.  edit: I should have noted this is the approximation of the size. Depending on storage system there’s obviously overhead to this.


Yes you can execute sprocs with EF Fluent API Code Only

OK let’s make this clear. You can totally call SQL Functions, SQL SPROCS, or any other raw SQL statement and use it in EF Code Only. What you don’t get is automatic or fluent API configuration statements that perform this mapping work for you and by default, no tracking occurs on the materialized objects (though…


Map private properties with EF Fluent API

So until we get EF 4.2 and the support for enumerations as first class citizens those of us needing support have resigned ourselves to the simple fact that we are forced to expose a property for the integer value for EF to use and wrap that value with a convenience property that casts it as…


Interested in POCO Entity Framework 4?

Editorial note: EF 4.1 was released as part of the .Net 4 Platform Update 1 release. You should use the information at for training now. For those of you interested in POCO In EF4, here’s a list of links that you should read to grok: And if you are…


Unit Testing Repositories, a rebuttal. Or "How to use proper decoupling to unit test the repository pattern"

For primers, you need to read this post first: So the other day I received an email from a group that I am assisting in understanding TDD, Test Concepts, and Separation of Concerns, and they asked, “Is this relevant”? Well here’s the reply to them. Relevant: Yes and no.There’s some good conversation going on…


DataServices, IErrorHandlers, Exceptions and the Gulf between them.

OK I am going to let you in on a dirty little secret about Astoria based services. This secret is probably not even known to you. Ready to hear it? Really? Well here it is:  You’d better never have anything go wrong as you’ll never know it. It devours exceptions and is hungry for more!…


Query Providers ARE Still Data Access Code!!

So everyone reading this (or at least hopefully everyone) will know that putting data access logic into the UI is anti-pattern of all anti-patterns. I am going to sidestep the issue of simple utilities and one-off screens and trivial applications for the purposes of this discussion. We’re instead focusing on real applications with non trivial…


Server Side Pagination in T-SQL / LINQ

OK it came as a shock to me that so many people were building huge sets of query data that they are binding in their UI and then deciding to page it at like 10 rows per page. I’m not talking about 1 or 2 or even 3 pages of data, I’m talking about hundreds…