Andy The's Blog

Output your SQL when using Linq in ASP.NET

2009-10-24T11:40:00.001-07:00

I used both Linq Data Source and straight Linq.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;

public partial class _Default : System.Web.UI.Page
{
StringWriter sw = new StringWriter();
protected void Page_Load()
{
// Using Linq Data Source
LinqDataSource1.ContextCreated += (sender, e) =>
{
sw.WriteLine("Grid 1 SQL");
((DataClassesDataContext)e.Result).Log = sw;
};

// Using Linq
DataClassesDataContext db = new DataClassesDataContext();

var results = from c in db.Customers
where c.City == "London"
select c;

GridView2.DataSource = results;

sw.WriteLine("Grid 2 SQL");
db.Log = sw;
GridView2.DataBind();

}
protected override void Render(HtmlTextWriter writer)
{
base.Render(writer);
writer.Write("<hr><p>LINQ to SQL Trace Console</p><p><textarea cols='100' rows='15' readonly='true'>");
writer.Write(sw.ToString());
writer.Write("</textarea></p>");
}

}

Movie Star

2010-07-03T01:24:00.001-07:00

type="application/x-shockwave-flash">

31 Days of Refactoring eBook

2009-10-21T16:01:00.001-07:00

http://www.lostechies.com/blogs/sean_chambers/archive/2009/10/20/31-days-of-refactoring-ebook.aspx

Free e-book offer that features Windows Server 2008 R2

2009-10-21T15:56:00.001-07:00

http://download.microsoft.com/download/5/C/0/5C0BD0AB-040D-4C56-A60B-661001012DDA/Windows_Server_2008_R2_e-book.pdf

Mass installing your DNN modules

2009-10-21T15:52:00.001-07:00

Step 1) Drop your module in:

{Where your DNN is installed}\Install\Module

Step 2) Go to this URL:

http://{yoursite}/install/install.aspx?mode=installresources

You should see your modules being installed.

Finished.

Disk2vhd v1.0

2009-10-14T13:16:00.001-07:00

http://technet.microsoft.com/en-nz/sysinternals/ee656415(en-us).aspx

Disk2vhd will create a vhd out of your hard drive.

Generate your own custom Controller and Views by overriding the default MVC T4 templates

2009-10-13T14:50:00.001-07:00

Create a ASP.NET MVC Web Application

Copy the CodeTemplates directory into the root of your MVC project.

By copying this directory into your root directory you will be overriding the default templates.

The CodeTemplates directory can be found here:

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\Web\MVC

VB.NET

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\VisualBasic\Web\MVC

Highlight each t4 template and delete the “Custom Tool” properties.

Modify template(s)

Add new controller

Now you can see your custom created controller!!!

(This applies to the views as well)

Creating a code snippet in Visual Studio 2008

2009-10-13T13:16:00.001-07:00

Step 1:

Download and install "Snipp Dogg - Visual Studio Intellisense" from http://www.codeplex.com/SnippDogg

Step 2:

a) Create new file.

b) Paste code.

c) Fill the two required fields. Shortcut and Title

3) Save snippet file.

3) Import snippet file into Visual Studio.

Tools –> Code Snippets Manager

Choose language
Import snippet

4) Use snippet

Type the name of the shortcut name and then hit the tab button twice.

Finished.