document.write('using System;
');
document.write('using System.Data;
');
document.write('using System.Data.SqlClient;
');
document.write('using PubsDb;
');
document.write('
');
document.write('namespace PubsClient
');
document.write('{
');
document.write(' class Application
');
document.write(' {
');
document.write(' // Change connection string if needed.
');
document.write(' const string ConnectionString = "Server=.;Database=pubs;Trusted_Connection=True;";
');
document.write('
');
document.write(' static void Main(string[] args)
');
document.write(' {
');
document.write(' PubsCommands pubs = PubsCommands.CreateInstance();
');
document.write('
');
document.write(' SqlConnection connection = new SqlConnection(ConnectionString);
');
document.write(' connection.Open();
');
document.write('
');
document.write(' SqlDataReader reader = pubs.byroyalty(connection, 50).ExecuteReader();
');
document.write('
');
document.write(' while (reader.Read())
');
document.write(' Console.WriteLine(reader["au_id"]);
');
document.write('
');
document.write(' reader.Close();
');
document.write(' connection.Close();
');
document.write(' }
');
document.write(' }
');
document.write('}');