Free register and download UseNet downloader, then you can FREE Download from UseNet.

    Download without Limit " Using LINQ to SQL in place of SQL Statements in VB.NET " from UseNet for FREE!

C# 3.0 incorporates LINQ (Language INtegrated Query), a cool technology that adds dynamic queries to all kinds of objects in a familiar SQL-like style. LINQ code looks like embedded SQL statements, which I actually don’t care for because SQL has never looked pretty to me. I also do not believe that LINQ adds clarity to code. It looks terse and somewhat ambiguous. In a nutshell, LINQ is a sexy technology (as they are fond of saying in Redmond), but it is not pretty.
In this course, you’ll learn to use the exciting new .NET Framework 3.5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you’ll learn about the new language features added to Visual Basic in Visual Studio 2008 in order to make LINQ possible. You’ll start by working through a quick overview of LINQ, and how it applies to working with collections of objects, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time you’ve completed the course, you’ll have a good understanding of now only how to construct LINQ queries to work with data, but also how to use the features added to Visual Basic that support LINQ.
In this tutorial, we will be using LINQ to SQL to interact with a SQL Server Database. We will add the ability to add new records to the database, as well as edit and delete existing records – all without using any SQL statements. To do this, we will need to create a LINQ to SQL Class to represent our database, but luckily for us, Visual Studio does the hard work for us.
Let’s start by creating a new VB.NET web application project in Visual Studio .NET 2008, and then add a new database by right-clicking the App_Data folder in Solution Explorer and choosing Add New Item.. SQL Server Database. We will add one table, tblEmployees, with three columns – id, name, and position. We will make the id the Primary Key and also the Identity Specification (in the Properties Window).
Prerequisites: This course assumes that students have familiarity with .NET in general, and with specifically with programming ADO.NET. The course makes no attempt to explain basic Visual Studio 2008 or .NET Framework concepts, and assumes that the student is at least familiar with all the concepts covered in the Introduction to Programming and Developing Applications with Visual Studio 2008 courses.