MSDN Code Gallery Published Resources For Tag ADO.NET

All-In-One Code Framework (A Sample Code Project)

MSDN Code Gallery — Tue, 05 Jan 2010 06:18:22 GMT

Microsoft All-In-One Code Framework delineates the framework and skeleton of Microsoft development techniques through typical sample codes in three popular programming languages (Visual C#, VB.NET, Visual C++). Each sample is elaborately selected, composed, and documented to demonstrate one frequently-asked, tested or used coding scenario based on our support experience in MSDN newsgroups and forums. If you are a software developer, you can fill the skeleton with blood, muscle and soul. If you are a software tester or a support engineer like us, you may extend the sample codes a little to fit your specific test scenario or refer your customer to this project if the customer's question coincides with what we collected.

All-In-One Code Framework (AIO)

MSDN Code Gallery — Mon, 12 Oct 2009 14:37:06 GMT

All-In-One Code Framework code-name CodeFx delineates the framework and skeleton of most Microsoft development techniques (e.g. COM, Data Access, IPC) using typical sample codes in different programming languages (e.g. Visual C#, VB.NET, Visual C++). For instance, the code example ATLDllCOMServer shows the skeleton of an ATL ActiveX DLL as its name implies. Each example is elaborately selected, composed, and documented to demonstrate one frequently-asked, tested or used scenario based on our experience as support engineers. If you are a software developer, you can fill the skeleton with blood, muscle and soul. If you are a software tester or a support engineer like us, you may extend the sample codes a little to fit your specific test scenario or refer your customer to this project if the customer's question coincides with what we collected.

MSDN & TechNet East Region resource site

MSDN Code Gallery — Fri, 11 Sep 2009 16:49:16 GMT

Site for materials from the Microsoft DPE East Region Evangelism team: blogs, events, videos.

All-In-One Code Framework (CHS)

MSDN Code Gallery — Sat, 01 Aug 2009 07:02:49 GMT

All-In-One Code Framework code-name CodeFx delineates the framework and skeleton of most Microsoft development techniques (e.g. COM, Data Access, IPC) using typical sample codes in different programming languages (e.g. Visual C#, VB.NET, Visual C++).

微软一站式开发技术框架解决方案（代号 CodeFx）通过不同编程语言和典型示例勾画出微软几乎所有开发技术的骨架。

WCF Data Services (formerly ADO.NET Data Services) Documentation Samples

MSDN Code Gallery — Mon, 22 Jun 2009 17:59:36 GMT

Samples featured in the WCF Data Services core product documentation.
(WCF Data Services is called ADO.NET Data Services in the documentation that supports Visual Studio 2008 and the .NET Framework 3.5.)

All-In-One Code Framework (AIOCF)

MSDN Code Gallery — Sat, 30 May 2009 14:15:35 GMT

UTN Mobile Mall (ES)

MSDN Code Gallery — Fri, 22 May 2009 21:36:18 GMT

The Spanish-language page for UTN's Mobile E-mall Sample. UTN Mobile Mall es una plataforma de servicios construida usando la infraestructura para desktop y móviles de Microsoft .NET Framework y Microsoft SQL Server. El ejemplo muestra la generación dinámica de servicios web WCF y aplicaciones .NET Compact Framework usando diseñadores gráficos de alto nivel. UTN Mobile Mall posibilita a usuarios no-técnicos diseñar e implementar web services y aplicaciones móviles usando simples diseñadores implementados usando WPF y Silverlight.

Programming Microsoft Synchronization Services for ADO.NET (Devices)

MSDN Code Gallery — Fri, 15 May 2009 18:15:46 GMT

These are the code samples to accompany the whitepaper "Programming Microsoft Synchronization Services for ADO.NET (Devices)" published on MSDN.
These were developed by Appa Mundi Ltd. You may use them and modify them as you wish.

UTN Mobile Mall

MSDN Code Gallery — Thu, 07 May 2009 02:25:32 GMT

UTN Mobile Mall is a services platform built on top of .NET framework desktop and mobile infrastructure. This sample shows dynamic generation of WCF web services and .NET compact framework applications by using high level graphical designers. UTN Mobile Mall enables non-technical users to design and implement web services and mobile applications using simple designers implemented on WPF and Silverlight.

All-In-One Code Framework

MSDN Code Gallery — Fri, 01 May 2009 11:30:43 GMT

NetGuest Online Guestbook

MSDN Code Gallery — Wed, 04 Feb 2009 15:25:00 GMT

My very first Visual Basic web application.

This guestbook will allow users to view and post comments on your website. An admin backend is also included which will give you direct control over what comments are displayed.

ADO.NET Documentation Samples

MSDN Code Gallery — Mon, 26 Jan 2009 20:35:29 GMT

Samples that use ADO.NET for accessing data.

Reading an Excel spreadsheet using ADO.NET

MSDN Code Gallery — Wed, 31 Dec 2008 23:37:17 GMT

Sample code illustrating how to connect to an Excel spreadsheet data source using ADO.NET.

The binary can be used to test connecting to spreadsheets; it supports sheets, sheets with ranges, and named ranges. Arbitrary select statements may be executed; the results are displayed along with the connection string used.

Supports Excel 5.0, 95, 97, 2000, 2003, and 2007 (all three variants). Comments in the code point to additional resources.

WCF Data Services (formerly ADO.NET Data Services and code name "Astoria")

MSDN Code Gallery — Thu, 11 Dec 2008 00:29:58 GMT

Samples and unsupported tools for the WCF (ADO.NET) Data Services Framework.

SubSonic data provider for ADO.NET Data Services

MSDN Code Gallery — Fri, 05 Dec 2008 21:38:36 GMT

SubSonic 3.0 data provider so SubSonic can be used as a read/ write ADO.NET Data Services data source.

Simple DataTable Performance Benchmarks

MSDN Code Gallery — Mon, 17 Nov 2008 07:45:38 GMT

This code provides a set of basic benchmarks for DataTable search and aggregation options, including a comparison to LINQ options.

Entity Framework Documentation Samples for Visual Studio 2008

MSDN Code Gallery — Fri, 19 Sep 2008 00:05:48 GMT

The ADO.NET Entity Framework samples that accompany the Entity Framework documentation on MSDN for Visual Studio 2008. This is the download location for the CourseManager project that you create when you complete the Entity Framework quickstart. You will also find other Entity Data Model tools walkthrough projects as well as the samples described in the Entity Framework documenation.

Mapping Inheritance trees using Entity Framework

MSDN Code Gallery — Mon, 15 Sep 2008 09:32:57 GMT

Microsoft's Entity Data Model allows us to define an application-oriented view of our data consistent with how we reason about that data. For object oriented modeling, the ability to quickly map inheritance hierarchies to RDBMS is the most important benefit of using Entity Framework, with its visual designer.
We will have working examples of TPT (Table per type), and TPH (Table per hierarchy) implemented in Visual Studio 2008 SP1.

What's New in Visual Studio 2008 SP1?

MSDN Code Gallery — Thu, 11 Sep 2008 22:47:24 GMT

This sample contains presentaion materials on some of the new features in Visual Studio Service Pack 1 focusing on client and data including new SQL 2008 data types and Sync Services enhancements, ADO.NET Entity Framework, ADO.NET Data Services, WPF performance and data enhancements, Client Profile Deployment, VSTO Add-In Host Controls and Smart Tags, and VSTO deployment and end-user install troubleshooting improvements.

TeamVision

MSDN Code Gallery — Mon, 08 Sep 2008 02:37:47 GMT

TeamVision is a simple task management application built using the Windows Forms classes of the Microsoft® .NET Framework—an integral Windows® component that supports building and running the next generation of applications. TeamVision allows authenticated users to view, modify, and add projects and tasks that are shared with other users. It may be used in any number of scenarios, from bug tracking to managing work orders or customer service requests. Its primary purpose is to provide quality, sample source code to developers interested in building data-centric applications with ADO.NET using the .NET Framework.

EdmGen2.exe

MSDN Code Gallery — Fri, 20 Jun 2008 20:05:27 GMT

A command-line tool for the Microsoft Entity Framework. This tool is able to read and write the EDMX file format, as well as translate between EDMX and CSDL, SSDL & MSL file formats. It can be used as a replacement for the EdmGen.exe tool that ships with the .Net Framework 3.5.

Entity Framework Sample Provider

MSDN Code Gallery — Tue, 03 Jun 2008 08:42:16 GMT

Sample ADO.NET Provider for Entity Framework

ADO.NET Entity Framework Query Samples

MSDN Code Gallery — Wed, 14 May 2008 03:52:14 GMT

ADO.NET Entity Framework Query Samples is a small Windows Forms program which contains several basic Entity SQL and LINQ to Entities queries against that NorthwindEF Entity Data Model (a modified version of Northwind).

Its goal is to help you learn the features of the different query languages available in the Entity Framework, and to let you visualize how the results and the translated store queries look like.

Transparent Lazy Loading for Entity Framework

MSDN Code Gallery — Mon, 12 May 2008 21:29:48 GMT

Experimental implementation of Transparent Lazy Loading for Entity Framework using code generation and IPOCO.

ADO.NET Entity Framework Extensions

MSDN Code Gallery — Mon, 24 Mar 2008 18:11:09 GMT

The ADO.NET Entity Framework Extensions library includes utilities that make querying stored procedures, creating typed results from DB data readers and state tracking external data much easier in the Entity Framework. A sample application demonstrates several patterns using these utilities, including stored procedures with multiple result sets, materialization of CLR types, and registering entities in the Entity Framework state manager.

Entity Framework Mapping Helper

MSDN Code Gallery — Tue, 18 Mar 2008 05:02:24 GMT

Entity Framework mapping helper lets you create sample mapping files for the set of scenarios you are interested in. It’s a great tool for a deeper understanding for how schema files are defined for complex mapping scenarios in Entity Framework.

SketchPad

MSDN Code Gallery — Fri, 14 Mar 2008 10:12:40 GMT

SketchPad is a simple drawing editor that allows you to create elementary geometric shapes--lines and circles--and model them as entities using either the Entity Framework or LINQ to SQL. Think of it as a 'Notepad for Shapes'--you can create, read, and delete shapes, and use the built-in spatial index to search for entities by attribute value. A command-line argument allows you to switch between the Entity Framework and LINQ to SQL runtime for the model.

The sample comes with complete source code in a Visual Studio 2008 solution. For details and usage, visit http://blogs.msdn.com/sbajaj.

WilsonXmlDbClient

MSDN Code Gallery — Sat, 23 Feb 2008 09:02:31 GMT

The WilsonXmlDbClient is an ADO.NET provider that enables Xml to be worked with just like any other database in .NET. It supports the most common Select, Insert, Update, and Delete SQL syntax, as well as tranactions and parameters.

More info here: http://weblogs.asp.net/pwilson/archive/2004/09/18/231185.aspx

and here:

http://weblogs.asp.net/kencox/archive/2005/10/04/426600.aspx#5842873

Flat File Data Reader

MSDN Code Gallery — Mon, 18 Feb 2008 18:40:05 GMT

An abstract IDataReader implementation that reads flat files. Enables bulk loading of SQL Server using SqlBulkCopy from flat files with strange formats.

For ordinary delimited or fixed-width files, SSIS is a better tool, but when your file format doesn't work well with these tools or you need a pure .NET solution, consider using this FlatFileDataReader. Includes the option to skip over lines in the file for multi-format files.

Good scenarios are loading from clients (without SSIS), and loading files with multiple record layouts, heders and footers, etc.

Package includes a sample solution.

LINQ Entity Data Reader

MSDN Code Gallery — Mon, 18 Feb 2008 06:18:31 GMT

An IDataReader implementation that reads a collecion of entities to enable using SqlbulkCopy with LINQ.

Dariusz Parys Resources

MSDN Code Gallery — Tue, 05 Feb 2008 12:45:55 GMT

On this page I will share all code samples given at various screenscasts, webcasts, talks at conferences and customer presentations.

Please keep in mind that the source published here is just demo source code, it should not be used for production code.

ADO.NET Entity Framework & LINQ to Relational Data

MSDN Code Gallery — Fri, 25 Jan 2008 06:03:19 GMT

Samples and unsupported tools for the ADO.NET Entity Framework(including LINQ to Entities) and LINQ to SQL.

Perseus: Entity Framework EntityBag

MSDN Code Gallery — Thu, 24 Jan 2008 23:04:30 GMT

Perseus is a small project designed to explore ways for exchanging graphs of Entity Framework entities over WCF web services. The key piece of the project is EntityBag<T> which stores a graph of entities along with change tracking information. Here's hoping no one will use this to store & transport something as nasty as Medusa's head. ;-)

Sample EDMX Code Generator

MSDN Code Gallery — Thu, 24 Jan 2008 22:05:11 GMT

The goal of the Sample EDMX Code Generator is to provide you with enough insight into how the ADO.NET Entity Designer generates code in Visual Studio and hopefully give you a head start with some sample source code.

SampleEdmxCodeGenerator is not intended for production use; instead, it demonstrates custom tool extensibility via SingleFileGenerator, code generation APIs, code generation events and EDM metadata APIs. The sample is also somewhat incomplete on error handling and has not been tuned for performance, stress, etc.

Entity SQL

MSDN Code Gallery — Thu, 24 Jan 2008 08:51:42 GMT

Entity SQL tools and samples. eSqlBlast home.