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.
As you can see in the following screenshot, I have simply pulled the movies from my movie 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.
Behind the scenes, it also generated the actual SQL statement as in the following screenshot.
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.
Thanks for joining me.