Using LINQ to SQL in place of SQL Statements in VB.NET

Category: Uncategorized

Posted on 2010-09-04. By anonymous.


Using LINQ to SQL in place of SQL Statements in VB.NET
Genre: eLearning
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抰 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抣l 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抣l learn about the new language features added to Visual Basic in Visual Studio 2008 in order to make LINQ possible. You抣l 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抳e completed the course, you抣l 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.
Password default:

Sponsored High Speed Downloads
9982 dl's @ 3776 KB/s
Download Now [Full Version]
9256 dl's @ 3091 KB/s
Download Link 1 - Fast Download
9733 dl's @ 3224 KB/s
Download Mirror - Direct Download

Search More...
Using LINQ to SQL in place of SQL Statements in VB.NET

Search free ebooks in!

Download this book

No active download links here?
Please check the description for download links if any or do a search to find alternative books.

Related Books


No comments for "Using LINQ to SQL in place of SQL Statements in VB.NET".

    Add Your Comments
    1. Download links and password may be in the description section, read description carefully!
    2. Do a search to find mirrors if no download links or dead links.
    Back to Top