- Paperback: 126 pages
- Publisher: Packt Publishing Limited (July 26, 2013)
- Language: English
- ISBN-10: 1782178228
- ISBN-13: 978-1782178224
- Product Dimensions: 7.5 x 0.3 x 9.2 inches
- Shipping Weight: 240 g
- Average Customer Review: Be the first to review this item
Building Interactive Queries with LINQPad Paperback – 26 July 2013
|New from||Used from|
About the Author
Sebastien Finot, fascinated by computer science on the whole(but with a specific dedication to application development and games),has been working for more than 15 years for both small and large worldwide companies at various technical positions, ranging from developer to technical project manager, and for the last five years,as the CTO of communication agencies. He is also pursuing an entrepreneur path with his own company (in France) where he can work on fun and innovative projects.Sebastien has been using LINQ for five years now and has been a LINQPad user for almost as long.Sebastien can be reached by any means listed on this website: http://about.me/sebastienf.
No customer reviews
|5 star (0%)||0%|
|4 star (0%)||0%|
|3 star (0%)||0%|
|2 star (0%)||0%|
|1 star (0%)||0%|
Most helpful customer reviews on Amazon.com
The book is fairly well done and mentions a few things I didn't already know about LinqPad. But, in my opinion, it's not worth anywhere near the $31.79 price. This is far more than I pay for most other technical books containing 500+ pages. I suspected this was going to be the case, which is why I bought the Kindle version ($10). For $10 I think it's worth the price. If I had paid $32, I would be seriously upset, and probably would have returned it.
I am a big fan of LINQPad. It's a core part of my consulting toolbag. I regularly demo it in my .Net tools talk, and I have also done a screencast on it. So I was delighted to see a book on the topic recently and gladly accepted to review it when asked.
The book Building Interactive Queries with LINQPad is available from Packt Publishing and authored by Sébastien Finot. It's aimed at C# and .Net developers who wish to learn LINQ programming and test the easy way using LINQPad. No prior knowledge of LINQ or LINQPad is expected. It's a small book (109 pages) and an easy read. The book is divided into 7 Chapters:
Discovering LINQPad covers the installation, different editions of LINQPad and introduces you to the different sections of the GUI, as well as the different menu options.
Coding in LINQPad teaches running simple queries and programs and also talks about adding assemblies, namespaces as well as the LINQPad Dump() utility method.
Learning LINQ Basics is an introduction to LINQ.
Discovering LINQ Query Operators continues with the LINQ tutorial.
Databases and Relational Data covers LINQ to SQL and more LINQ query operators. It also shows interactive navigation with LINQPad in the DataGrid View as well as how to update data in the database.
Using other Data Sources talks about LINQ to XML, Entity Framework and LINQ to WCF Data Services. These are great features in LINQPad which a lot of folks do not know about.
Getting more out of LINQPad talks about the more advanced features such as customizing results pane and creating custom visualizers.
Overall, I liked the book and it's approach to teach LINQ and LINQPad. The only advanced feature I found missing was hyperlinq, that can be used to dynamically build queries. I think the code samples might benefit from syntax highlighting to make them easier to comprehend.
A lot of folks just use LINQPad to fire LINQ Queries, but it is so much more than that. If you are not familiar with LINQPad, or use it only for the most basic of things, you should definitely check out this book.
1. You must have LINQPad installed
2. .Net Framework at least version 4.0
3. Know how to read C# code
4. Basic knowledge of SQL and XML would be helpful
5. Chapter 5 requires Some version of Microsoft SQL or MySQL
6. Chapter 6 requires Internet connection to do LINQ to WCF Data service examples
The book is very small with only 7 chapters and 126 pages but it covers many areas such as:
. Where to download, install and how to use LINQPad
. LINQPad can be used as a scripting engine in various languages such as: SQL/ESQL, VB, C# and F#.
. It covers from basic to advance query in LINQ
. It covers querying different data sources via LINQ:
+ LINQ to objects: This is used when you target the in-memory collections
+ LINQ to SQL: This is used when you query a SQL database directly
+ LINQ to XML: This is used when you are manipulating XML
+ LINQ to entity: This is used when you manipulate entities from Microsoft's ORM Entity Framework
Tips: The latest beta of LINQPad has a command line version call "lprun.exe" which allow you to run it as a script rather than as a GUI
. LINQPad has 3 versions: free, Pro and Premium (See this link for more detail: [...]
. In VB and C#, you can run the code as an expression, program or statements mode.
. In F#, you can run the code as an expression or program mode.
. LPRun.exe is extremely useful if you want to import/export data in a script.
If you never use LINQ before, this book will give you some insight of what LINQ can do and you might be able to be more productive with your database query work.