Using LINQPAD

Hi Friends,

In this section, I’ll introduce you with one of my favorite tools i.e. Linqpad. you can download the same from https://www.linqpad.net/. This is extensive tool for .NET programmers. LINQPAD is The .NET Programmer’s Playground. Here, you can do bunch of stuffs like executing LINQ query against SQL, Azure, XML, any object or against any other database. You can add your SQL connection like shown below.

5th

6th

As you can see in the below screen shot, I have simply pulled the movies from my movie review db.

2nd

Then, If i have to see the relationship between the tables, then i can simply go ahead and click on the highlighted link shown in the table above. Like in this case, when i clicked on “MovieReviews”, it produced the below result.

3rd

Behind the scenes it also generated the actual SQL statement as shown below in the screen shot.

4th

You can also execute SQL statement as shown below in the screen shot. only thing you need to change here is the language from the dropdown.

1st

Thanks for joining me.

Thanks,
Rahul Sahay
Happy Coding

3,341 total views, 1 views today