FantasticFreeware.com

Open DBDiff -MS-SQL schema compare and upgrade generator

http://www.codeplex.com/OpenDBiff

Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008.
It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.

Open DBDiff can synchronize

    * Tables (including Table Options like vardecimal, text in row, etc.)
    * Columns (including Computed Columns, XML options, Identities, etc.)
    * Constraints
    * Indexes (and XML Indexes)
    * XML Schemas
    * Table Types
    * User Data Types (UDT)
    * CLR Objects (Assemblies, CLR-UDT, CLR-Store Procedure, CLR-Triggers)
    * Triggers (including DDL Triggers)
    * Synonyms
    * Schemas
    * File groups
    * Views
    * Functions
    * Store Procedures
    * Partition Functions/Schemes
    * Users
    * Roles

I didn't found any tool like this 100% open source for SQL Server. It does not depend on any privative tool or component. I do its work without resorting to SMO.
We tested this tool with more than 100 distinct testing use cases

SQL Server 2005 Driver for PHP

http://www.microsoft.com/

Download the SQL Server 2005 Driver for PHP, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.

Query Express-query tool for MSDE and SQL Express

http://www.albahari.com/queryexpress.html

Query Express is a simple Query Analyzer look-alike, but being small and free it can be run where the SQL Server client tools are not installed or licensed. This makes it especially useful as a query tool for MSDE and SQL Express. It also connects to Oracle and other OLE-DB compliant databases.Query Express requires no installation and is packaged as a single 100KB executable. This is more than 300 times smaller than SQL Server Management Studio!Query Express Screenshot. Query Express is ideal for those not yet ready for the LINQ Challenge.Query Express has a fully permissive free license with no conditions attached. Full source code is included, which you can use in commercial software. Compatible with the .NET Framework versions 1.1, 2.0 and above—no additional downloads are required if you have Windows XP SP2 or Windows Vista.

Microsoft Source Code Analyzer for SQL Injection

http://www.microsoft.com/

Community Technology Preview (July 2008)
Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks.

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)

NHibernate- NET Framework data access layer

http://www.hibernate.org/343.html 

NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. Given an XML description of your entities and relationships, NHibernate automatically generates SQL for loading and storing the objects. Optionally, you can describe your mapping metadata with attributes in your source code.

NHibernate supports transparent persistence, your object classes don't have to follow a restrictive programming model. Persistent classes do not need to implement any interface or inherit from a special base class. This makes it possible to design the business logic using plain .NET (CLR) objects and object-oriented idiom.

Originally being a port of Hibernate 2.1, the NHibernate API is very similar to that of Hibernate. All Hibernate knowledge and existing Hibernate documentation is therefore directly applicable to NHibernate. Take a look at the available NHibernate Documentation.

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.