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 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 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 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_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_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_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_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 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 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 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 PriKey_CountryCodes_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [CountryCodeID],[Name]" + CRLF +
@"FROM [CountryCodes]" + CRLF +
@"WHERE [CountryCodeID] = @CountryCodeID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@CountryCodeID", typeof(string), true, false, DbType.String, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
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 PriKey_Production_TransactionHistoryArchive_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [TransactionID],[ProductID],[ReferenceOrderID],[ReferenceOrderLineID],[TransactionDate],[TransactionType],[Quantity],[ActualCost],[ModifiedDate]" + CRLF +
@"FROM [Production].[TransactionHistoryArchive]" + CRLF +
@"WHERE [TransactionID] = @TransactionID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@TransactionID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("TransactionID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "TransactionID"
});
schema_array.Add(new VenturaSqlColumn("ProductID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "ProductID"
});
schema_array.Add(new VenturaSqlColumn("ReferenceOrderID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "ReferenceOrderID"
});
schema_array.Add(new VenturaSqlColumn("ReferenceOrderLineID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "ReferenceOrderLineID"
});
schema_array.Add(new VenturaSqlColumn("TransactionDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "TransactionDate"
});
schema_array.Add(new VenturaSqlColumn("TransactionType", typeof(string), false)
{
Updateable = true,
ColumnSize = 1,
ProviderType = 10,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "TransactionType"
});
schema_array.Add(new VenturaSqlColumn("Quantity", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "Quantity"
});
schema_array.Add(new VenturaSqlColumn("ActualCost", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "ActualCost"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "TransactionHistoryArchive",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[TransactionHistoryArchive]";
}
public SingleCustomerRecordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT * FROM Sales.Customer WHERE CustomerID = @CustomerID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@CustomerID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("CustomerID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Sales",
BaseTableName = "Customer",
BaseColumnName = "CustomerID"
});
schema_array.Add(new VenturaSqlColumn("PersonID", typeof(int), true)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Sales",
BaseTableName = "Customer",
BaseColumnName = "PersonID"
});
schema_array.Add(new VenturaSqlColumn("StoreID", typeof(int), true)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Sales",
BaseTableName = "Customer",
BaseColumnName = "StoreID"
});
schema_array.Add(new VenturaSqlColumn("TerritoryID", typeof(int), true)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Sales",
BaseTableName = "Customer",
BaseColumnName = "TerritoryID"
});
schema_array.Add(new VenturaSqlColumn("AccountNumber", typeof(string), false)
{
Updateable = true,
ColumnSize = 10,
ProviderType = 22,
BaseSchemaName = "Sales",
BaseTableName = "Customer",
BaseColumnName = "AccountNumber"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Sales",
BaseTableName = "Customer",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "Customer",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[Customer]";
}
public PriKey_Person_StateProvince_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [StateProvinceID],[StateProvinceCode],[CountryRegionCode],[IsOnlyStateProvinceFlag],[Name],[TerritoryID],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Person].[StateProvince]" + CRLF +
@"WHERE [StateProvinceID] = @StateProvinceID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@StateProvinceID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("StateProvinceID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "StateProvinceID"
});
schema_array.Add(new VenturaSqlColumn("StateProvinceCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 10,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "StateProvinceCode"
});
schema_array.Add(new VenturaSqlColumn("CountryRegionCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 12,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "CountryRegionCode"
});
schema_array.Add(new VenturaSqlColumn("IsOnlyStateProvinceFlag", typeof(bool), false)
{
Updateable = true,
ColumnSize = 1,
ProviderType = 2,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "IsOnlyStateProvinceFlag"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("TerritoryID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "TerritoryID"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Person",
BaseTableName = "StateProvince",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Person].[StateProvince]";
}
public PriKey_Purchasing_Vendor_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [BusinessEntityID],[AccountNumber],[Name],[CreditRating],[PreferredVendorStatus],[ActiveFlag],[PurchasingWebServiceURL],[ModifiedDate]" + CRLF +
@"FROM [Purchasing].[Vendor]" + CRLF +
@"WHERE [BusinessEntityID] = @BusinessEntityID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@BusinessEntityID", 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 = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("AccountNumber", typeof(string), false)
{
Updateable = true,
ColumnSize = 15,
ProviderType = 12,
BaseSchemaName = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "AccountNumber"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("CreditRating", typeof(byte), false)
{
Updateable = true,
ColumnSize = 1,
NumericPrecision = 3,
ProviderType = 20,
BaseSchemaName = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "CreditRating"
});
schema_array.Add(new VenturaSqlColumn("PreferredVendorStatus", typeof(bool), false)
{
Updateable = true,
ColumnSize = 1,
ProviderType = 2,
BaseSchemaName = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "PreferredVendorStatus"
});
schema_array.Add(new VenturaSqlColumn("ActiveFlag", typeof(bool), false)
{
Updateable = true,
ColumnSize = 1,
ProviderType = 2,
BaseSchemaName = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "ActiveFlag"
});
schema_array.Add(new VenturaSqlColumn("PurchasingWebServiceURL", typeof(string), true)
{
Updateable = true,
ColumnSize = 1024,
ProviderType = 12,
BaseSchemaName = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "PurchasingWebServiceURL"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Purchasing",
BaseTableName = "Vendor",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Purchasing].[Vendor]";
}
public ExecStoredProcedureRecordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"EXEC [dbo].[uspGetBillOfMaterials] @ParamStartProductID, @ParamCheckDate";
_inputparametervalues = new object[2];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@ParamStartProductID", typeof(int), true, false, DbType.Int32, null, null, null);
param_array.AddParameterColumn("@ParamCheckDate", typeof(DateTime), true, false, DbType.Date, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("ProductAssemblyID", typeof(int), true)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsExpression = true,
BaseColumnName = "ProductAssemblyID"
});
schema_array.Add(new VenturaSqlColumn("ComponentID", typeof(int), true)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsExpression = true,
BaseColumnName = "ComponentID"
});
schema_array.Add(new VenturaSqlColumn("ComponentDesc", typeof(string), true)
{
ColumnSize = 50,
ProviderType = 12,
IsExpression = true,
BaseColumnName = "ComponentDesc"
});
schema_array.Add(new VenturaSqlColumn("TotalQuantity", typeof(decimal), true)
{
ColumnSize = 17,
NumericPrecision = 38,
NumericScale = 2,
ProviderType = 5,
IsExpression = true,
BaseColumnName = "TotalQuantity"
});
schema_array.Add(new VenturaSqlColumn("StandardCost", typeof(decimal), true)
{
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
IsExpression = true,
BaseColumnName = "StandardCost"
});
schema_array.Add(new VenturaSqlColumn("ListPrice", typeof(decimal), true)
{
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
IsExpression = true,
BaseColumnName = "ListPrice"
});
schema_array.Add(new VenturaSqlColumn("BOMLevel", typeof(short), true)
{
ColumnSize = 2,
NumericPrecision = 5,
ProviderType = 16,
IsExpression = true,
BaseColumnName = "BOMLevel"
});
schema_array.Add(new VenturaSqlColumn("RecursionLevel", typeof(int), true)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsExpression = true,
BaseColumnName = "RecursionLevel"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
}
public PriKey_Production_WorkOrder_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [WorkOrderID],[ProductID],[OrderQty],[StockedQty],[ScrappedQty],[StartDate],[EndDate],[DueDate],[ScrapReasonID],[ModifiedDate]" + CRLF +
@"FROM [Production].[WorkOrder]" + CRLF +
@"WHERE [WorkOrderID] = @WorkOrderID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@WorkOrderID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("WorkOrderID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "WorkOrderID"
});
schema_array.Add(new VenturaSqlColumn("ProductID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "ProductID"
});
schema_array.Add(new VenturaSqlColumn("OrderQty", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "OrderQty"
});
schema_array.Add(new VenturaSqlColumn("StockedQty", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "StockedQty"
});
schema_array.Add(new VenturaSqlColumn("ScrappedQty", typeof(short), false)
{
Updateable = true,
ColumnSize = 2,
NumericPrecision = 5,
ProviderType = 16,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "ScrappedQty"
});
schema_array.Add(new VenturaSqlColumn("StartDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "StartDate"
});
schema_array.Add(new VenturaSqlColumn("EndDate", typeof(DateTime), true)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "EndDate"
});
schema_array.Add(new VenturaSqlColumn("DueDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "DueDate"
});
schema_array.Add(new VenturaSqlColumn("ScrapReasonID", typeof(short), true)
{
Updateable = true,
ColumnSize = 2,
NumericPrecision = 5,
ProviderType = 16,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "ScrapReasonID"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "WorkOrder",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[WorkOrder]";
}
public PriKey_Sales_CreditCard_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [CreditCardID],[CardType],[CardNumber],[ExpMonth],[ExpYear],[ModifiedDate]" + CRLF +
@"FROM [Sales].[CreditCard]" + CRLF +
@"WHERE [CreditCardID] = @CreditCardID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
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("CreditCardID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Sales",
BaseTableName = "CreditCard",
BaseColumnName = "CreditCardID"
});
schema_array.Add(new VenturaSqlColumn("CardType", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "CreditCard",
BaseColumnName = "CardType"
});
schema_array.Add(new VenturaSqlColumn("CardNumber", typeof(string), false)
{
Updateable = true,
ColumnSize = 25,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "CreditCard",
BaseColumnName = "CardNumber"
});
schema_array.Add(new VenturaSqlColumn("ExpMonth", typeof(byte), false)
{
Updateable = true,
ColumnSize = 1,
NumericPrecision = 3,
ProviderType = 20,
BaseSchemaName = "Sales",
BaseTableName = "CreditCard",
BaseColumnName = "ExpMonth"
});
schema_array.Add(new VenturaSqlColumn("ExpYear", typeof(short), false)
{
Updateable = true,
ColumnSize = 2,
NumericPrecision = 5,
ProviderType = 16,
BaseSchemaName = "Sales",
BaseTableName = "CreditCard",
BaseColumnName = "ExpYear"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "CreditCard",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[CreditCard]";
}
public PriKey_HumanResources_JobCandidate_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [JobCandidateID],[BusinessEntityID],[Resume],[ModifiedDate]" + CRLF +
@"FROM [HumanResources].[JobCandidate]" + CRLF +
@"WHERE [JobCandidateID] = @JobCandidateID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@JobCandidateID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("JobCandidateID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "HumanResources",
BaseTableName = "JobCandidate",
BaseColumnName = "JobCandidateID"
});
schema_array.Add(new VenturaSqlColumn("BusinessEntityID", typeof(int), true)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "HumanResources",
BaseTableName = "JobCandidate",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("Resume", typeof(string), true)
{
Updateable = true,
ProviderType = 25,
IsLong = true,
XmlSchemaCollectionDatabase = "AdventureWorks2017",
XmlSchemaCollectionOwningSchema = "HumanResources",
XmlSchemaCollectionName = "HRResumeSchemaCollection",
BaseSchemaName = "HumanResources",
BaseTableName = "JobCandidate",
BaseColumnName = "Resume"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "HumanResources",
BaseTableName = "JobCandidate",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[HumanResources].[JobCandidate]";
}
public PriKey_Production_BillOfMaterials_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [BillOfMaterialsID],[ProductAssemblyID],[ComponentID],[StartDate],[EndDate],[UnitMeasureCode],[BOMLevel],[PerAssemblyQty],[ModifiedDate]" + CRLF +
@"FROM [Production].[BillOfMaterials]" + CRLF +
@"WHERE [ProductAssemblyID] = @ProductAssemblyID" + CRLF +
@"AND [ComponentID] = @ComponentID" + CRLF +
@"AND [StartDate] = @StartDate";
_inputparametervalues = new object[3];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@ProductAssemblyID", typeof(int), true, false, DbType.Int32, null, null, null);
param_array.AddParameterColumn("@ComponentID", typeof(int), true, false, DbType.Int32, null, null, null);
param_array.AddParameterColumn("@StartDate", typeof(DateTime), true, false, DbType.DateTime, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("BillOfMaterialsID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "BillOfMaterialsID"
});
schema_array.Add(new VenturaSqlColumn("ProductAssemblyID", typeof(int), true)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "ProductAssemblyID"
});
schema_array.Add(new VenturaSqlColumn("ComponentID", typeof(int), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "ComponentID"
});
schema_array.Add(new VenturaSqlColumn("StartDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
IsKey = true,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "StartDate"
});
schema_array.Add(new VenturaSqlColumn("EndDate", typeof(DateTime), true)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "EndDate"
});
schema_array.Add(new VenturaSqlColumn("UnitMeasureCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 10,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "UnitMeasureCode"
});
schema_array.Add(new VenturaSqlColumn("BOMLevel", typeof(short), false)
{
Updateable = true,
ColumnSize = 2,
NumericPrecision = 5,
ProviderType = 16,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "BOMLevel"
});
schema_array.Add(new VenturaSqlColumn("PerAssemblyQty", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 17,
NumericPrecision = 8,
NumericScale = 2,
ProviderType = 5,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "PerAssemblyQty"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "BillOfMaterials",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[BillOfMaterials]";
}
public PriKey_Production_ProductModel_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [ProductModelID],[Name],[CatalogDescription],[Instructions],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Production].[ProductModel]" + CRLF +
@"WHERE [ProductModelID] = @ProductModelID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@ProductModelID", 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)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Production",
BaseTableName = "ProductModel",
BaseColumnName = "ProductModelID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Production",
BaseTableName = "ProductModel",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("CatalogDescription", typeof(string), true)
{
Updateable = true,
ProviderType = 25,
IsLong = true,
XmlSchemaCollectionDatabase = "AdventureWorks2017",
XmlSchemaCollectionOwningSchema = "Production",
XmlSchemaCollectionName = "ProductDescriptionSchemaCollection",
BaseSchemaName = "Production",
BaseTableName = "ProductModel",
BaseColumnName = "CatalogDescription"
});
schema_array.Add(new VenturaSqlColumn("Instructions", typeof(string), true)
{
Updateable = true,
ProviderType = 25,
IsLong = true,
XmlSchemaCollectionDatabase = "AdventureWorks2017",
XmlSchemaCollectionOwningSchema = "Production",
XmlSchemaCollectionName = "ManuInstructionsSchemaCollection",
BaseSchemaName = "Production",
BaseTableName = "ProductModel",
BaseColumnName = "Instructions"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Production",
BaseTableName = "ProductModel",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "ProductModel",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[ProductModel]";
}
public PriKey_Sales_SalesTerritory_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [TerritoryID],[Name],[CountryRegionCode],[Group],[SalesYTD],[SalesLastYear],[CostYTD],[CostLastYear],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Sales].[SalesTerritory]" + CRLF +
@"WHERE [TerritoryID] = @TerritoryID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@TerritoryID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("TerritoryID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "TerritoryID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("CountryRegionCode", typeof(string), false)
{
Updateable = true,
ColumnSize = 3,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "CountryRegionCode"
});
schema_array.Add(new VenturaSqlColumn("Group", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "Group"
});
schema_array.Add(new VenturaSqlColumn("SalesYTD", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "SalesYTD"
});
schema_array.Add(new VenturaSqlColumn("SalesLastYear", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "SalesLastYear"
});
schema_array.Add(new VenturaSqlColumn("CostYTD", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "CostYTD"
});
schema_array.Add(new VenturaSqlColumn("CostLastYear", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "CostLastYear"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "SalesTerritory",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[SalesTerritory]";
}
public PriKey_Sales_SalesPersonQuotaHistory_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [BusinessEntityID],[QuotaDate],[SalesQuota],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Sales].[SalesPersonQuotaHistory]" + CRLF +
@"WHERE [BusinessEntityID] = @BusinessEntityID" + CRLF +
@"AND [QuotaDate] = @QuotaDate";
_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("@QuotaDate", typeof(DateTime), true, false, DbType.DateTime, 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 = "SalesPersonQuotaHistory",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("QuotaDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
IsKey = true,
BaseSchemaName = "Sales",
BaseTableName = "SalesPersonQuotaHistory",
BaseColumnName = "QuotaDate"
});
schema_array.Add(new VenturaSqlColumn("SalesQuota", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 19,
ProviderType = 9,
BaseSchemaName = "Sales",
BaseTableName = "SalesPersonQuotaHistory",
BaseColumnName = "SalesQuota"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Sales",
BaseTableName = "SalesPersonQuotaHistory",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "SalesPersonQuotaHistory",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[SalesPersonQuotaHistory]";
}
public PriKey_Sales_SpecialOfferProduct_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [SpecialOfferID],[ProductID],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Sales].[SpecialOfferProduct]" + CRLF +
@"WHERE [SpecialOfferID] = @SpecialOfferID" + CRLF +
@"AND [ProductID] = @ProductID";
_inputparametervalues = new object[2];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@SpecialOfferID", typeof(int), true, false, DbType.Int32, null, null, null);
param_array.AddParameterColumn("@ProductID", typeof(int), true, false, DbType.Int32, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
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_Person_EmailAddress_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [BusinessEntityID],[EmailAddressID],[EmailAddress],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Person].[EmailAddress]" + CRLF +
@"WHERE [BusinessEntityID] = @BusinessEntityID" + CRLF +
@"AND [EmailAddressID] = @EmailAddressID";
_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("@EmailAddressID", 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 = "Person",
BaseTableName = "EmailAddress",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("EmailAddressID", typeof(int), false)
{
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Person",
BaseTableName = "EmailAddress",
BaseColumnName = "EmailAddressID"
});
schema_array.Add(new VenturaSqlColumn("EmailAddress", typeof(string), true)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Person",
BaseTableName = "EmailAddress",
BaseColumnName = "EmailAddress"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Person",
BaseTableName = "EmailAddress",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Person",
BaseTableName = "EmailAddress",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Person].[EmailAddress]";
}
public PriKey_HumanResources_Department_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [DepartmentID],[Name],[GroupName],[ModifiedDate]" + CRLF +
@"FROM [HumanResources].[Department]" + CRLF +
@"WHERE [DepartmentID] = @DepartmentID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@DepartmentID", typeof(short), true, false, DbType.Int16, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
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_Sales_Store_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [BusinessEntityID],[Name],[SalesPersonID],[Demographics],[rowguid],[ModifiedDate]" + CRLF +
@"FROM [Sales].[Store]" + CRLF +
@"WHERE [BusinessEntityID] = @BusinessEntityID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@BusinessEntityID", 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 = "Store",
BaseColumnName = "BusinessEntityID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Sales",
BaseTableName = "Store",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("SalesPersonID", typeof(int), true)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 8,
BaseSchemaName = "Sales",
BaseTableName = "Store",
BaseColumnName = "SalesPersonID"
});
schema_array.Add(new VenturaSqlColumn("Demographics", typeof(string), true)
{
Updateable = true,
ProviderType = 25,
IsLong = true,
XmlSchemaCollectionDatabase = "AdventureWorks2017",
XmlSchemaCollectionOwningSchema = "Sales",
XmlSchemaCollectionName = "StoreSurveySchemaCollection",
BaseSchemaName = "Sales",
BaseTableName = "Store",
BaseColumnName = "Demographics"
});
schema_array.Add(new VenturaSqlColumn("rowguid", typeof(Guid), false)
{
Updateable = true,
ColumnSize = 16,
ProviderType = 14,
BaseSchemaName = "Sales",
BaseTableName = "Store",
BaseColumnName = "rowguid"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Sales",
BaseTableName = "Store",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Sales].[Store]";
}
public PriKey_Production_Location_Recordset()
{
_resultsets = new IResultsetBase[] { this };
_sqlscript = @"SELECT [LocationID],[Name],[CostRate],[Availability],[ModifiedDate]" + CRLF +
@"FROM [Production].[Location]" + CRLF +
@"WHERE [LocationID] = @LocationID";
_inputparametervalues = new object[1];
_inputparamholder = new InputParamHolder(_inputparametervalues);
ColumnArrayBuilder param_array = new ColumnArrayBuilder();
param_array.AddParameterColumn("@LocationID", typeof(short), true, false, DbType.Int16, null, null, null);
_parameterschema = new VenturaSqlSchema(param_array);
ColumnArrayBuilder schema_array = new ColumnArrayBuilder();
schema_array.Add(new VenturaSqlColumn("LocationID", typeof(short), false)
{
ColumnSize = 2,
NumericPrecision = 5,
ProviderType = 16,
IsKey = true,
IsIdentity = true,
IsAutoIncrement = true,
BaseSchemaName = "Production",
BaseTableName = "Location",
BaseColumnName = "LocationID"
});
schema_array.Add(new VenturaSqlColumn("Name", typeof(string), false)
{
Updateable = true,
ColumnSize = 50,
ProviderType = 12,
BaseSchemaName = "Production",
BaseTableName = "Location",
BaseColumnName = "Name"
});
schema_array.Add(new VenturaSqlColumn("CostRate", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 4,
NumericPrecision = 10,
ProviderType = 17,
BaseSchemaName = "Production",
BaseTableName = "Location",
BaseColumnName = "CostRate"
});
schema_array.Add(new VenturaSqlColumn("Availability", typeof(decimal), false)
{
Updateable = true,
ColumnSize = 17,
NumericPrecision = 8,
NumericScale = 2,
ProviderType = 5,
BaseSchemaName = "Production",
BaseTableName = "Location",
BaseColumnName = "Availability"
});
schema_array.Add(new VenturaSqlColumn("ModifiedDate", typeof(DateTime), false)
{
Updateable = true,
ColumnSize = 8,
NumericPrecision = 23,
NumericScale = 3,
ProviderType = 4,
BaseSchemaName = "Production",
BaseTableName = "Location",
BaseColumnName = "ModifiedDate"
});
((IResultsetBase)this).Schema = new VenturaSqlSchema(schema_array);
((IResultsetBase)this).UpdateableTablename = "[Production].[Location]";
}