Skip Navigation Links


© 2021 Ambica
Version: 1.3.2

Archive for January 2006

Friday, 13 January 2006

C# 3.0 and LINQ

Attended a very interesting London .NET User Group ( meeting at Microsoft last night. Ian Griffiths ( gave a presentation on the above subject. C# 2.0 has just been released as part of the Visual Studio 2005, ASP.NET 2.0 etc releases. This talk was about the next release which is currently in 'alpha' testing. The basic concept behind the enhancements to 3.0 that Ian outlined is to bridge that gap between source code such as C# that is used on the 'front' end and 'back' end languages such as SQL, XPath etc that interact with data stores such as relational databases, XML etc. The C# 3.0 enhancements allow the use of data language type commands within C#. LINQ (Language INtegrated Query) are .NET extensions that encompass language-integrated query, set, and transform operations.

For more information on C# 3.0 see and on LINQ see

# posted by admin @ 15:22   0 comments

Friday, 06 January 2006

Summary of SQL Server 2005 Improvements

The improvements in SQL Server 2005 fall into 3 areas: enterprise data management, developer productivity and business intelligence.

The enterprise data management enhancements improve manageability, availability, scalability and security:

  • Easier to deploy, manage, and optimize enterprise data and analytical applications.
  • New single, integrated management console called SQL Server Management Studio replacing tools such as Query Analyser and Enterprise Manager.
  • New set of programming objects called SQL Management Objects (SMO) that exposes all of the management functionality of the SQL Server database.
  • High-availability features such as database mirroring, failover clustering, database snapshots, and enhanced online operations have either been added or improved.
  • Scalability advancements such as table partitioning, snapshot isolation and 64-bit support.
  • Significant enhancements to security have been made to provide more precise and flexible control.

Enhancements for developer productivity include the following:

  • The Common Language Runtime (CLR) is now hosted in the database engine, allowing languages such as Transact-SQL, Microsoft Visual Basic .NET and Microsoft Visual C# .NET to be used to develop database applications. Benefits include faster performance as managed code is precompiled.
  • Database development is integrated into the Microsoft Visual Studio 2005 development environment allowing the same tools to be used for database development as for the rest of the software development lifecycle.
  • Improved development tools include Business Intelligence Development Studio (for building BI solutions based on Visual Studio), ability to create database objects directly from Visual Studio and can now seamlessly debug both CLR and Transact-SQL code using the same Visual Studio debugging interface.
  • ADO.NET 2.0 evolves dataset access and manipulation to achieve greater scalability and flexibility, including query change notification, Multiple Active Result Sets (MARS) and transparent failover for data mirroring.
  • The new XML data type allows better interaction with XML documents and schemas.
  • SQL Server 2005 ships with deep XQuery (XML Query Language) capabilities that allow for XML object manipulation in the data tier.
  • XML Web services can be developed in the database tier, making SQL Server an HTTP listener.
  • New SQL Server application framework includes Service Broker (for building asynchronous message routing), Notification Services (platform for developing and deploying applications that generate and send notifications to users), SQL Server Mobile (improved version of SQL Server 2000 Windows CE Edition), and SQL Server Express (free, easy-to-use and robust database that developers can use to design schemas, add data, and query local databases, all inside the Visual Studio 2005 environment).

BI features include enhancements in the following areas:

  • Data Transformation Services (DTS) has been redesigned and improved upon as an enterprise data extraction, transformation, and loading (ETL) platform called SQL Server Integration Services (SSIS).
  • Analysis Services now provides a unified and integrated view of all business data as the foundation for traditional reporting, online analytical processing (OLAP) analysis and data mining.
  • Reporting Services has improvements, including the addition of Report Builder which allows business users to create their own reports using a user-friendly model of their data.
  • Reports served up by the Report Server in Reporting Services can run in the context of Microsoft SharePoint Portal Server and Microsoft Office System applications such as Microsoft Word and Microsoft Excel.

More details of the above can be found at

# posted by admin @ 15:48   0 comments

Tuesday, 03 January 2006

Visual Studio 2005 & ASP.NET 2.0 Improvements

Visual Studio 2005 and ASP.NET 2.0 provide new productivity enhancements with improvements in almost all areas. This will result in quicker development of Web applications. The improvements include:

  • .NET Framework 2.0 is 40% faster than 1.1.
  • Reduced lines of code by upto 70%.
  • VS 2005 includes software lifecycle tools for greater productivity.
  • VS 2005 is integrated with SQL Report Builder.
  • VS 2005 is tightly integrated with SQL Server 2005.
  • VS 2005 Team System assists team working.
  • VB.NET improvements include edit and continue, generics, the 'using' keyword, partial classes, debugger DataTips, the My namespace etc.
  • ASP.NET 2.0 has a single page architecture, allowing compilation on the fly.
  • ASP.NET 2.0 introduces master pages that act as templates for other pages.
  • Code can be placed in a pre-defined Code subdirectory automatically compiled into shareable assembly which is automatically referenced and available to whole site.
  • ASP.NET 2.0 allows creation of common page look with themes and skins.
  • New Membership API provides new controls such as Login, LoginView, LoginStatus, LoginName, and PasswordRecovery.
  • Now possible to implement personalisation features in ASP.NET 2.0 using Web Parts and Web Zones.
  • ASP.NET 2.0 allows pre-compilation of web site rather than compiling pages on first request.
  • New data source controls have been introduced such as SqlDatasource, ObjectDatasource, AccessDatasource, XmlDatasource, DataSetDatasource, SitemapDatasource, gridview and detailsview.

Most of the above information was gleaned from Please refer to this useful article if you need more information.

# posted by admin @ 19:45   0 comments