SqlServerStorage ExtractRecords Example

This example shows how to read records from a sql server storage and later write it to a file.

The Problem

For example if you want to extract the records of the Orders table of the Northwind DB

 

To use Delimited Format

You must define:

[DelimitedRecord("|")] public class OrdersVerticalBar { public int OrderID; public string CustomerID; public int EmployeeID; public DateTime OrderDate; public DateTime RequiredDate; [FieldNullValue(typeof(DateTime), "2005-1-1")] public DateTime ShippedDate; public int ShipVia; public decimal Freight; }

The SqlServerStorage

The idea is a lot simple you create the SqlServerStorage with your record class.

SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar)); storage.ServerName = "NEON-64"; storage.DatabaseName = "Northwind"; // Comment this for Windows Auth storage.UserName = "Marcos"; storage.UserPass = "private :)";

After these lines if you want to get the records from the Db you need this lines: storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder); OrdersVerticalBar[] res = storage.ExtractRecords() as OrdersVerticalBar[];

The FillRecord method is somethig like that: protected void FillRecordOrder(object rec, object[] fields) { OrdersVerticalBar record = (OrdersVerticalBar) rec; record.OrderID = (int) fields[0]; record.CustomerID = (string) fields[1]; record.EmployeeID = (int) fields[2]; record.OrderDate = (DateTime) fields[3]; record.RequiredDate = (DateTime) fields[4]; if (fields[5] != DBNull.Value) record.ShippedDate = (DateTime) fields[5]; else record.ShippedDate = DateTime.MinValue; record.ShipVia = (int) fields[6]; record.Freight = (decimal) fields[7]; }

Write the results direct to a File

     You need this code for that task:

FileDataLink.EasyExtractToFile(storage, "outfile.txt"); // or FileDataLink link = new FileDataLink(storage); link.ExtractToFile("outfile.txt");

See also

Must Read - Quick Start Guide - Attributes List - F.A.Q. - Examples of Use - Contacts & Credits - Donations

---

© 2005-07 to Marcos Meli FileHelpers on SourceForge