Welcome to Part 2 of our comprehensive guide to data access in .NET! In Part 1, we explored Entity Framework Core in depth, including SQL generation, common pitfalls, and that critical warning about proxies and caching. In this article, we'll explore the…
When building .NET applications, one of the most important architectural decisions you'll make is how to handle data access and object mapping. The .NET ecosystem offers a rich variety of approaches, from full-featured ORMs to bare-metal SQL execution. Each…
New release of the Data Access Application Block (funny, I thought version 2 had already been released...). Got this from Michael Swanson's blog.
Though I'd point to an excellent article on Indexed Views. For those who don't know what these are, well, if you have a fairly complex database schema, you can gain a great deal of performance benefits by aggregating the output of common queries into indexed…
I think I'm going through one of my bi-annual mid-life crises again. I really should be sleeping, I have a hospital appointment in the morning (just a diabetic clinic followup thing - 10 minutes and a lecture about my diet...great fun - and eerily similar to…
Found this on Ashutosh Nilkanth'sblog (good name!), basically allows you to run pretty much any CLR code using a Sql Server extended stored procedure - not nearly as good as Yukon, but if you need to do this now, it is a start!
It's Saturday morning (the time is odd because the host in in the US)...I need to find something to do. Choices currently are: Shopping - Saturday before payday - probably a bad idea! Coding - I have some work to do for work; writing a forum system for this…
Just been catching up on the PDC presentations, came across this one on Yukon, also, for an interesting perspective on why you should use SPs in Sql Server, watch the first 10 minutes! Man, I am so looking foward to Yukon reaching RTM; the architectures which…
Noticed a link in my referrer log from this post which comments on a comment I made in the whole Dyanmic SQL debate, this comment: Right. Because evaluating arguments based on their validity is too much work, so it's much easier to pick the "winner" by picking…
The SqlJunkies weblog site is really starting to fill out, it's fantastic to have so many SQL experts posting in one place! Oh, and I'm not just saying that because I agree with Donny Mack's views on SPs; well, partially, reporting is still a pain but I had…