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 from scratch using HTML, CSS, and JavaScript
Start with your own HTML, CSS, and JavaScript and then connect to a database or add dynamic server code using the new inline syntax for ASP.NET Web pages. Code, run, and publish your Web site, all using WebMatrix.
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 desktop client applications
Develop desktop applications that support full transactional support; full referential integrity, including cascading updates and deletes; scrollable and updateable cursors; Microsoft ADO.NET and Microsoft ADO.NET Entity Framework.
Improve developer productivity
Take advantage of integrations with Visual Studio 2010 SP1 and WebMatrix , including rich table and query designers; write, execute, and test queries with visual query plans; full integration with Server Explorer; drag-and-drop IDE support; and ClickOnce for client deployment; and web deploy for deploying websites to third party website service hosting providers.
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.
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, web servers and Windows Embedded appliances.
Simplify deployment
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 ClickOnce and web deploy based deployment options for deploying Windows and ASP.NET Web applications. Perform Xcopy to deploy applications with SQL Server run-time files onto target machines.
