Continuous LINQ- create continuous self-updating result sets

http://www.codeplex.com/clinq

Continuous LINQ is a .NET Framework 3.5 extension that builds on the LINQ query syntax to create continuous, self-updating result sets.
In traditional LINQ queries, you write your query and get stale results. With Continuous LINQ,

you write a query and the results of that query are continuously updated as changes are made to the source collection or items within the source collection.

CLINQ has tremendous value in GUI development and is especially useful in binding to filtered streams of data such as financial or other network message data. 

LINQ to SQL Debug Visualizer

http://weblogs.asp.net/scottgu/archive/2007/07/31/linq-to-sql-debug-visualizer.aspx

One of the nice development features that LINQ to SQL supports is the ability to use a "debug visualizer" to hover over a LINQ expression while in the VS 2008 debugger and inspect the raw SQL that the ORM will ultimately execute at runtime when evaluating the LINQ query expression.

For example, assume we write the below LINQ query expression code against a set of data model classes:

Huagati DBML/EDMX Tools-Linq to SQL ADO.NET Entity Framework

http://www.huagati.com/dbmltools/

Do you want to be able to automatically update your Linq to SQL classes to reflect your database schema after making schema changes?  You don't need to look for the "refresh" button anymore – it is available now as an add-in for Visual Studio!

Huagati DBML/EDMX Tools is an add-in for Visual Studio that adds functionality to the Linq2SQL/DBML diagram designer in Visual Studio 2008, and to the ADO.NET Entity Framework designer in Visual Studio 2008 SP1. It adds menu options for synchronizing Linq2SQL designer diagrams with the underlying database, and for renaming Linq-to-SQL (DBML) and EF (EDMX) classes and properties to use .net naming conventions.

LINQPad is a fantastic freeware application that lets you interactively query SQL databases using LINQ (Language Integrated Query).

In this brave new world where LINQ will become more popular an will be broadly adopted by the .NET community it will become very important to become fluent with your use of LINQ. One way to accomplish this is by replacing your use of  SQL Management Studio for interactively querying SQL databases with LINQPad.

According the the LINQPad website you can "Kiss goodbye to SQL Management Studio !".  Does LINQPad replace SQL Management Studio for interactively querying SQL databases? 

Until I found Matt Perdeck's LINQ to CSV library an easy to use library to read and write CSV and tab delimited files with LINQ queries,  I would have said LINQPad is not ready.

In my opinion there are only two reasons not to use LINQPad and both problems are solved by LINQtoCSV.

1. LINQPad lacks the ability to export query results to a csv file.
2. LINQPad's output is limited to 1000 Records.\

Here's how to configure LINQPad to use LINQtoCSV.

Step 1: Download LINQtoCSV and copy to the folder of you choice.

Step 2: Add "LINQtoCSV.dll" Assembly Reference to Tab called "Additional References"  (Query >> Advanced Properties) or (F4)

Step 3: Add "LINQtoCSV" Namespace Reference to Tab called "Additional Namespace Imports"

Step 4: Press the Set as default for new queries button and close the window.

Step 5: Set Query Type to C# Statement(s)

Step 6: Add standard LINQtoCSV code to your Query.

About This Website

Welcome to FantasticFreeware.com's .NET Blog .  This Blog is dedicated to Fantastic .NET Framework Freeware Applications and Technology.  The .NET technologies that you will find here are C#, VB.NET, ASP.NET, .NET 2.0, 3.0, & 3.5 Frameworks, LINQ, WCF, WPF, Silverlight just to name a few.

Subscribe to the FantasticFreeware.com .Net Blog RSS feed here:

FantasticFreeware – is my personal Library of every freeware program that I have found useful.

I have cataloged over 2700+ of only the best hand picked freeware programs since 2003.  To make the list it must be a true freeware application. No demos, trial, shareware, and etc. I continually add to the collection and add about half dozen new freeware applications every week.  The current size of my personal catalog is 50GB and growing. The programs a categorized by major groupings. (Disk, Internet, Security, Development, and etc)

Vlinq-Visual Linq-query builder for Linq to Sql

http://code.msdn.microsoft.com/vlinq

Visual LINQ Query Builder is an add-in to Visual Studio 2008 Designer that helps you visually build LINQ to SQL queries. Functionally it provides the same experience as, for instance the Microsoft Access Query Builder, but in the LINQ domain. The entire UI of this add-in uses Windows Presentation Foundation. The goal of this tool is to help users become more familiar with the LINQ syntax. The tool may also demonstrate to users how to create their own Visual Studio 2008 add-in using Windows Presentation Foundation.

This academic project was developed by two students during an internship at Microsoft France, under the supervision of one of our Developer Evangelists. The project was in full collaboration with the STB International CPE team in Redmond.

LINQPad lets you interactively query SQL databases in a modern query language

http://www.linqpad.net/  

LINQPad lets you interactively query SQL databases in a modern query language: LINQ.  Kiss goodbye to SQL Management Studio!

LINQPad supports everything in C# 3.0 and Framework 3.5:

    * LINQ to SQL
    * LINQ to Objects
    * LINQ to XML

LINQPad is also a terrific tool for learning LINQ: it comes preloaded with 200 examples from the recently released C# 3.0 in a Nutshell.  There's no better way to experience the coolness of LINQ and functional programming.

LINQPad is free and needs no installation: just download and run.  The executable is under 2MB and is self-updating.