Geeks With Blogs

News Google

Nick Harrison Blog<Nick>.Next() February 2013 Entries
Adding SQL Doc Documentation to your Project
In a recent blog post, we talked about using SQL Doc to stream line documenting your database. This tool makes it a lot easier to put the documentation close to the source so that it is more likely to stay current. Another problem with documentation like this though is its visibility. If you squirrel it away on a file server somewhere, it is easily forgotten. Again the key is to keep it closer to the source or at least where it will be the most relevant. So I decided to add the outputted documentation ......

Posted On Thursday, February 28, 2013 11:22 AM

Do You Dream in LINQ?
New article on Simple Talk exploring various ways to build dynamic queries with LINQ Some of the examples are fairly straight forward, but in the end, I step you through creating complex queries from scratch using reflection and Expression Trees. Expression Trees are the neglected corner of DotNet voodoo. Hopefully this will shed some light on this “scary topic”. Hit the comments and tell me how you dream in LINQ ......

Posted On Thursday, February 28, 2013 8:38 AM

Reviewing Syncfusion: jQuery Succinctly
The nice folks at Syncfusion reached out to me last week to tell me a little bit about their Succinctly series of books. As they describe the concept, their goal is take 500+ pages of content and distill it down to 100 pages of essentials. I was intrigued but apprehensive with visions of “For Dummies” books running through my head. So I looked through their offerings and decide to check out a topic that I am already somewhat familiar with. I downloaded jQuery Succinctly to examine. I was pleasantly ......

Posted On Monday, February 25, 2013 12:53 PM

Book Review of Under the Hood of .Net Memory Management
I don’t really like to toot my own horn, but I am not above shining the light on someone doing it for me. Ein Gedanke has written a wonderful review of the book that I co wrote. I thoroughly enjoyed reading his review. After reading his review, feel free to wander over to Amazon and see how you can get a copy for yourself ......

Posted On Friday, February 22, 2013 2:58 PM

Do You Use SQL Doc from Red Gate?
Do you have a database? Then you should be using SQL Doc! SQL Doc scans the data dictionary and associated metadata to produce the documentation for your database. You can output this documentation in several different formats depending on your needs: You can also explicitly pick and chose which components to include and save these selections in a project file to make it easy to refresh the documentation: Now for the kicker, you can easily ......

Posted On Friday, February 15, 2013 3:28 PM

Build A Custom View Engine to Create Excel Files in MVC
In any project you often need to export data as excel. This are several approaches that you can follow to do this. One approach, would be to setup the environment for a GridView and then bind your list to this: 1: public void GetExcel() 2: { 3: var data = GetData(); 4: 5: var list = Mapper.Map<IList<View... 6: IList<Model>>(data); 7: var grd = new GridView { DataSource = list, AutoGenerateColumns = true }; 8: grd.DataBind(); 9: 10: Response.ClearContent(); 11: Response.AddHeader("Content... ......

Posted On Wednesday, February 13, 2013 1:29 PM

Why you Should be Using SQL Prompt!
You have probably seen this ad floating around the Internet. Probably see it on this very blog. If you are already familiar with this wonderful tool, the ad makes perfect sense to you. SQL Prompt is to Management Studio as Reshaper is to Visual Studio. Actually, the difference is even stronger. SQL Prompt is like upgrading from Notepad to Visual Studio. I was first drawn to the tool for the “Format SQL” options. Nicely formatted code is easier to understand. Once I got started, I found many other ......

Posted On Friday, February 1, 2013 10:57 AM

Copyright © Nick Harrison | Powered by: