document.write('using System;
');
document.write('using System.Data.SqlClient;
');
document.write('using System.Reflection;
');
document.write('using Skybow.CodeProvisioning;
');
document.write('using Skybow.SqlMethods;
');
document.write('
');
document.write('public class Commands
');
document.write('{
');
document.write(' [ SqlMethod ]
');
document.write(' public SqlCommand GetCustomerName(SqlConnection connection,
');
document.write(' int customerId)
');
document.write(' {
');
document.write(' MethodInfo thisMethod = MethodBase.GetCurrentMethod();
');
document.write(' SqlMethod sqlMethod = (SqlMethod) MethodImplBinder.GetImplementation(thisMethod);
');
document.write(' return sqlMethod.CreateCommand(connection, new object[] { customerId });
');
document.write(' }
');
document.write('
');
document.write(' [ SqlOutMethod ]
');
document.write(' public void EndGetCustomerName(SqlCommand command,
');
document.write(' [ SqlParameter(SqlDbType.NVarChar, 30) ] out string firstName,
');
document.write(' [ SqlParameter(SqlDbType.NVarChar, 30) ] out string lastName)
');
document.write(' {
');
document.write(' MethodInfo thisMethod = MethodBase.GetCurrentMethod();
');
document.write(' SqlOutMethod sqlOutMethod = (SqlOutMethod) MethodImplBinder.GetImplementation(thisMethod);
');
document.write(' object[] values = sqlOutMethod.GetCommandOutput(command);
');
document.write('
');
document.write(' firstName = (string) values[0];
');
document.write(' lastName = (string) values[1];
');
document.write(' }
');
document.write('}');