Everything you need to build Web sites using Windows
Microsoft WebMatrix is a new Web development tool that includes IIS Express (a development Web server), ASP.NET (a Web framework), and SQL Server Compact (an embedded database).
WebMatrix makes Web site development easy
Start coding, testing, and deploying your own Web sites without having to worry about configuring your own Web server, managing databases, or learning a lot of concepts.
Start with popular PHP or ASP.NET Web apps
Free and popular open-source Web applications such as WordPress, Joomla!, DotNetNuke or Umbraco are just a click away. Simply select an application, and WebMatrix handles downloading, installing, and configuring it for you. Customize your site using the built-in code-editor and make it yours.
Seamless site publishing and hosting
With WebMatrix you can find the perfect home for your Web site. Use WebMatrix to find a Web host that fits your requirements and use the built-in publishing support for FTP, FTPS, and WebDeploy to ensure that your files, databases, and settings arrive intact on the Web.
Develop applications by using Transact-SQL functionality
Develop applications that exploit a rich subset of Transact-SQL functionality and manage virtually any kind of data, including JOINS and subqueries; filters, grouping, aggregates, and sorting; CROSS APPLY and OUTER APPLY; and BLOB/image data types.
Build full-featured mobile and desktop client applications
Develop mobile and desktop applications that support full transactional support; full referential integrity, including cascading updates and deletes; scrollable and updateable cursors; Microsoft ADO.NET, LINQ to SQL, and LINQ to Entities.
Improve developer productivity
Take advantage of integrations with Visual Studio 2008, including rich table and query designers; full integration with Server Explorer; drag-and-drop IDE support; designer for RAD configuration of Sync Services for ADO.NET; ClickOnce for client deployment; and automatic CAB deployment for Windows Phones.
Access data easily
Connect to SQL Server Compact databases easily from both managed and unmanaged code by using the included ADO.NET Data Provider or the OLE DB Provider.
Accelerate development with LINQ support
Write highly effective query logic and reduce the amount of data access code by taking advantage of support for LINQ.
Manage with ease
Easily interact with SQL Server Compact databases with comprehensive SQL Server Management Studio integration. Connect to local SQL Server Compact databases; manage objects with full Object Explorer integration; write, execute, and test queries with visual query plans; access management and maintenance options.
Reduce maintenance overhead
Maintain and manage SQL Server Compact databases with a simple programming API that provides total database control. Backup and restore SQL Server Compact databases with simple file-copy operations.
Extend development reach
Create intelligent, data-centric applications for Windows operating systems running on desktops, servers, laptops, and mobile devices, as well as Windows Embedded appliances.
Achieve a friction-free deployment. Gain support for automatic updates. Seamlessly embed with managed and native applications, avoiding the need for administrative deployment. Take advantage of CAB-based deployment options for mobile devices. Perform Xcopy to deploy applications with SQL Server run-time files onto target machines.
Synchronize corporate data
Synchronize data automatically with support for the next-generation synchronization platform from Microsoft: Sync Services for ADO.NET. Securely extend centralized enterprise data to users and mobile devices. Create powerful, sync-enabled database applications that can run on desktops and mobile devices.
Keep data synchronized with merge replication
Keep mobile and occasionally connected systems synchronized with full support for merge replication. Improve scalability with support for horizontal and vertical replication filters. Take advantage of complex conflict resolution capabilities to build powerful business solutions.