DotNetBurner source relased (asp.net mvc)(tsayao.blogspot.com)

submitted by sayao(85) 1 year, 8 months ago

dotnetburner.com was a community site much like http://dotnetshoutout.com or http://dotnetkicks.com, but it did not work for some reasons (my lack of time and “marketing” skills for example) so i closed it. But since it has a nice code base based on asp.net mvc i decided to release the source (was originally coded for mvc 1 but i ported it to mvc 2 with just a few changes). It serves as example, but can also be used to run a community site (as long as you respect the license provided with the source). read more...

add a comment |category: ASP.NET |Views: 3

tags: ASP.NET another

All in one WLM Plug-In to burn, kick and shout all your posts!(code.sayao.net)

submitted by sayao(85) 2 years, 8 months ago

Download this plug-in to have a “Burn it!”, “Kick it” and “Shout it” badges on your blog posts, just like the one on this post. read more...

1 comment |category: Community |Views: 3

tags: Community another

Do more with less: Turn your actions into feeds on ASP.net MVC(code.sayao.net)

submitted by sayao(85) 2 years, 9 months ago

With this implementation you can re-use parts of your content Controller (the database query for example) and render it on a RSS and/or ATOM feed. read more...

add a comment |category: ASP.NET |Views: 6

tags: ASP.NET another

Lazy loading a query to improve caching on ASP.net MVC(code.sayao.net)

submitted by sayao(85) 2 years, 9 months ago

This article explains an approach to lazy load a database query on an ASP.net MVC controller to prevent the query from executing on it, and just execute on the View, if it's not cached. So, if the View is cached, the database is not queried. read more...

add a comment |category: ASP.NET |Views: 51

tags: ASP.NET another

DotNetBurner.com source code released!(code.sayao.net)

submitted by sayao(85) 2 years, 9 months ago

DotNetBurner is a digg like site where users of the .net community can submit stories and vote (burn!) their favorite ones. When the story reaches a specific number of votes, it gets published to the front page. All submitted stories are optimized for search engines, driving more traffic to the submitted sites or making it easier for users to reach the information. read more...

add a comment |category: Open Source |Views: 19

tags: OpenSource another

Using SQL Server 2005+ index included columns to improve performance o(code.sayao.net)

submitted by sayao(85) 2 years, 9 months ago

This post shows a real scenario on using included columns on SQL Server 2005/2008 to improve the response time of an ASP.net resource. read more...

add a comment |category: Database |Views: 8

tags: Database another

Do more with less: Using the PIVOT operator on SQL Server 2005+(code.sayao.net)

submitted by sayao(85) 2 years, 9 months ago

The PIVOT operator is used to transform rows into column by an aggregate function. One big limitation is that you have to know the columns, but still, it's useful on some use cases, like when you want to aggregate something by hours (for example). read more...

add a comment |category: Database |Views: 6

tags: Database another

Tracking UPDATE changes on SQL Server 2005+ with the OUTPUT clause(code.sayao.net)

submitted by sayao(85) 2 years, 9 months ago

It is common to have to execute a mass update on some table, for example, to update a customer credit classification. When such updates are executed, you may want to know what has changed and maybe log it. There are several ways to do it, but i recently found one that makes it easier: the OUTPUT clause. read more...

add a comment |category: Database |Views: 5

tags: Database another

Avoiding code execution when debugging or testing an ASP.net applicati(code.sayao.net)

submitted by sayao(85) 2 years, 9 months ago

It is common to have some code that is part of some workflow and you don’t want it to execute when you are testing. For example, if your code sends an e-mail to some users, you don’t want to crud your users mail box with e-mails originated from your tests. Unless you are testing if sending the e-mail works, you can do this to test the rest of your code... read more...

add a comment |category: ASP.NET |Views: 1

tags: ASP.NET another

Caching HTML Helpers on ASP.net MVC with optional SQL Cache Dependency(code.sayao.net)

submitted by sayao(85) 2 years, 10 months ago

When thinking about performance, one of the top things that comes in mind is caching. Caching means that you will save some server resources by saving the result on the “first” time it’s processed. With ASP.net MVC, it’s common the use of HTML Helpers, that are just methods that return a resulting HTML. We can combine both and cache the resulting HTML on the first time the method is called, round house kicking the performance of the page. read more...

add a comment |category: ASP.NET |Views: 110

tags: ASP.NET another