public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[ShoppingCartItem]
(
[DateCreated],
[ModifiedDate],
[ProductID],
[Quantity],
[ShoppingCartID]
)
VALUES
(
@DateCreated,
@ModifiedDate,
@ProductId,
@Quantity,
@ShoppingCartId
)";
this.ShoppingCartItemId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[ProductReview]
(
[Comments],
[EmailAddress],
[ModifiedDate],
[ProductID],
[Rating],
[ReviewDate],
[ReviewerName]
)
VALUES
(
@Comments,
@EmailAddress,
@ModifiedDate,
@ProductId,
@Rating,
@ReviewDate,
@ReviewerName
)";
this.ProductReviewId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[SalesPerson]
(
[Bonus],
[BusinessEntityID],
[CommissionPct],
[ModifiedDate],
[SalesLastYear],
[SalesQuota],
[SalesYTD],
[TerritoryID]
)
VALUES
(
@Bonus,
@BusinessEntityId,
@CommissionPct,
@ModifiedDate,
@SalesLastYear,
@SalesQuota,
@SalesYtd,
@TerritoryId
)";
conn.Execute(cmd, this);
}
}
public void Update()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
UPDATE [Sales].[SalesOrderHeader] SET
[AccountNumber] = @AccountNumber,
[BillToAddressID] = @BillToAddressId,
[Comment] = @Comment,
[CreditCardApprovalCode] = @CreditCardApprovalCode,
[CreditCardID] = @CreditCardId,
[CurrencyRateID] = @CurrencyRateId,
[CustomerID] = @CustomerId,
[DueDate] = @DueDate,
[Freight] = @Freight,
[ModifiedDate] = @ModifiedDate,
[OnlineOrderFlag] = @OnlineOrderFlag,
[OrderDate] = @OrderDate,
[PurchaseOrderNumber] = @PurchaseOrderNumber,
[RevisionNumber] = @RevisionNumber,
[SalesPersonID] = @SalesPersonId,
[ShipDate] = @ShipDate,
[ShipMethodID] = @ShipMethodId,
[ShipToAddressID] = @ShipToAddressId,
[Status] = @Status,
[SubTotal] = @SubTotal,
[TaxAmt] = @TaxAmt,
[TerritoryID] = @TerritoryId
WHERE
[SalesOrderID] = @SalesOrderId";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [HumanResources].[EmployeeDepartmentHistory]
(
[BusinessEntityID],
[DepartmentID],
[EndDate],
[ModifiedDate],
[ShiftID],
[StartDate]
)
VALUES
(
@BusinessEntityId,
@DepartmentId,
@EndDate,
@ModifiedDate,
@ShiftId,
@StartDate
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[ProductPhoto]
(
[LargePhoto],
[LargePhotoFileName],
[ModifiedDate],
[ThumbNailPhoto],
[ThumbnailPhotoFileName]
)
VALUES
(
@LargePhoto,
@LargePhotoFileName,
@ModifiedDate,
@ThumbNailPhoto,
@ThumbnailPhotoFileName
)";
this.ProductPhotoId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Update()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
UPDATE [Production].[WorkOrderRouting] SET
[ActualCost] = @ActualCost,
[ActualEndDate] = @ActualEndDate,
[ActualResourceHrs] = @ActualResourceHrs,
[ActualStartDate] = @ActualStartDate,
[LocationID] = @LocationId,
[ModifiedDate] = @ModifiedDate,
[OperationSequence] = @OperationSequence,
[PlannedCost] = @PlannedCost,
[ProductID] = @ProductId,
[ScheduledEndDate] = @ScheduledEndDate,
[ScheduledStartDate] = @ScheduledStartDate,
[WorkOrderID] = @WorkOrderId
WHERE
[WorkOrderID] = @WorkOrderId AND
[ProductID] = @ProductId AND
[OperationSequence] = @OperationSequence";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[SalesOrderDetail]
(
[CarrierTrackingNumber],
[ModifiedDate],
[OrderQty],
[ProductID],
[SalesOrderID],
[SpecialOfferID],
[UnitPrice],
[UnitPriceDiscount]
)
VALUES
(
@CarrierTrackingNumber,
@ModifiedDate,
@OrderQty,
@ProductId,
@SalesOrderId,
@SpecialOfferId,
@UnitPrice,
@UnitPriceDiscount
)";
this.SalesOrderDetailId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Update()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
UPDATE [Production].[Product] SET
[Class] = @Class,
[Color] = @Color,
[DaysToManufacture] = @DaysToManufacture,
[DiscontinuedDate] = @DiscontinuedDate,
[FinishedGoodsFlag] = @FinishedGoodsFlag,
[ListPrice] = @ListPrice,
[MakeFlag] = @MakeFlag,
[ModifiedDate] = @ModifiedDate,
[Name] = @Name,
[ProductLine] = @ProductLine,
[ProductModelID] = @ProductModelId,
[ProductNumber] = @ProductNumber,
[ProductSubcategoryID] = @ProductSubcategoryId,
[ReorderPoint] = @ReorderPoint,
[SafetyStockLevel] = @SafetyStockLevel,
[SellEndDate] = @SellEndDate,
[SellStartDate] = @SellStartDate,
[Size] = @Size,
[SizeUnitMeasureCode] = @SizeUnitMeasureCode,
[StandardCost] = @StandardCost,
[Style] = @Style,
[Weight] = @Weight,
[WeightUnitMeasureCode] = @WeightUnitMeasureCode
WHERE
[ProductID] = @ProductId";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[ProductInventory]
(
[Bin],
[LocationID],
[ModifiedDate],
[ProductID],
[Quantity],
[Shelf]
)
VALUES
(
@Bin,
@LocationId,
@ModifiedDate,
@ProductId,
@Quantity,
@Shelf
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[TransactionHistory]
(
[ActualCost],
[ModifiedDate],
[ProductID],
[Quantity],
[ReferenceOrderID],
[ReferenceOrderLineID],
[TransactionDate],
[TransactionType]
)
VALUES
(
@ActualCost,
@ModifiedDate,
@ProductId,
@Quantity,
@ReferenceOrderId,
@ReferenceOrderLineId,
@TransactionDate,
@TransactionType
)";
this.TransactionId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Purchasing].[PurchaseOrderDetail]
(
[DueDate],
[ModifiedDate],
[OrderQty],
[ProductID],
[PurchaseOrderID],
[ReceivedQty],
[RejectedQty],
[UnitPrice]
)
VALUES
(
@DueDate,
@ModifiedDate,
@OrderQty,
@ProductId,
@PurchaseOrderId,
@ReceivedQty,
@RejectedQty,
@UnitPrice
)";
this.PurchaseOrderDetailId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [DatabaseLog]
(
[DatabaseUser],
[Event],
[Object],
[PostTime],
[Schema],
[TSQL],
[XmlEvent]
)
VALUES
(
@DatabaseUser,
@Event,
@Object,
@PostTime,
@Schema,
@Tsql,
@XmlEvent
)";
this.DatabaseLogId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[SalesOrderDetail]
(
[CarrierTrackingNumber],
[ModifiedDate],
[OrderQty],
[ProductID],
[SalesOrderID],
[SpecialOfferID],
[UnitPrice],
[UnitPriceDiscount]
)
VALUES
(
@CarrierTrackingNumber,
@ModifiedDate,
@OrderQty,
@ProductId,
@SalesOrderId,
@SpecialOfferId,
@UnitPrice,
@UnitPriceDiscount
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Purchasing].[PurchaseOrderDetail]
(
[DueDate],
[ModifiedDate],
[OrderQty],
[ProductID],
[PurchaseOrderID],
[ReceivedQty],
[RejectedQty],
[UnitPrice]
)
VALUES
(
@DueDate,
@ModifiedDate,
@OrderQty,
@ProductId,
@PurchaseOrderId,
@ReceivedQty,
@RejectedQty,
@UnitPrice
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[SalesTerritoryHistory]
(
[BusinessEntityID],
[EndDate],
[ModifiedDate],
[StartDate],
[TerritoryID]
)
VALUES
(
@BusinessEntityId,
@EndDate,
@ModifiedDate,
@StartDate,
@TerritoryId
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Purchasing].[Vendor]
(
[AccountNumber],
[ActiveFlag],
[BusinessEntityID],
[CreditRating],
[ModifiedDate],
[Name],
[PreferredVendorStatus],
[PurchasingWebServiceURL]
)
VALUES
(
@AccountNumber,
@ActiveFlag,
@BusinessEntityId,
@CreditRating,
@ModifiedDate,
@Name,
@PreferredVendorStatus,
@PurchasingWebServiceUrl
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[BillOfMaterials]
(
[BOMLevel],
[ComponentID],
[EndDate],
[ModifiedDate],
[PerAssemblyQty],
[ProductAssemblyID],
[StartDate],
[UnitMeasureCode]
)
VALUES
(
@BomLevel,
@ComponentId,
@EndDate,
@ModifiedDate,
@PerAssemblyQty,
@ProductAssemblyId,
@StartDate,
@UnitMeasureCode
)";
this.BillOfMaterialsId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [HumanResources].[EmployeePayHistory]
(
[BusinessEntityID],
[ModifiedDate],
[PayFrequency],
[Rate],
[RateChangeDate]
)
VALUES
(
@BusinessEntityId,
@ModifiedDate,
@PayFrequency,
@Rate,
@RateChangeDate
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Person].[Address]
(
[AddressLine1],
[AddressLine2],
[City],
[ModifiedDate],
[PostalCode],
[StateProvinceID]
)
VALUES
(
@AddressLine1,
@AddressLine2,
@City,
@ModifiedDate,
@PostalCode,
@StateProvinceId
)";
this.AddressId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[SalesTaxRate]
(
[ModifiedDate],
[Name],
[StateProvinceID],
[TaxRate],
[TaxType]
)
VALUES
(
@ModifiedDate,
@Name,
@StateProvinceId,
@TaxRate,
@TaxType
)";
this.SalesTaxRateId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[TransactionHistoryArchive]
(
[ActualCost],
[ModifiedDate],
[ProductID],
[Quantity],
[ReferenceOrderID],
[ReferenceOrderLineID],
[TransactionDate],
[TransactionID],
[TransactionType]
)
VALUES
(
@ActualCost,
@ModifiedDate,
@ProductId,
@Quantity,
@ReferenceOrderId,
@ReferenceOrderLineId,
@TransactionDate,
@TransactionId,
@TransactionType
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Person].[StateProvince]
(
[CountryRegionCode],
[IsOnlyStateProvinceFlag],
[ModifiedDate],
[Name],
[StateProvinceCode],
[TerritoryID]
)
VALUES
(
@CountryRegionCode,
@IsOnlyStateProvinceFlag,
@ModifiedDate,
@Name,
@StateProvinceCode,
@TerritoryId
)";
this.StateProvinceId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[SpecialOffer]
(
[Category],
[Description],
[DiscountPct],
[EndDate],
[MaxQty],
[MinQty],
[ModifiedDate],
[StartDate],
[Type]
)
VALUES
(
@Category,
@Description,
@DiscountPct,
@EndDate,
@MaxQty,
@MinQty,
@ModifiedDate,
@StartDate,
@Type
)";
this.SpecialOfferId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[WorkOrder]
(
[DueDate],
[EndDate],
[ModifiedDate],
[OrderQty],
[ProductID],
[ScrappedQty],
[ScrapReasonID],
[StartDate]
)
VALUES
(
@DueDate,
@EndDate,
@ModifiedDate,
@OrderQty,
@ProductId,
@ScrappedQty,
@ScrapReasonId,
@StartDate
)";
this.WorkOrderId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[Store]
(
[BusinessEntityID],
[Demographics],
[ModifiedDate],
[Name],
[SalesPersonID]
)
VALUES
(
@BusinessEntityId,
@Demographics,
@ModifiedDate,
@Name,
@SalesPersonId
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[CurrencyRate]
(
[AverageRate],
[CurrencyRateDate],
[EndOfDayRate],
[FromCurrencyCode],
[ModifiedDate],
[ToCurrencyCode]
)
VALUES
(
@AverageRate,
@CurrencyRateDate,
@EndOfDayRate,
@FromCurrencyCode,
@ModifiedDate,
@ToCurrencyCode
)";
this.CurrencyRateId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[CreditCard]
(
[CardNumber],
[CardType],
[ExpMonth],
[ExpYear],
[ModifiedDate]
)
VALUES
(
@CardNumber,
@CardType,
@ExpMonth,
@ExpYear,
@ModifiedDate
)";
this.CreditCardId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[ProductListPriceHistory]
(
[EndDate],
[ListPrice],
[ModifiedDate],
[ProductID],
[StartDate]
)
VALUES
(
@EndDate,
@ListPrice,
@ModifiedDate,
@ProductId,
@StartDate
)";
conn.Execute(cmd, this);
}
}
public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Sales].[SalesTerritory]
(
[CostLastYear],
[CostYTD],
[CountryRegionCode],
[Group],
[ModifiedDate],
[Name],
[SalesLastYear],
[SalesYTD]
)
VALUES
(
@CostLastYear,
@CostYtd,
@CountryRegionCode,
@Group,
@ModifiedDate,
@Name,
@SalesLastYear,
@SalesYtd
)";
this.TerritoryId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
