samaxes

Microsoft has created Code Gallery.

Code Gallery is a place for projects sharing, created to demonstrate .NET key features with a primary focus on C#.

Microsoft announced today the release of the .NET Framework source code under the Microsoft Reference License.

Find more about it.

Paging with SQL Server has always been a pain. Although SQL Server 2005 introduced some features that made it possible to page results efficiently more easily than ever before.

Paging in SQL Server 2005 at 15 Seconds shows you how to do it with the new ROW_NUMBER() function.

Werner Schuster posted at InfoQ an article entitled “Microsoft Surpasses Java’s Dynamic Language Support” trying to show where .NET is doing better than Java.

Some of the highlights are:

• Microsoft CLR (Common Language Runtime), LINQ and the support for multiple languages
• DLR (Dynamic Language Runtime)
• .NET modularization and versioning

LINQ (Language Integrated Query) is one of the most promising technologies for Microsoft®’s .NET.

Here are some great resources for those interested in learning more about this generic data query API:

• LINQ/C# Learning Guide - Quick look at the LINQ extensions and the upcoming release of C# 3.0 in general
• LINQ in Action - Learn about LINQ, LINQ to SQL (DLINQ) and LINQ to XML (XLINQ)
• Hooked on LINQ - Developers’ Wiki for .NET Language Integrated Query
• LINQDev - Dedicated site to Language Integrated Query development

Great resources for MSSQL DBAs.

Taken from InfoQ:

Mark Souza of Microsoft has announced a new web site for database administrators and developers called SQL Server - Best Practices. This site offers a wide range of material from top 10 lists suitable for novices to the in-depth technical white papers needed by seasoned professionals.

Topics include capacity planning, database mirroring, and bulk data loading. Over a dozen scripts for troubleshooting and performance tuning are also available.

Take a look at SQL Server - Best Practices.

For those who want to take off into the wide blue yonder of ASP.NET 2.0, read Cristian and Zak’s ASP.NET 2.0: A Getting Started Guide.

You’ll tame the installation process, sink your teeth into two ASP.NET languages, and conquer .NET programming basics with your bare hands. Finally, you’ll pull server controls, user controls, master pages, and CSS into the beginnings of an application.

Right now there are two extensions for .NET that I find very interesting.

The first one is Language INtegrated Query (LINQ) and the other one is the Atlas Toolkit.

For those looking for more information about LINQ, visit LINQ Project Overview at MSDN, and Scott Guthrie’s last post where he shares the code samples and slides from his TechEd LINQ Talk in Australia.

LINQ’s benefits

LINQ’s benefits include, most significantly, a standardised way to query not just tables in a relational database but also text files, XML files, and other data sources using identical syntax. A second benefit is the ability to use this standardised method from any .NET-compliant language such as C#, VB.NET, and others.

LINQ in action

The following snippet illustrates (in C#) a simple LINQ code block, using the Northwind database as its target. To see LINQ at work, we’ll use a simple C# 3.0 program that uses the standard query operators to process the contents of an array.

^?View Code CSHARP

using System; using System.Query; using System.Collections.Generic;   class app { static void Main() { string[] names = { "Alpha", "Brian", "Connie", "David", "Frank", "George", "Harry", "Inigo" };   IEnumerable<string> expr = from s in names where s.Length == 5 orderby s select s.ToUpper();   foreach (string item in expr) Console.WriteLine(item); } }

This program delivers this output:

ALPHA
BRIAN
DAVID
FRANK
HARRY
INIGO

Scott Guthrie, Microsoft’s ASP.NET and Atlas development guru, has posted a two-part article on using the Language Integrated Query, or LINQ, within ASP.NET projects.

• Part 1 how to create the ASP.NET page using LINQ, using rich collections of strings, refactoring collections, working with .NET Standard Query Operations and using Anonymous types.
• Part 2 details about DLINQ, or LINQ for databases, such as creating a DLINQ-enabled object model, hierarchical binding and basic pagination.

And more is on the way:

In my next few LINQ posts I’ll show how we will be able to build on top of the concepts I demonstrated above to easily add sorting, in-line editing, deleting, and selection support over our customer data – and also show how to easily Ajax enable it with Atlas.

A Web site should present visitors with a simple yet flexible navigation structure so that they can travel to various parts of the site easily.
ASP.NET 2.0 provides a feature called SiteMap that helps you implement this functionality.

This article explains what site maps are and describes how to develop Web site navigation structures that use them.