Getting Started with LINQ – Part 4

Hi Friends,

In today’s section we’ll delve further and see more of LINQ. Let us get started with Take and skip operations.

This will produce me the following output.

13th

Below is the same example while querying db.

14th

Now, let us see select many example.

15th

Cross product example.

16th

Cross product Join example:-

17th

Database cross Join:-

18th

19th

Filtered Association:-

20th

Joining the parent:-

21th

Outer Join – 1st:-

22nnd

Outer Join – 2nd

23rd

Thanks for joining me.

Thanks,
Rahul Sahay
Happy Coding

1,305 total views, no views today

Getting Started with LINQ – Part 3

Hi Friends,

In this section, we are going to delve further. We’ll first start with filtering process. Below is the snippet for the simple filtering process.

This will produce the following result.

8th

Now, let us look at complex style of filtering with multiple where clauses.

9th

Now, let us see the scenario where in we want to skip every 2nd item like shown below.

This will produce the below output.

10th

Let us now query against database. Here, i am reviewing against my movie review database. Here, i am referring Movies table as shown below.

11th

Now, let us consider a scenario where you want to query what IN and NOT-IN scenario as shown below.

12th

Thanks for joining me. We’ll continue same thing in another session. Till then stay tuned and happy coding.

Thanks,
Rahul Sahay
Happy Coding

1,380 total views, no views today