ADO.NET Scenarios Map

  • Article

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.