You can use LINQ to SQL to define an Object Relational Mapping between SQL tables and then query those tables with LINQ.
Latest Database Articles - Page 4
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.
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
The Transactional File System (TxF), which allows access to an NTFS file system to be conducted in a transacted manner through extensions to the Windows SDK API. MFC 10, has been extended to support TxF and related technologies. This support allows existing MFC applications to be easily extended to support kernel transactions.
The original release of the .NET Framework included collections as .NET was introduced to the Microsoft programming world. The .NET Framework 2.0 introduced generics to complement the System.Collections namespace and provide a more efficient and well performing option. Read on to learn more...
Learn how to use a for loop to loop through all of the images found on a web page and save them via the DownloadFile method of the WebClient object.
SOLID principles form the base for writing good and clean object oriented code in C#. Learn about the S.O.L.I.D principles and explore C# coding samples for each.