Packt Publishing | ISBN: 1847192548 | PDF | 252 pages | 6.56 MB
When we say Language Integrated Query, we might think that it is already integrated into the programming language, just as we write SQL queries in our application. So what is the difference or additional features that we are going to get in LINQ? How is LINQ going to make our programming life easier? Also, I am sure that we all want to know how the new feature, LINQ, is making use of the other new features of C# 3.0. We"ll see many of those in this book.
Language Integrated Query is a new feature in Visual Studio 2008 that extends the query capabilities, using C# and Visual Basic. Visual Studio 2008 comes with LINQ provider assemblies that enable the use of Language Integrated Queries with different data sources such as in-memory collections, SQL relational database,
ADO.NET Datasets, XML documents and other data sources.
In Visual Studio 2008, Visual C# and Visual Basic are the languages that implement the LINQ language extensions. The LINQ language extensions use the new Standard Query Operators API, which is the query language for any collection that implements IEnumerable
AppDev LINQ Using Visual C Sharp 2008 DVD | 1.33 GB
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 s, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to s, 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 course, you will learn how to…
* Create new XML content using LINQ to XML.
* Iterate through collections of s, using a single LINQ query.
* Use anonymous types, lambda expressions, extension methods, initializers, and implicit type declaration.
* Query arrays, lists, dictionaries, and more using LINQ to s.
* Use the extension methods provided by the System.Linq.Enumerable class to extend the behavior of collection classes.
* Create an model based on a SQL Server database and then query the database using LINQ to SQL.
* Modify data and use stored procedures with LINQ to SQL.
* Create XML content using classes in the System.Xml.Linq namespace.
* Validate, query and transform XML content using LINQ to XML.
* Transform XML content using LINQ to XML.
* Create an Entity Data Model based on a data source and then query the data using LINQ to Entities.
* Modify data and use stored procedures with LINQ to Entities.
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.
TITLE : LINQ for VB 2005 (Hardcover)
AUTHOR : by Fabio Claudio Ferracchiati (Author)
PUBLISHER : Apress publisher
ISBN : 1590598407
EDITION : 1st
PUB DATE : February 12, 2007
LANGUAGE : English
FORMAT : PDF
SIZE : 03 x 1.44 MB
Professional ADO.NET 3.5 with LINQ and the Entity Framework
LINQ and the Entity Framework are revolutionizing .NET database programming. With this book as your guide, you’ll discover how to leverage these cutting-edge query and /relational mapping technologies for enterprise-class computing. It provides you with hands-on coding techniques for data-intensive web and Windows projects. You’ll also get quickly up to speed on LINQ technologies with the help of C# and VB programming examples.
Leading Microsoft database authority Roger Jennings first covers LINQ Standard Query Operators (SQOs) and domain-specific LINQ to SQL, LINQ to DataSet, and LINQ to XML implementations for querying generic collections. He then delves into the ADO.NET Entity Framework, Entity Data Model, Entity SQL (eSQL), and LINQ to Entities. Numerous code examples are integrated throughout the chapters that emulate real-world data sources and show you how to develop C# and VB web site/application or Windows projects.
The information in this book will give you the tools to create and maintain applications that are independent of the underlying relational data.
What you will learn from this book
* A new approach to data access in ADO.NET 3.5 SP1
* Methods for working with advanced LINQ query operators and expressions
* Techniques for querying SQL Server® database with LINQ to SQL
* Approaches for integrating third-party and emerging LINQ implementations
* How to raise the level of data abstraction with the Entity Data Model
* Steps for creating design-time data sources from Context
* Ways to use the Entity Data Model as a data source
Who this book is for
This book is for intermediate to advanced developers of data-intensive .NET web- and Windows-based applications.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
* Paperback: 672 pages
* Publisher: Wrox (February 3, 2009)
* Language: English
* ISBN-10: 047018261X
* ISBN-13: 978-0470182611
LINQ 01 - Overview
LINQ 02 - Data Model
LINQ 03 - Querying the database
LINQ 04 - Updating the database
LINQ 05 - LinqDataSource
LINQ 06 - Custom LinqDataSource
LINQ 07 - Using Stored Procedures
LINQ 08 - Using Stored Procedures
LINQ 09 - Executing Arbitrary SQL
if there"s a password, it"s : gatico.123