Introduction
Querying is merely a special case of using LINQPad. More generally, LINQPad is a C#/VB/F# scratchpad that instantly executes any expression, statement block or program with rich output formatting and a wealth of features that "just work". Put an end to those hundreds of Visual Studio Console projects cluttering your source folder and join the revolution of LINQPad scripters, testers, and incremental developers. Reference your own assemblies and NuGet packages. Script in your favorite .NET language with optional autocompletion and the entire .NET Framework at your fingertips. Experience the magic of dynamic development and instant feedback in the ultimate programmer's playground!
Language-Integrated Query (LINQ) is a set of features introduced in Visual Studio that extends powerful query capabilities to the language syntax of C# and Visual Basic. LINQ introduces standard, easily-learned patterns for querying and updating data, and the technology can be extended to support potentially any kind of data store. Visual Studio includes LINQ provider assemblies that enable the use of LINQ with .NET Framework collections, SQL Server databases, ADO.NET Datasets, and XML documents.
You can download LINQPad from here http://www.linqpad.net/.
The steps we follow how to use LINQPad
Open the LINQPad and add new connection
Click on Add Connection then open the new connection wizard select Default (LINQ toSQL) and click the Next Button.
Enter the Server Name. Here we can mention the authentication type also
Specify New or existing Database
Select the Database name here
After that we can test the Connections
Now it’s showing all the database tables here 
We can select the different Languages from here
Simple Select query and execute
Now we need to select the C# Statement(S)
Write a simple select query and for execute the query we need to use the .Dump() command.
After that we can run the query
Right click on the table we have get some more inbuilt query options
The Samples tab has more examples for efficient LINQ queries
Reference
No comments:
Post a Comment