ADO.NET Code Samples Collection【转载】

原文链接：http://blogs.msdn.com/b/jmeier/archive/2010/10/31/ado-net-code-samples-collection.aspx

ADO.NET Code Samples Collection

J.D. Meier

31 Oct 2010 3:17 PM

The ADO.NET Code Samples Collection is a roundup and map of some of the various data access code samples from various sources including the MSDN library, Code Gallery, CodePlex, and Microsoft Support.

You can add to the code examples collection by sharing in the comments or emailing me at FeedbackAndThoughts at live.com.

Common Categories for ADO.NET Code Samples
The ADO.NET Code Samples Collection is organized using the following categories:

ADO.NET Code Samples Collection

Category	Items
Data Binding	MSDN Library Binding to an ADO.NET DataSet Sample - http://msdn.microsoft.com/en-us/library/ms771774(VS.85).aspx
Data Models	Code Gallery ADO.NET Entity Data Model Designer Extension Starter Kit - http://code.msdn.microsoft.com/DesignerExtStartKit/Wiki/View.aspx?title=Home&version=1 Project Riviera - http://code.msdn.microsoft.com/riviera Microsoft Support How to work with table relationships and entity inheritances in ADO.NET EDM - http://code.msdn.microsoft.com/KB977997
DataReader	MSDN Library ADO.NET Sample Application - http://msdn.microsoft.com/en-us/library/dw70f090(VS.71).aspx
DataSet	MSDN Library Binding to an ADO.NET DataSet Sample - http://msdn.microsoft.com/en-us/library/ms771774(VS.85).aspx Consuming a DataSet from an XML Web Service - http://msdn.microsoft.com/en-us/library/s5xy331f(VS.71).aspx DataSet and DataTable in ADO.NET 2.0 - http://msdn.microsoft.com/en-us/magazine/cc163709.aspx
DataTable	MSDN Library DataSet and DataTable in ADO.NET 2.0 - http://msdn.microsoft.com/en-us/magazine/cc163709.aspx
Entity Framework	All-in-One Code Framework EF4 CodeOnly Feature (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#829046 EF4 CodeOnly Feature (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#829050 EF4.0 Complex Type Objects (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#786345 EF4.0 Complex Type Objects (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#786372 EF4.0 Foreign Key Association (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#786364 EF4.0 Foreign Key Association (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#786387 EF4 Lazy Loading Feature (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#1007360 EF4 Lazy Loading Feature (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#1317759 EF4.0 Model First feature (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#786820 EF4.0 Model First feature (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#786824 Entity Data Model (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#761797 Entity Data Model (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#761780 Code Gallery Entity Data Model Metadata Samples - http://code.msdn.microsoft.com/EdmMetadataSamples Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010 - http://code.msdn.microsoft.com/mag201004VSData Entity Framework Documentation Samples - http://code.msdn.microsoft.com/EFDocSamples Entity Framework Query Samples - http://code.msdn.microsoft.com/EFQuerySamples Entity Framework Sample Provider - http://code.msdn.microsoft.com/EFSampleProvider Hands-on-Lab: Using the Entity Framework in .NET 4 and Visual Studio 2010 - http://code.msdn.microsoft.com/EntityFxHOLPDC09 Sample EDMX Code Generator - http://code.msdn.microsoft.com/sampleedmxcodegen Sample Entity Framework Provider for Oracle - http://code.msdn.microsoft.com/EFOracleProvider SketchPad - http://code.msdn.microsoft.com/sketchpad
General	All-in-One Code Framework Use ADO.NET in a C# application - http://1code.codeplex.com/SourceControl/changeset/view/55574#394619 Use ADO in a VB.NET application - http://1code.codeplex.com/SourceControl/changeset/view/55574#960683 Use ADO.NET in a C++ application - http://1code.codeplex.com/SourceControl/changeset/view/55574#394577 MSDN Library .NET Framework Data Provider for ODBC - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_Odbc ,NET Framework Data Provider for OLE DB - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_OleDb .NET Framework Data Provider for Oracle - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_OracleClient AdventureWorks Sales Model - http://msdn.microsoft.com/en-us/library/bb387147.aspx Course Manager Application - http://msdn.microsoft.com/en-us/library/ff595296.aspx Human Resources Skills Application - http://msdn.microsoft.com/en-us/library/ee620621.aspx Serializing Self-Tracking Entities - http://msdn.microsoft.com/en-us/library/ff595295.aspx School Model - http://msdn.microsoft.com/en-us/library/bb896300.aspx Typed ObjectQuery - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_QBM
LINQ to DataSet	MSDN Library LINQ Samples Hub page - http://msdn.microsoft.com/en-us/library/bb397980.aspx#csharp
LINQ to Entities	MSDN Library EntityClient data provider - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_EntityClient LINQ Samples Hub page - http://msdn.microsoft.com/en-us/library/bb397980.aspx#csharp LINQ to Entities - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_LINQ
LINQ to Objects	All-in-One Code Framework Use LINQ to Objects in C# - http://1code.codeplex.com/SourceControl/changeset/view/55574#501157 Use LINQ to Objects in VB.NET - http://1code.codeplex.com/SourceControl/changeset/view/55574#598174
LINQ to SQL	All-in-One Code Framework Use LINQ to SQL in C# - http://1code.codeplex.com/SourceControl/changeset/view/55574#511053 Use LINQ to SQL in VB.NET - http://1code.codeplex.com/SourceControl/changeset/view/55574#600266 Code Gallery LINQ to SQL N-tier Smart Client - http://code.msdn.microsoft.com/linqntier Code Gallery An Example of a Multi Tier Architecture for LINQ to SQL - http://code.msdn.microsoft.com/multitierlinqtosql LINQ Samples Hub page - http://msdn.microsoft.com/en-us/library/bb397980.aspx#csharp LINQ to SQL - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_LINQ2SQL LINQ to SQL N-tier Smart Client - http://code.msdn.microsoft.com/linqntier SketchPad - http://code.msdn.microsoft.com/sketchpad TPT Inheritance with LINQ to SQL - http://code.msdn.microsoft.com/TPT
N-Tier	Code Gallery An Example of a Multi Tier Architecture for LINQ to SQL - http://code.msdn.microsoft.com/multitierlinqtosql Building N-Tier Apps with EF4 - http://code.msdn.microsoft.com/mag200911EF4 LINQ to SQL N-tier Smart Client - http://code.msdn.microsoft.com/linqntier
O/RM Mapping	Code Gallery Entity Framework Sample Provider - http://code.msdn.microsoft.com/EFSampleProvider
OData	Code Gallery Silverlight Samples for OData Over SQL Azure with AppFabric Access Control - http://code.msdn.microsoft.com/SL3ODataSQLAzureACS WCF Data Services Documentation Samples - http://code.msdn.microsoft.com/AstoriaDocSamples
POCO	Update POCO entity properties and relationships (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#1317741 Update POCO entity properties and relationships (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#1317759
Silverlight	Code Gallery How to consume ADO.NET Data Services in Silverlight 3 - http://code.msdn.microsoft.com/KB982499
SQL Server	MSDN Library .NET Framework Data Provider for SQL Server - http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_SqlClient Conserving Resources When Writing BLOB Values to SQL Server - http://msdn.microsoft.com/en-us/library/3517w44b(VS.71).aspx Optimistic Concurrency - http://msdn.microsoft.com/en-us/library/aa0416cz(VS.71).aspx Paging Through a Query Result - http://msdn.microsoft.com/en-us/library/tx1c9c2f(VS.71).aspx Retrieving Identity or Autonumber Values - http://msdn.microsoft.com/en-us/library/ks9f57t0(VS.71).aspx
Streaming	Code Gallery Streaming Photo Data Service Sample - http://code.msdn.microsoft.com/StreamingPhotoData/Wiki/View.aspx
WCF Data Services	All-in-One Code Framework ADO.NET Data Service in C# - http://1code.codeplex.com/SourceControl/changeset/view/55574#659875 ADO.NET Data Service in VB.NET - http://1code.codeplex.com/SourceControl/changeset/view/55574#659791 Use ADO.NET Data Service in C# - http://1code.codeplex.com/SourceControl/changeset/view/55574#659914 Use ADO.NET Data Service in VB.NET - http://1code.codeplex.com/SourceControl/changeset/view/55574#659888 Use ADO.NET Data Service in Silverlight (C#) - http://1code.codeplex.com/SourceControl/changeset/view/55574#825814 Use ADO.NET Data Service in Silverlight (VB.NET) - http://1code.codeplex.com/SourceControl/changeset/view/55574#825838 Code Gallery Building an ADO.NET Data Services WPF Client - http://code.msdn.microsoft.com/astoriawpf/Release/ProjectReleases.aspx?ReleaseId=2083 How to consume ADO.NET Data Services in Silverlight 3 - http://code.msdn.microsoft.com/KB982499 How to create and then to call ADO.NET Data Services for different data sources - http://code.msdn.microsoft.com/KB982497 JSONP and URL-controlled format support for ADO.NET Data Services - http://code.msdn.microsoft.com/DataServicesJSONP WCF Data Services Documentation Samples - http://code.msdn.microsoft.com/AstoriaDocSamples

时间： 2024-09-11 08:47:07

ADO.NET Code Samples Collection【转载】的相关文章

Common ASP.NET Code Techniques (DPC&amp;DWC Reference)--6

asp.net Figure 2.5Output of Listing 2.1.5 when viewed through a browser. If you've worked with classic ASP, you are likely familiar with the concept of session-level variables. These variables are defined on a per-user basis and last for the duration

[20170412]op code列表.txt

[20170412]op code列表.txt 转载:http://www.itpub.net/thread-1517926-1-1.html --看redo转储,需要了解OP的含义,做一个记录: 附op code列表(来自网络): 格式:layer: opcode LAYER的含义: 4 - Block Cleanout 5 - Transaction Management 10 - 索引操作

Table-values parameter(TVP)系列之三: 利用Collection将其作为参数传给SP

一,回顾上一部分讲述了"在ADO.NET中利用DataTable对象,将其作为参数传给存贮过程". 通过DataTable实例,完成了两部分的内容: 1)DataTable的数据传输给Stored Procedure 2)利用DataTable的TVP数据,可以参与别的实体数据读写(DataReader). 这一部分的内容,通过Collection对象,还是要实现上边的两个实例. 二,在ADO.NET中利用Collection对象,将其作为参数传给存贮过程通过实例,大家

资源分享：学习CSS的相关资源网站

css Creating a graphRuss Weakley - Creating a graph using percentage background images CSS FOR BAR GRAPHSBasic CSS Bar Graph, Complex CSS Bar Graph, Vertical CSS Bar Graph Super simple CSS barsTobias Lütke Dynamic Pie Chart with CSSThis is an example

Java认证宝典v1.0之SCJD篇

Java认证宝典v1.0之SCJD篇Java认证宝典v1.0之SCJD篇(本文为www.java365.com原创,版权所有,转载请注明出处) 在J2EE尚未得到规模应用以前,SCJD是java认证中的高级认证.即便现在有了SCWCD.SCJA等认证,SCJD依然有其独特的魅力. 一.考试目标 Programming Assignment Objectives Write an application program using Java technology. The application

值得推荐的程序员网站

IT资讯及博客网站: CSDN:http://www.csdn.net/ 伯乐在线:http://blog.jobbole.com/ 伯乐在线-博客专注于分享职业相关的博客文章.业界资讯和职业相关的优秀工具和资源.博文类别包括:程序员.设计.营销.互联网.IT技术.自由职业.创业.运营.管理.翻译和人力资源等. 51CTO:http://www.51cto.com/ 中国领先的IT技术网站51CTO(www.51cto.com)是一个为CTO.IT技术经理.系统工程师.网络工程师.安全工程师.数

Writing your first Django app, part 1(转)

Let's learn by example. Throughout this tutorial, we'll walk you through the creation of a basic poll application. It'll consist of two parts: A public site that lets people view polls and vote in them. An admin site that lets you add, change and del

android.support library找不到的解决方法

Downloading the Support Package The Support Package is provided as a downloadable package from the Android SDK Manager. To install: Launch the Android SDK Manager. From Eclipse, you can select Window > Android SDK Manager. Or, launch SDK Manager.exe

VMware 虚拟机的虚拟磁盘编程知识点扫盲之二

目录目录前文列表 VDDK 安装 VDDK VixDiskLib VADP 前文列表 VMware 虚拟机的虚拟磁盘编程知识点扫盲之一 VDDK 摘自官方文档:The Virtual Disk Development Kit (VDDK) is a collection of C/C++ libraries, code samples, utilities, and documentation to help you create and access VMware virtual disk