Cargando…

Programming Microsoft LINQ in Microsoft .NET Framework 4 /

Explains how to use LINQ (Language Integrated Query) while working with C♯ and Visual Basic, demonstrating practical applications for querying and managing data, the XML infoset, extending LINQ, and data binding.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Pialorsi, Paolo
Otros Autores: Russo, Marco, 1967-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Redmond, Wash. : Farnham : Microsoft ; O'Reilly [distributor], 2010.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Preface; Acknowledgments; Introduction; LINQ Foundations; Chapter 1. LINQ Introduction; What Is LINQ?; Why Do We Need LINQ?; How LINQ Works; Relational Model vs. Hierarchical/Network Model; XML Manipulation; Language Integration; Declarative Programming; Type Checking; Transparency Across Different Type Systems; LINQ Implementations; LINQ to Objects; LINQ to ADO.NET; LINQ to XML; Summary; Chapter 2. LINQ Syntax Fundamentals; LINQ Queries; Query Syntax; Full Query Syntax; Query Keywords; From Clause; Where Clause; Select Clause; Group and Into Clauses; Orderby Clause; Join Clause; Let Clause
  • Additional Visual Basic KeywordsDeferred Query Evaluation and Extension Method Resolution; Deferred Query Evaluation; Extension Method Resolution; Some Final Thoughts About LINQ Queries; Degenerate Query Expressions; Exception Handling; Summary; Chapter 3. LINQ to Objects; Query Operators; The Where Operator; Projection Operators; Ordering Operators; Grouping Operators; Join Operators; Set Operators; Aggregate Operators; Aggregate Operators in Visual Basic; Generation Operators; Quantifier Operators; Partitioning Operators; Element Operators; Other Operators; Conversion Operators
  • AsEnumerableToArray and ToList; ToDictionary; ToLookup; OfType and Cast; Summary; LINQ to Relational; Chapter 4. Choosing Between LINQ to SQL and LINQ to Entities; Comparison Factors; When to Choose LINQ to Entities and the Entity Framework; When to Choose LINQ to SQL; Other Considerations; Summary; LINQ to SQL: Querying Data; Entities in LINQ to SQL; External Mapping; Data Modeling; DataContext; Entity Classes; Entity Inheritance; Unique Object Identity; Entity Constraints; Associations Between Entities; Relational Model vs. Hierarchical Model; Data Querying; Projections
  • Stored Procedures and User-Defined FunctionsCompiled Queries; Different Approaches to Querying Data; Direct Queries; Deferred Loading of Entities; Deferred Loading of Properties; Read-Only DataContext Access; Limitations of LINQ to SQL; Thinking in LINQ to SQL; The IN/EXISTS Clause; SQL Query Reduction; Mixing .NET Code with SQL Queries; Summary; Chapter 6. LINQ to SQL: Managing Data; CRUD and CUD Operations; Entity Updates; Database Updates; Customizing Insert, Update, and Delete; Database Interaction; Concurrent Operations; Transactions; Exceptions; Databases and Entities
  • Entity Attributes to Maintain Valid RelationshipsDeriving Entity Classes; Attaching Entities; Binding Metadata; Differences Between the .NET Framework and SQL Type Systems; Summary; Chapter 7. LINQ to SQL: Modeling Data and Tools; File Types; DBML-Database Markup Language; C# and Visual Basic Source Code; XML-External Mapping File; LINQ to SQL File Generation; SQLMetal; Generating a DBML File from a Database; Generating Source Code and a Mapping File from a Database; Generating Source Code and a Mapping File from a DBML File; Using the Object Relational Designer; DataContext Properties