Microsoft has released web-based management tools (code-named “Houston”) for SQL Azure databases. Houston provides basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data. Houston is designed to be lightweight and easy to use.
SQL Azure is a cloud-based database for websites running on the .NET platform. SQL Azure allows developers to implement a scalable and secure custom web application without worrying about installing and updating software or managing physical hardware.
Project Houston Homepage
MSDN Blog Article
The open-source MS-SQL Code Generation Tool generates C# classes from an MS-SQL database. Each class is generated with the appropriate constructors, CRUD methods, and methods that fetch data according foreign keys. The tool includes profiling support and database preferences. DBLayer and type converter classes are included in the source code. .NET Framework 3.5 with SQL Server Management Objects (SMO) is required.
MS-SQL Code Generation Tool at CodePlex
Linquify is a Visual Studio 2008/2010 add-in and C# .NET business class generator for LINQ to SQL and the Entity Framework, helping to support rapid development of .NET and ASP .NET web application data layers. Linquify is free for use under the LGPL.
Linquify installs as a Visual Studio 2008/2010 add-in, which allows you to select your LINQ to SQL dbml file or Entity Framework edmx file and automatically generate a set of easy to use business classes. The generated classes allow you to support a complete 3-tier software architecture and simple handling of database objects, with full support for LINQ queries. Customizations to the generated classes can be easily made within the generated user partial classes.
Linquify on CodePlex
Linquify Homepage
PLINQO is a free object-to-relational mapper for the Microsoft .NET Framework. PLINQO opens the LINQ TO SQL black box giving you the ability to control your source code while adding many new features and enhancements. New features in v5.0 include:
- Visual Studio 2010 and .NET 4 Support
- SQLCacheDependancy Support
- IQueryable Cache Extensions
- BeginTransaction with no overload
- Many other features and bug fixes
Note that PLINQO requires the latest version of CodeSmith Professional. The original source code in C# and VB is available.
Special Offer: Write about your PLINQO experience in your blog or Twitter and receive a free personal license for CodeSmith Professional. See offer details.
PLINQO Home Page
Noah Hart has ported SQLite3 to C#. While the first port is slower than the original, the project opens the way for SQLite to be used in .NET managed projects without using P/Invoke or unsafe code.
The project represents the complete porting of SQLite version 3.6.16 to C#. The code is licensed under Creative Commons 3.0. C#-SQLite passes over 30,000 tests with only 9 still not working. The compiled binary exe is 528KB which is about the same as the original at 506KB.
SQLite Project
More Info
The Microsoft ADO.NET team has discontinued the LINQ to SQL project. Many developers believe this is a mistake, “spitting in the face” of everyone who invested time and money in LINQ-SQL, leaving developers with a costly porting process.
Read more at Ayende @ Rahien
Read more at ADO.NET Team Blog
