LINQ in C# | LINQ Tutorial

Explore how to solve a LINQ assignment by declaring a list of integers, filtering even numbers with where and select, and printing results to the console.

Explore LINQ in C# by comparing query syntax and method syntax, examining their pros and cons, and learning when to use each, plus an overview of common LINQ operators.

Explore Linq to objects and its operators using query and method syntax to filter, select, project, sort, join, group, perform aggregation operations like first, last, min, max, and average.

Learn to filter with var and of type, project with select and select many, sort with order by and then by, join and group by, and use aggregates in linq.

Learn what Linq to entities is and why you need it, then set up a SQLite database, create Entity Framework models, and access data with Linq to entities.

Master Linq to entities with the entity framework in C#, using SQLite to manage a SQL database and perform CRUD on student and course tables, with query translation to SQL.

Explore Linq to xml, an in-memory interface for querying and writing xml in dotnet, using x element, x attribute, and x document to build and read xml.

Explore using linq to json with the json dotnet library (newtonsoft.json) to create, parse, query, and select token values from json in c# from strings, files, or objects.

Explore how Json differs from XML and how linq to Json enables in-memory Json processing in dotnet, using the Newtonsoft.json Json dotnet library and its classes.

Explore json.net core classes—json token, container, array, object, property, and value—and how the abstract token forms the base for derived types in linq to json.

Identify json classes by context: object for curly braces, array for square brackets, and primitive values for j value. Use j token type to cast and navigate json hierarchy.

Create json manually in a c# console app by using the Newtonsoft.Json library, building a student object with a nested course object, and printing the json output to the console.

Create json declaratively with a root object and a students property using Newtonsoft.Json's JObject and JProperty; define a student with id 101, James, Smith, and print the json.

Learn to create Json using Linq to convert a student collection into a root object with a students array, employing method and query syntax to build Json objects.

Create json from a dotnet object using from object, and handle collections with an anonymous type. Learn four json creation approaches and what comes next is json parsing.

Explore parsing JSON in c# with JObject.Parse and the read from method, including a string-to-JSON example and a student data workflow.

Parse json from a file using a stream reader and JsonTextReader, loading a Json file into a JToken and printing the students collection.

Query json using property names in the Newtonsoft.json namespace to read a single json object's values, such as student ID, first name, last name, and course ID.

Learn to query json using collection index in c# by reading with a stream, casting to jarray, and enumerating students to access id, first name, last name, and course id.

Read json data from a file using a stream reader, then query with linq to select student ids from the students collection.

Learn how to query json using select token to fetch a specific entry or property by specifying a path, such as the fifth student's id, first name, and course id.

Learn to work with json in .NET using Newtonsoft.Json: create json structures with JToken, JArray, and JObject, parse with Parse and JsonTextReader, and query with SelectToken and linq to json.