Link: http://blogs.msdn.com/ B /jmeier/archive/2010/10/31/ado-net-code-samples-collection.aspx
Copyright Disclaimer: All copyrights in this article belong to the original author.
Ado. Net code samples collection J. D. Meier 31 Oct 2010 pm
The ADO. Net code samples collection is a roundup and map of some of the varous data access code samples from varous 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 meFeedbackandthoughts 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
- writing 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
|