ADO.NET Scenarios Map - J.D. Meier's Blog - Site Home

The ADO.NET Scenarios Map is a consolidated and shared view of the common scenarios and tasks around Microsoft data access technologies. You will find Getting Started and Architecture scenarios first, followed by other common areas. Scenarios in each group should represent common tasks developers would face when building applications that access or interface with data.

Your call to action here is simply scan the ADO.NET Scenarios Map below and either share your scenarios in the comments or email your scenarios to me at feedbackandthought at live.com. Be sure to share your scenarios in the form of “how to blah, blah, blah …” – this makes it much easier to act on and update the map.

For a quick review of what a good Scenarios Map looks like, see my related post, 5 Keys to Effective Scenario Maps.

Categories

Getting Started
Architecture and Design
ADO.NET
ADO.NET Entity Framework
LINQ to DataSet
LINQ to SQL
LINQ to Entities
OData
Silverlight
SQL Azure
SQL Server
WCF Data Services
XML

ADO.NET Scenarios Map

Category	Items
Getting Started	How to connect to SQL Server from an ASP.NET Application using ADO.NET. How to connect to SQL Server from an ASP.NET Application using ADO.NET Entity Framework How to connect to SQL Server from an ASP.NET Application using LINQ to SQL. How to connect to SQL Server from an ASP.NET Application using LINQ to Entities. How to connect to SQL Server from an ASP.NET Application using LINQ to DataSets. How to connect to SQL Server from a Silverlight Application using WCF RIA Services. How to connect to SQL Server from a WPF Application using WCF RIA Services How to connect to a WCF Data Service from an ASP.NET Application
Architecture and Design	How to design an N-tier ASP.NET solution using ADO.NET Entity Framework. How to design an N-tier ASP.NET solution using LINQ to SQL. How to design an N-tier ASP.NET solution using ADO.NET. How to design an N-tier ASP.NET solution using LINQ to Entities. How to design an N-tier ASP.NET solution using WCF Data Services.
ADO.NET	How to populate a DataSet from a SQL Server database. How to populate a DataTable from a SQL Server database. How to populate a DataReader from a SQL Server database. How to databind to a DataTable. How to populate a DataSet from a multi-table join. How to support file based data sources with a DataTable.
LINQ to DataSet	How to query an ADO.NET DataSet from LINQ. How to load a DataTable using LINQ. How to obtain a Count from a DataSet How to perform a Join query on a DataSet How to obtain a Count on a Group in a DataSet. How to order data from a DataSet How to copy data from a DataSet How to use element operators on a DataSet. How to apply complex criteria to a DataSet. How to create a Union within a DataSet. How to query an ADO.NET DataSet from LINQ. How to obtain a Count from a DataSet How to perform a Join query on a DataSet How to obtain a Count on a Group in a DataSet. How to order data from a DataSet How to copy data from a DataSet How to use element operators on a DataSet. How to apply complex criteria to a DataSet. How to create a Union within a DataSet.
LINQ to SQL	How to query a SQL Server table from LINQ. How to perform an update in a 1-to-many relationship. How to perform an update in a many-to-many relationship. How to perform a multi-table query from LINQ. How to perform SQL string operations within a LINQ query. How to perform an insert in a 1-to-many relationship. How to perform an insert in a many-to-many relationship. How to perform a delete in a 1-to-many relationship. How to perform a delete in a many-to-many relationship. How to perform a data update within a transaction. How to perform calculations in an LINQ query.
LINQ to Entities	How to query an Entity Framework Data Model. How to use expressions in LINQ to Entities. How to call TSQL functions in a LINQ query. How to call model-defined functions as object methods. How to implement a .Find method. How to increase performance with compiled queries. How to map preexisting stored procedures to entities.
OData	How to build an OData interface to SQL Server How to build an OData interface in a WCF service. How to perform basic CRUD operations against an OData data source. How to use WCF Data Services to build an OData interface. How to access an OData interface from JavaScript. How to access an OData interface from jQuery. How to access an OData interface from Ajax. How to perform transactions against an OData data source. How to create an AtomPub server.
Silverlight	How to access a WCF Data Service using WCF RIA Services.
SQL Azure	How to connect to SQL Azure from ADO.NET. How to connect to SQL Azure from ADO.NET Entity Framework. How to populate an Entity Framework Data Model from SQL Azure. How to use WCF Data Services to expose SQL Azure as an OData data source. How to perform LINQ queries against SQL Azure. How to perform a two-phase commit transaction against SQL Azure. How to expose SQL Azure as an AtomPub server. How to build a scalable transactional database in SQL Azure.
SQL Server	How to connect to SQL Server from ADO.NET. How to connect to SQL Server from ADO.NET Entity Framework. How to populate an Entity Framework Data Model from SQL Server. How to use WCF Data Services to expose SQL Server as an OData data source. How to perform LINQ queries against SQL Server. How to perform a two-phase commit transaction against SQL Server. How to expose data as XML. How to build a scalable transactional database in SQL Server.
WCF Data Services	How to use WCF Data Services to build an interface for a relational data source. How to access data from Silverlight using WCF Data Services How to access data from WPF using WCF Data Services How to access data from ASP.NET using WCF Data Services How to use WCF Data Services to build an interface for a non-relational data source. How to access data from Ajax using WCF Data Services How to access a WCF Data Services data source through WCF RIA Services How to use WCF Data Services to build an interface for a hierarchical data source. How to use AppFabric Access Control to protect an OData data source.
XML	How to retrieve XML from SQL Server. How to retrieve XML from an OData provider. How to retrieve XML from SQL Azure.