Easy SQL to XML with LINQ and Visual Basic 2008
page 1 of 8
Published: 26 Dec 2007
Abstract
In this article, Richard demonstrates how to create an XML file from a SQL Server 2005 database using LINQ. He provides a detailed explanation of the relevant steps with the help of source code and screenshots captured from Visual Basic 2008 Express Edition. At the end of the article, he also gives a few references where you can learn more regarding the techniques involved with LINQ.
by Richard Dudley
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 39735/ 66

Introduction

In today's business, it's very common to exchange data with business partners.  Most of the information needing to be exchanged resides in a database of some sort.  Because of its flexibility and increasing ease of handling, XML has been utilized more and more as the method of information exchange.

In this article, we'll pretend we are AdventureWorks Cycles, a manufacturer and retailer of bicycles.  To assist the stores which carry our products, we provide them with an updated product catalog on a quarterly basis.  They import this catalog into their databases so their product information is up to date.  Our task in this article is to create an XML file from the AdventureWorks database so it can be securely transferred via FTP to our logistics provider.

We'll use Visual Basic 2008 Express Edition for this example, and we'll create a simple console application which can be run as a scheduled task. Remember this is just example coding, not production level coding, so be sure to implement best practices before implementing anything you see here.


View Entire Article

User Comments

Title: SQL or XML   
Name: Sunil
Date: 2012-05-21 2:05:53 AM
Comment:
Dear sir,
i want to create and access the Database using VB 2008.
which one i have to use SQL or XML.
Thank u.
Title: hi   
Name: titi
Date: 2008-08-21 8:48:59 AM
Comment:
very nice article

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-29 2:14:02 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search