Visual Studio Express 2012 for Web supports ASP.NET data source controls, which connect to and communicate with various types of data sources. For example, the SqlDataSource control contains a data connection object that can connect to a SQL Server database. It also contains data command objects for SQL Select, Update, and Delete statements. Other data-source controls enable you to connect to OLE-DB data sources, XML data sources, and other data sources. The advantage of data source controls is that they provide a consistent interface for data binding for all ASP.NET controls.
Visual Studio Express 2012 for Web supports Language-Integrated Query (LINQ). LINQ is a query syntax that lets you define query operations directly in C# and Visual Basic. LINQ lets you query databases or in-memory data sources. To support database queries, Visual Studio Express 2012 for Web includes an object-relational mapping designer. By using the designer, you can quickly create and edit data classes that map to objects in a database.
Visual Studio Express 2012 for Web supports ASP.NET Dynamic Data. Dynamic Data lets you create extensible data-driven web applications by inferring at run time the appearance and behavior of data entities from the database schema and deriving UI behavior from it.
Visual Studio Express 2012 for Web also supports various data controls that you can add to ASP.NET webpages to display data. These include the GridView, DetailsView, FormView, ListView, DataList, and Repeater controls. Each of these controls enables you to present data in different ways. Each control also supports additional features, which include sorting, paging, editing data records, inserting new data records, and so on. You can also populate controls such as the ListBox and DropDownList controls with data from data source controls.
Visual Studio Express 2012 for Web lets you drag data tables onto a page. When you do, Visual Studio Express 2012 for Web automatically creates preconfigured controls on the page.
You can store data in a local database by using LocalDB or SQL Server Express. For more information about LocalDB, see Local Data Overview. For more information about SQL Server Express, see Using SQL Server Express with ASP.NET.