public PriKey_DbVersion_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [Version]" + CRLF +
@"FROM [DbVersion]" + CRLF +
@"WHERE [Version] = @Version";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@Version", typeof(string), true, false, DbType.String, null, null, null);
_parameterschema = new VenturaSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaColumn("Version", typeof(string), false)
{
Updateable = true,
IsUnique = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "DbVersion",
BaseColumnName = "Version"
});
((IResultsetBase)this).Schema = new VenturaSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[DbVersion]";
}
public PriKey_Calendar_RequiredAttendees_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [EmailAddress],[ItemId],[Name]" + CRLF +
@"FROM [Exchange].[Calendar_RequiredAttendees]" + CRLF +
@"WHERE [EmailAddress] = @EmailAddress";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@EmailAddress", typeof(string), true, false, DbType.String, null, null, null);
_parameterschema = new VenturaSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaColumn("EmailAddress", typeof(string), true)
{
Updateable = true,
ColumnSize = 255,
NumericScale = 0,
ProviderType = 16,
IsUnique = true,
IsKey = true,
BaseCatalogName = "CData",
BaseSchemaName = "Exchange",
BaseTableName = "Calendar_RequiredAttendees",
BaseColumnName = "EmailAddress"
});
schema_array.Add(new VenturaColumn("ItemId", typeof(string), true)
{
Updateable = true,
ColumnSize = 2000,
NumericScale = 0,
ProviderType = 16,
BaseCatalogName = "CData",
BaseSchemaName = "Exchange",
BaseTableName = "Calendar_RequiredAttendees",
BaseColumnName = "ItemId"
});
schema_array.Add(new VenturaColumn("Name", typeof(string), true)
{
Updateable = true,
ColumnSize = 2000,
NumericScale = 0,
ProviderType = 16,
BaseCatalogName = "CData",
BaseSchemaName = "Exchange",
BaseTableName = "Calendar_RequiredAttendees",
BaseColumnName = "Name"
});
((IResultsetBase)this).Schema = new VenturaSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Exchange].[Calendar_RequiredAttendees]";
}
public PriKey_TaxTypes_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [TaxTypeID],[Name],[Rate]" + CRLF +
@"FROM [TaxTypes]" + CRLF +
@"WHERE [TaxTypeID] = @TaxTypeID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@TaxTypeID", typeof(long), true, false, DbType.Int64, null, null, null);
_parameterschema = new VenturaSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaColumn("TaxTypeID", typeof(long), false)
{
Updateable = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "TaxTypes",
BaseColumnName = "TaxTypeID"
});
schema_array.Add(new VenturaColumn("Name", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "TaxTypes",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaColumn("Rate", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "TaxTypes",
BaseColumnName = "Rate"
});
((IResultsetBase)this).Schema = new VenturaSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[TaxTypes]";
}
public PriKey_OrderItems_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [OrderID],[OrderLine],[Discount],[ProductID],[Quantity],[TaxType],[UnitPrice]" + CRLF +
@"FROM [OrderItems]" + CRLF +
@"WHERE [OrderID] = @OrderID" + CRLF +
@"AND [OrderLine] = @OrderLine";
_inputparametervalues = new object[2];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@OrderID", typeof(long), true, false, DbType.Int64, null, null, null);
param_array.AddParameterColumn("@OrderLine", typeof(long), true, false, DbType.Int64, null, null, null);
_parameterschema = new VenturaSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaColumn("OrderID", typeof(long), false)
{
Updateable = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "OrderItems",
BaseColumnName = "OrderID"
});
schema_array.Add(new VenturaColumn("OrderLine", typeof(long), false)
{
Updateable = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "OrderItems",
BaseColumnName = "OrderLine"
});
schema_array.Add(new VenturaColumn("Discount", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "OrderItems",
BaseColumnName = "Discount"
});
schema_array.Add(new VenturaColumn("ProductID", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "OrderItems",
BaseColumnName = "ProductID"
});
schema_array.Add(new VenturaColumn("Quantity", typeof(long), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "OrderItems",
BaseColumnName = "Quantity"
});
schema_array.Add(new VenturaColumn("TaxType", typeof(long), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "OrderItems",
BaseColumnName = "TaxType"
});
schema_array.Add(new VenturaColumn("UnitPrice", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "OrderItems",
BaseColumnName = "UnitPrice"
});
((IResultsetBase)this).Schema = new VenturaSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[OrderItems]";
}
