I've wrote this article a few months ago but in Portuguese: http://pontonetpt.org/blogs... I've decided to translate it to engish. The sample project is hostead at GitHub but it's in Portuguese (the same as my first article). Link Github: https://github.com/guilherm... ......

---

This tip is really simple but usefull if we're concatenating strings to write a Where clause. For example: DECLARE NVARCHAR @SQL = 'SELECT ... FROM ...' IF(@IDAluno IS NOT NULL) SET @SQL = @SQL + '' WHERE [IDAluno] = ' + CAST(@IDAluno AS NVARCHAR) A better solution would be something like this: SELECT ... FROM ... WHERE ([IDAluno] = @IDAluno OR @IDAluno ......

---

I've seen a few guys asking on stack overflow and forums how to order randomly using LINQ.
Here's a simple solution using Guid:

OrderBy(x => System.Guid.NewGuid())

---

Database .NET is an awesome tool that allow us manage several database in simultaneous (SQL Server, MySQL, Oracle, etc). What lead me to install this tool was an problem that must be shared by must developers. Tools like SQL Server Management Studio consume to many resources, and if you don't have a decent computer you'll get problems in performance, ......

---

Channel9 already provided 4 vídeos from mvcConf, and more will be published on the nexts hours. http://channel9.msdn.com/Se... http://www.mvcconf.com/ ......

---

In this article i'm gonna show you how i do when i have to update some content with AJAX and i have to change the URL. First, let's see an example to understand it better. If the user is reading a News with Id 1 and he clicked on another News with Id 2, if we update the content with AJAX the user is now reading the News Id 2 but the URL remains the ......

---

I've decide to write about unit testing in the next weeks. If we decide to develop with Test-Driven Developement pattern, it's important to not forget the routes. This article shows how to test routes. I'm importing my routes from my RegisterRoutes method from the Global.asax of Project.Web created by default (in SetUp). I'm using ShouldMapTp() from ......

---

Developers that use unit testing are familiar with Resharper and his plugin for Unit Testing. For those that like me, don't have a great pc hardware (Pentium 4, 3ghz, 1GB ram) the Resharper can be really slow, and affect the performance of pc. That's why i use TestDriven.NET TestDriven.NET is a freeware license tool (there are others licenses for this ......

---

A few time ago i've write an article explaining how to use iTextSharp. Check it here: http://geekswithblogs.net/g... In this article, i'll show how to use headers. You just should follow this article if you're using iTextSharp 5.x or above. Other versions uses ......

---

In this article i will show how to read feeds rss. In this example i will show it for MVC architecture but it's very easy to use it in webforms. (use the SyndicationFeed object as a datasource for an repeater for example). Let's declare our SyndicationFeed object in Model: public class BlogModel { public SyndicationFeed BlogFeed { get; set; } } In Controller ......

---