Use LINQPad With .NET Framework

In this section, I will introduce you to one of my favorite tools, LINQpad. You can download it from LINQpad. This is an extensive tool for .NET programmers. LINQpad is a .NET Programmer's Playground. Here, you can do many things, such as executing a LINQ query against SQL, Azure, XML, any object or against any other database. You can add your SQL connection as in the following.

LINQ

LINQPAD

As you can see in the following screenshot, I have simply pulled the movies from my movie review DB.

review DB
If I need to see the relationship between the tables then I can simply click on the highlighted link as in the preceding table. Like in this case, when I clicked on “MovieReviews”, it produced the following result.

MovieReviews

Behind the scenes it also generated the actual SQL statement as in the following screenshot.

SQL statemen

You can also execute a SQL statement as in the following screenshot. The only thing you need to change here is the language from the dropdown.

dropdown

Thanks for joining me.