public PriKey_Sales_PersonCreditCard_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [BusinessEntityID],[CreditCardID],[ModifiedDate]" + CRLF +
@"FROM [Sales].[PersonCreditCard]" + CRLF +
@"WHERE [BusinessEntityID] = @BusinessEntityID" + CRLF +
@"AND [CreditCardID] = @CreditCardID";
_inputparametervalues = new object[2];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@BusinessEntityID", typeof(int), true, false, DbType.Int32, null, null, null);
param_array.AddParameterColumn("@CreditCardID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("BusinessEntityID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "PersonCreditCard",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("CreditCardID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "PersonCreditCard",
BaseColumnName = "CreditCardID"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "PersonCreditCard",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[PersonCreditCard]";
}
public GetAll_TaxTypes_Recordset()
{
_resultsets = new IResultsetBase[] { this };
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("TaxTypeID", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0,
IsUnique = true,
IsKey = true
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true
});
schema_array.Add(new VenturaSqlColumn("Rate", typeof(string), false)
{
Updateable = true
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[TaxTypes]";
}
public PriKey_PaymentTypes_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@PaymentTypeID", typeof(long), true, false, DbType.Int64, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("PaymentTypeID", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0,
IsUnique = true,
IsKey = true
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[PaymentTypes]";
}
public PriKey_Production_ProductDocument_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [ProductID],[DocumentNode],[ModifiedDate]" + CRLF +
@"FROM [Production].[ProductDocument]" + CRLF +
@"WHERE [ProductID] = @ProductID" + CRLF +
@"AND [DocumentNode] = @DocumentNode";
_inputparametervalues = new object[2];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@ProductID", typeof(int), true, false, DbType.Int32, null, null, null);
param_array.AddParameterColumn("@DocumentNode", typeof(object), true, false, DbType.Object, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("ProductID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "ProductDocument",
BaseColumnName = "ProductID"
});
schema_array.Add(new VenturaSqlColumn("DocumentNode", typeof(object), false)
{
Updateable = true,
ColumnSize = 892,
ProviderType = 29,
IsKey = true,
UdtAssemblyQualifiedName = "Microsoft.SqlServer.Types.SqlHierarchyId, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91",
BaseSchemaName = "Production",
BaseTableName = "ProductDocument",
BaseColumnName = "DocumentNode"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "ProductDocument",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[ProductDocument]";
}
public GetAll_OrderStatus_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [Status],[Name]" + CRLF +
@"FROM [OrderStatus]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaColumn("Status", typeof(long), false)
{
Updateable = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "OrderStatus",
BaseColumnName = "Status"
});
schema_array.Add(new VenturaColumn("Name", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "OrderStatus",
BaseColumnName = "Name"
});
((IResultsetBase)this).Schema = new VenturaSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[OrderStatus]";
}
public PriKey_DbVersion_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_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 VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("Version", typeof(string), false)
{
Updateable = true,
IsUnique = true,
IsKey = true
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[DbVersion]";
}
public GetAll_OrderStatus_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [Status],[Name]" + CRLF +
@"FROM [OrderStatus] LIMIT @RowLimit";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("Status", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0,
ProviderType = 12,
IsUnique = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "OrderStatus",
BaseColumnName = "Status"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ProviderType = 16,
BaseCatalogName = "main",
BaseTableName = "OrderStatus",
BaseColumnName = "Name"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[OrderStatus]";
}
public PriKey_Production_ProductModelIllustration_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [ProductModelID],[IllustrationID],[ModifiedDate]" + CRLF +
@"FROM [Production].[ProductModelIllustration]" + CRLF +
@"WHERE [ProductModelID] = @ProductModelID" + CRLF +
@"AND [IllustrationID] = @IllustrationID";
_inputparametervalues = new object[2];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@ProductModelID", typeof(int), true, false, DbType.Int32, null, null, null);
param_array.AddParameterColumn("@IllustrationID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("ProductModelID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "ProductModelIllustration",
BaseColumnName = "ProductModelID"
});
schema_array.Add(new VenturaSqlColumn("IllustrationID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "ProductModelIllustration",
BaseColumnName = "IllustrationID"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "ProductModelIllustration",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[ProductModelIllustration]";
}
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 GetAll_CountryCodes_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [CountryCodeID],[Name]" + CRLF +
@"FROM [CountryCodes] LIMIT @RowLimit";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("CountryCodeID", typeof(string), false)
{
Updateable = true,
ProviderType = 16,
IsUnique = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "CountryCodes",
BaseColumnName = "CountryCodeID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ProviderType = 16,
BaseCatalogName = "main",
BaseTableName = "CountryCodes",
BaseColumnName = "Name"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[CountryCodes]";
}
public GetAll_OrderItems_Recordset()
{
_resultsets = new IResultsetBase[] { this };
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("OrderID", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0,
IsKey = true
});
schema_array.Add(new VenturaSqlColumn("OrderLine", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0,
IsKey = true
});
schema_array.Add(new VenturaSqlColumn("Discount", typeof(string), false)
{
Updateable = true
});
schema_array.Add(new VenturaSqlColumn("ProductID", typeof(string), false)
{
Updateable = true
});
schema_array.Add(new VenturaSqlColumn("Quantity", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0
});
schema_array.Add(new VenturaSqlColumn("TaxType", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0
});
schema_array.Add(new VenturaSqlColumn("UnitPrice", typeof(string), false)
{
Updateable = true
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[OrderItems]";
}
public GetAll_Person_PersonPhone_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [BusinessEntityID],[PhoneNumber],[PhoneNumberTypeID],[ModifiedDate]" + CRLF +
@"FROM [Person].[PersonPhone]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("BusinessEntityID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Person",
BaseTableName = "PersonPhone",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("PhoneNumber", typeof(string), false)
{
Updateable = true,
ColumnSize = 25,
ProviderType = 12,
IsKey = true,
BaseSchemaName = "Person",
BaseTableName = "PersonPhone",
BaseColumnName = "PhoneNumber"
});
schema_array.Add(new VenturaSqlColumn("PhoneNumberTypeID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Person",
BaseTableName = "PersonPhone",
BaseColumnName = "PhoneNumberTypeID"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Person",
BaseTableName = "PersonPhone",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Person].[PersonPhone]";
}
public GetAll_Production_ProductModelProductDescriptionCulture_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [ProductModelID],[ProductDescriptionID],[CultureID],[ModifiedDate]" + CRLF +
@"FROM [Production].[ProductModelProductDescriptionCulture]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("ProductModelID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "ProductModelProductDescriptionCulture",
BaseColumnName = "ProductModelID"
});
schema_array.Add(new VenturaSqlColumn("ProductDescriptionID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "ProductModelProductDescriptionCulture",
BaseColumnName = "ProductDescriptionID"
});
schema_array.Add(new VenturaSqlColumn("CultureID", typeof(string), false)
{
Updateable = true,
ColumnSize = 6,
ProviderType = 10,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "ProductModelProductDescriptionCulture",
BaseColumnName = "CultureID"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "ProductModelProductDescriptionCulture",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[ProductModelProductDescriptionCulture]";
}
public GetAll_Sales_SpecialOfferProduct_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [SpecialOfferID],[ProductID],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Sales].[SpecialOfferProduct]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("SpecialOfferID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "SpecialOfferProduct",
BaseColumnName = "SpecialOfferID"
});
schema_array.Add(new VenturaSqlColumn("ProductID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "SpecialOfferProduct",
BaseColumnName = "ProductID"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Sales",
BaseTableName = "SpecialOfferProduct",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "SpecialOfferProduct",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[SpecialOfferProduct]";
}
public PriKey_Sales_CountryRegionCurrency_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [CountryRegionCode],[CurrencyCode],[ModifiedDate]" + CRLF +
@"FROM [Sales].[CountryRegionCurrency]" + CRLF +
@"WHERE [CountryRegionCode] = @CountryRegionCode" + CRLF +
@"AND [CurrencyCode] = @CurrencyCode";
_inputparametervalues = new object[2];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@CountryRegionCode", typeof(string), true, false, DbType.String, null, null, null);
param_array.AddParameterColumn("@CurrencyCode", typeof(string), true, false, DbType.String, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("CountryRegionCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 12,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "CountryRegionCurrency",
BaseColumnName = "CountryRegionCode"
});
schema_array.Add(new VenturaSqlColumn("CurrencyCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 10,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "CountryRegionCurrency",
BaseColumnName = "CurrencyCode"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "CountryRegionCurrency",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[CountryRegionCurrency]";
}
public GetAll_Sales_SalesReason_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [SalesReasonID],[Name],[ReasonType],[ModifiedDate]" + CRLF +
@"FROM [Sales].[SalesReason]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("SalesReasonID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Sales",
BaseTableName = "SalesReason",
BaseColumnName = "SalesReasonID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "SalesReason",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("ReasonType", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "SalesReason",
BaseColumnName = "ReasonType"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "SalesReason",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[SalesReason]";
}
public PriKey_Person_PhoneNumberType_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [PhoneNumberTypeID],[Name],[ModifiedDate]" + CRLF +
@"FROM [Person].[PhoneNumberType]" + CRLF +
@"WHERE [PhoneNumberTypeID] = @PhoneNumberTypeID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@PhoneNumberTypeID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("PhoneNumberTypeID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Person",
BaseTableName = "PhoneNumberType",
BaseColumnName = "PhoneNumberTypeID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Person",
BaseTableName = "PhoneNumberType",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Person",
BaseTableName = "PhoneNumberType",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Person].[PhoneNumberType]";
}
public GetAll_HumanResources_Department_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [DepartmentID],[Name],[GroupName],[ModifiedDate]" + CRLF +
@"FROM [HumanResources].[Department]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("DepartmentID", typeof(short), false)
{
ColumnSize = 2,
NumericPrecision = 5,
ProviderType = 16,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "HumanResources",
BaseTableName = "Department",
BaseColumnName = "DepartmentID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "HumanResources",
BaseTableName = "Department",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("GroupName", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "HumanResources",
BaseTableName = "Department",
BaseColumnName = "GroupName"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "HumanResources",
BaseTableName = "Department",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[HumanResources].[Department]";
}
public PriKey_Production_UnitMeasure_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [UnitMeasureCode],[Name],[ModifiedDate]" + CRLF +
@"FROM [Production].[UnitMeasure]" + CRLF +
@"WHERE [UnitMeasureCode] = @UnitMeasureCode";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@UnitMeasureCode", typeof(string), true, false, DbType.String, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("UnitMeasureCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 10,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "UnitMeasure",
BaseColumnName = "UnitMeasureCode"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Production",
BaseTableName = "UnitMeasure",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "UnitMeasure",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[UnitMeasure]";
}
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 VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("TaxTypeID", typeof(long), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
NumericScale = 0,
ProviderType = 12,
IsUnique = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "TaxTypes",
BaseColumnName = "TaxTypeID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ProviderType = 16,
BaseCatalogName = "main",
BaseTableName = "TaxTypes",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("Rate", typeof(string), false)
{
Updateable = true,
ProviderType = 16,
BaseCatalogName = "main",
BaseTableName = "TaxTypes",
BaseColumnName = "Rate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[TaxTypes]";
}
public GetAll_Categories_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [CategoryID],[Description],[Name],[Picture],[Thumbnail]" + CRLF +
@"FROM [Categories]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaColumn("CategoryID", typeof(long), false)
{
Updateable = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "Categories",
BaseColumnName = "CategoryID"
});
schema_array.Add(new VenturaColumn("Description", typeof(string), true)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "Categories",
BaseColumnName = "Description"
});
schema_array.Add(new VenturaColumn("Name", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "Categories",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaColumn("Picture", typeof(object), true)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "Categories",
BaseColumnName = "Picture"
});
schema_array.Add(new VenturaColumn("Thumbnail", typeof(object), true)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "Categories",
BaseColumnName = "Thumbnail"
});
((IResultsetBase)this).Schema = new VenturaSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Categories]";
}
public GetAll_Calendar_RequiredAttendees_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [EmailAddress],[ItemId],[Name]" + CRLF +
@"FROM [Exchange].[Calendar_RequiredAttendees]";
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 Incr_Person_PhoneNumberType_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [PhoneNumberTypeID],[Name],[ModifiedDate]" + CRLF +
@"FROM [Person].[PhoneNumberType]" + CRLF +
@"ORDER BY [PhoneNumberTypeID]" + CRLF +
@"OFFSET @RowOffset ROWS FETCH NEXT @RowLimit ROWS ONLY";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("PhoneNumberTypeID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Person",
BaseTableName = "PhoneNumberType",
BaseColumnName = "PhoneNumberTypeID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Person",
BaseTableName = "PhoneNumberType",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Person",
BaseTableName = "PhoneNumberType",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Person].[PhoneNumberType]";
}
public GetAll_Production_ProductDocument_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [ProductID],[DocumentNode],[ModifiedDate]" + CRLF +
@"FROM [Production].[ProductDocument]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("ProductID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "ProductDocument",
BaseColumnName = "ProductID"
});
schema_array.Add(new VenturaSqlColumn("DocumentNode", typeof(object), false)
{
Updateable = true,
ColumnSize = 892,
ProviderType = 29,
IsKey = true,
UdtAssemblyQualifiedName = "Microsoft.SqlServer.Types.SqlHierarchyId, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91",
BaseSchemaName = "Production",
BaseTableName = "ProductDocument",
BaseColumnName = "DocumentNode"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "ProductDocument",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[ProductDocument]";
}
public GetAll_Production_Illustration_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [IllustrationID],[Diagram],[ModifiedDate]" + CRLF +
@"FROM [Production].[Illustration]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("IllustrationID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Production",
BaseTableName = "Illustration",
BaseColumnName = "IllustrationID"
});
schema_array.Add(new VenturaSqlColumn("Diagram", typeof(string), true)
{
Updateable = true,
ProviderType = 25,
IsLong = true,
BaseSchemaName = "Production",
BaseTableName = "Illustration",
BaseColumnName = "Diagram"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "Illustration",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[Illustration]";
}
public GetAll_Person_BusinessEntity_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [BusinessEntityID],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Person].[BusinessEntity]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("BusinessEntityID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Person",
BaseTableName = "BusinessEntity",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Person",
BaseTableName = "BusinessEntity",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Person",
BaseTableName = "BusinessEntity",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Person].[BusinessEntity]";
}
public PriKey_Shippers_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [ShipperID],[Name],[Phone]" + CRLF +
@"FROM [Shippers]" + CRLF +
@"WHERE [ShipperID] = @ShipperID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@ShipperID", typeof(long), true, false, DbType.Int64, null, null, null);
_parameterschema = new VenturaSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaColumn("ShipperID", typeof(long), false)
{
Updateable = true,
IsKey = true,
BaseCatalogName = "main",
BaseTableName = "Shippers",
BaseColumnName = "ShipperID"
});
schema_array.Add(new VenturaColumn("Name", typeof(string), false)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "Shippers",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaColumn("Phone", typeof(string), true)
{
Updateable = true,
BaseCatalogName = "main",
BaseTableName = "Shippers",
BaseColumnName = "Phone"
});
((IResultsetBase)this).Schema = new VenturaSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Shippers]";
}
public GetAll_DbVersion_Recordset()
{
_resultsets = new IResultsetBase[] { this };
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("Version", typeof(string), false)
{
Updateable = true,
IsUnique = true,
IsKey = true
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[DbVersion]";
}
public GetAll_Sales_CountryRegionCurrency_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT TOP(@RowLimit) [CountryRegionCode],[CurrencyCode],[ModifiedDate]" + CRLF +
@"FROM [Sales].[CountryRegionCurrency]";
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("CountryRegionCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 12,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "CountryRegionCurrency",
BaseColumnName = "CountryRegionCode"
});
schema_array.Add(new VenturaSqlColumn("CurrencyCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 10,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "CountryRegionCurrency",
BaseColumnName = "CurrencyCode"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "CountryRegionCurrency",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[CountryRegionCurrency]";
}
