Extending C# to Support SQL Syntax at Compile Time

using System;
using Indy.Data;
using ExampleDB;
using NUnit.Framework;

namespace TestSuite {
	public class DBTest {
		public DBTest() { }

    protected Connection _DB;

    [TestFixtureSetUp] 
		protected void ResetDB() {	
      using (Transaction xTx = new Transaction(_DB)) {
        using (CustomerTbl xCustomers = new CustomerTbl(xTx)) {
          xCustomers.Purge(true);
        }
        using (CountryTbl xCountries = new CountryTbl(xTx)) {
          xCountries.Purge(true);
        }
        xTx.Commit();
      }
      using (Transaction xTx = new Transaction(_DB)) {
        using (CountryTbl xCountries = new CountryTbl(xTx)) {
          CountryTbl.Row xCountry;

          xCountry = new CountryTbl.Row();
          xCountry.CountryID = 1;
          xCountry.CountryName = "Russia";
          xCountry.ISOCode = "RU";
          xCountries.Insert(xCountry);

          xCountry = new CountryTbl.Row();
          xCountry.CountryID = 2;
          xCountry.CountryName = "Cyprus";
          xCountry.ISOCode = "CY";
          xCountries.Insert(xCountry);

          xCountry = new CountryTbl.Row();
          xCountry.CountryID = 3;
          xCountry.CountryName = "United States";
          xCountry.ISOCode = "US";
          xCountries.Insert(xCountry);
        }
        using (CustomerTbl xCustomers = new CustomerTbl(xTx)) {
          CustomerTbl.Row xCustomer;

          xCustomer = new CustomerTbl.Row();
          xCustomer.CustomerID = 1;
          xCustomer.NameFirst = "Chad";
          xCustomer.NameLast = "Hower";
          xCustomer.Tag = 1;
          xCustomer.CountryID = 1;
          xCustomer.Log = "Russia, Cyprus, Jordan, Turkey";
          xCustomers.Insert(xCustomer);

          xCustomer = new CustomerTbl.Row();
          xCustomer.CustomerID = xCustomers.NewKey();
          xCustomer.NameFirst = "Hadi";
          xCustomer.NameLast = "Hariri";
          xCustomer.Tag = 2;
          xCustomer.CountryID = 2;
          xCustomers.Insert(xCustomer);

          xCustomer = new CustomerTbl.Row();
          xCustomer.CustomerID = xCustomers.NewKey();
          xCustomer.NameFirst = "Thomas";
          xCustomer.NameLast = "Jefferson";
          xCustomer.CountryID = 3;
          xCustomers.Insert(xCustomer);

          xCustomer = new CustomerTbl.Row();
          xCustomer.CustomerID = xCustomers.NewKey();
          xCustomer.NameFirst = "James";
          xCustomer.NameLast = "Madison";
          xCustomer.CountryID = 3;
          xCustomers.Insert(xCustomer);
        }
        xTx.Commit();
      }
    }

	}
}