January 31, 2012 at 4:36 PM
—
Dustin Horne
A common need when writing insert queries is to return the last Id that was generated when inserting your record. There is more than one way to retrieve this value and it can come back to bite you if you're not careful. In simple applications it's fine and simple to just append Select @@Identity to the end of your query. If you manage the database and know the structure will never change this isn't a problem. In larger scale applications, a DBA can make a simple change that can have major implications. I'm going to demonstrate the problem and show you how to avoid this pitfall. More...
January 25, 2012 at 12:23 PM
—
Dustin Horne
Lately I've been using a lot of jQuery and other custom javascript in my projects. I like to use external CDNs when possible to load my script files. In particular, I like to use the asp.net CDN for use with jQuery. For much of this work I can simply put my script references in the layout pages, however there are times when I want specific scripts for specific pages. There are also times when I want to be able to upgrade a script to a newer version. This may require modifying multiple views. Additionally, it would require modifying my HTML/Razor for at least my layout view and re-uploading it to the server. More...