Latest Database Articles - Page 4

You can use LINQ to SQL to define an Object Relational Mapping between SQL tables and then query those tables with LINQ.

Repetitive tasks are nothing new to a developer. Writing ADO interface code is one of these tasks. In this article David R. K. DeLoveh shows us how to write code to generate code for calling stored procedures in SQL Server 7.

Developer Stephan Onisick shows us how to create a standalone/custom recordset and use its organizational ability to perform logical tasks with data without connecting to a database. This article uses a small application written using VBScript, ADO 2.1, and an Excel spreadsheet to record and print computer expenses for tax preparations. The standalone recordset is saved in XML format, and the file can be updated with new data simply by reopening as a recordset and using normal recordset methods.

In the first part of his hands-on tutorial on using Visual Studio 2005 to build a complete 3-tier application, David Catherman examines how Visual Studio 2005 can be used as a great tool for designing and building SQL Server 2005 databases.

This is a fully functional sample that shows some advanced features that would be hard to do with bound controls.

Learn about local type inference in C# 3.0 and Visual Basic 9.0. Examine why it is relevant and the syntax for its use.