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_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 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_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_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 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_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_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 PriKey_CountryCodes_Recordset() { _resultsets = new IResultsetBase[] { this }; _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, 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 = "[CountryCodes]"; }
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 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_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 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 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 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_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_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 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]"; }
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 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]"; }