Murach's ADO.NET 3.5, LINQ, and the Entity Framework by Anne Boehm, comes in both Visual Basic and C# 2008 versions.  Larry Blake reviews it.

A review of Murach's SQL Server 2005 for Developers tutorial and reference book, written by Scott Waletzko (Skystone Software).

Introduction

SQL Server Management Objects (SMO) is a collection of objects that allow you to work with SQL Server 2005 databases in a managed environment. Previous to SQL Server 2005 you could use SQL Server Distributed Management Objects (DMO) to work with SQL Server 6.0, 6.5, 7 and 2000 (including MSDE) servers. For the most part, the objects provided with SMO will also work with SQL Server 2000, only those features specific to SQL Server 2005 will not work against a 2000 server.

This article aims to introduce a few of the basic operations that can be performed using SMO such as connecting to an SQL Server, managing databases, tables and stored procedures and performing backup and restore operations against an SQL Server.

Ajax programming, which allows a web page to refresh a small portion of its data from a web server, is an exciting technology that has recently been introduced. However, this type of programming can also leave applications open to SQL injection and similar attacks. It is important for the developer to test the application thoroughly for vulnerabilities before passing it on to the QA department. And the QA engineer needs to learn to "think like a hacker." Learn more about securing your website's Ajax programming.

This article has been written by Bryan Sullivan, who is a development manager at SPI Dynamics, a Web application security products company. 

Article Contents

·         About IDENTITY columns

·         Functions associated with IDENTITY column

·         Examples

·         A Few Tips

·         Points To Remember

Web application development is one of the key business process areas in software industry. A web application has a long life only if the user visits the application with interest.

To keep the user interest in your web site, two factors are important. One is easy navigation and the other is fast data retrieval. The most dramatic way to improve the performance of a database driven Web application is through caching.

This article delves into the caching mechanism, available with ASP.NET 2.0. The author takes a walk through ASP.NET 1.1 caching practices as well as a comparison with ASP.NET 2.0 changes.