Shulou(Shulou.com)06/02 Report--

Editor to share with you how to use LINQPad in LINQ, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

LINQPad supports all the features of C # 3.0 and Framework 3.5:

◆ LINQ to SQL

◆ LINQ to Objects

◆ LINQ to XML

LINQPad is also a good tool for learning LINQ, including 200 examples from the book "C # 3.0 in a Nutshell". You can use LINQPad to experience the cool features and functional programming of LINQ.

LINQPad is completely free, does not need to be installed, can be downloaded and can be run directly, only 2.12 MB size. LINQPad requires that .NET Framework 3.5 be installed first, which supports the limited features of SQL Express, SQL 2000, SQL 2005, and SQL 2008.

LINQPad can use LINQ to interactively query SQL databases, eliminating the need for SQL Management Studio.

Product home page: http://www.linqpad.net/

LINQPad provides a variety of execution modes:

C # (or VB) expression

You can execute a single LINQ expression for C # or VB and display the final object in the results pane

C # (or VB) statement

Multiple LINQ expressions of C # or VB can be executed, and LINQPad has Dump extension methods to send objects and text to the results pane during execution

C # (or VB) program

Write the code to be executed in the Main () function, and you can define other types and methods to test in the LINQPad editor.

SQL

Use SQL to support specific data queries

It's important to remember that LINQPad can execute arbitrary C # or VB.NET code, not just LINQ expressions. This also means that LINQPad is very useful for any short code that needs to be tested simply, such as tricky numeric format strings or matching regular expressions.

LINQPad contains several LINQ sample expressions for showing LINQ nuances and functions, including beginner examples and more advanced concepts such as deferred execution and projection. LINQPad also has a multi-purpose analysis function, that is, a variety of options for displaying results:

◆ default result view simple graphics of objects and text returned by statements

◆ Lambda view LINQ expressions are converted to available Lambda expressions

◆ SQL view LINQ expressions are converted to available SQL

◆ IL View Microsoft Intermediate language for Code Generation

LINQPad allows users to reference custom assemblies and import custom namespaces for extension. LINQ to Entities can be supported through this extension.

In addition to being a learning and testing tool, LINQPad is becoming increasingly popular in executing specific queries against SQL databases.

A simple LINQ to SQL expression output to the result view, as follows:

A simple LINQ to SQL expression output to the Lambda view, as follows:

A simple LINQ to SQL expression output to the SQL view, as follows:

LINQPad is free and constantly updated. IntelliSense is only available in the license fee ($19) version. Visual Studio is not required to use LINQPad, but .NET Framework 3.5 is required.

The above is all the contents of the article "how to use LINQPad in LINQ". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.