SqlServerStorage InsertRecords Example

This example shows how to write records to an sql server storage

The Problem

For example if you want to insert records to the Customers table in the Northwind DB

To use Delimited Format

You must define:

[DelimitedRecord("|")] public class CustomersVerticalBar { public string CustomerID; public string CompanyName; public string ContactName; public string ContactTitle; public string Address; public string City; public string Country; }

The SqlServerStorage

The idea is very simple you create the SqlServerStorage with your record class

SqlServerStorage storage = new SqlServerStorage(typeof(CustomersVerticalBar)); 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 insert records to your db you need these lines: storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust); CustomersVerticalBar[] res = CommonEngine.ReadFile(typeof(CustomersVerticalBar), "infile.txt") as CustomerVerticalBar[]; storage.InsertRecords(res); // or directly: storage.InsertRecords(CommonEngine.ReadFile(typeof(CustomersVerticalBar), "infile.txt"));

The GetInsertSql method must look something like that: protected string GetInsertSqlCust(object record) { CustomersVerticalBar obj = (CustomersVerticalBar) record; return String.Format("INSERT INTO Customers (Address, City, CompanyName, ContactName, ContactTitle, Country, CustomerID) " + " VALUES ( '{0}' , '{1}' , '{2}' , '{3}' , '{4}' , '{5}' , '{6}' ); ", obj.Address, obj.City, obj.CompanyName, obj.ContactName, obj.ContactTitle, obj.Country, obj.CustomerID ); }

Read the data from a File

     You need this code for that task:

FileDataLink.EasyInsertFromFile(storage, "infile.txt"); // or FileDataLink link = new FileDataLink(storage); link.InsertFromToFile("infile.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