public void Insert()
{
using (var conn = IDbConnectionFactory.CreateConnection())
{
string cmd = @"
INSERT INTO [Production].[Product]
(
[Class],
[Color],
[DaysToManufacture],
[DiscontinuedDate],
[FinishedGoodsFlag],
[ListPrice],
[MakeFlag],
[ModifiedDate],
[Name],
[ProductLine],
[ProductModelID],
[ProductNumber],
[ProductSubcategoryID],
[ReorderPoint],
[SafetyStockLevel],
[SellEndDate],
[SellStartDate],
[Size],
[SizeUnitMeasureCode],
[StandardCost],
[Style],
[Weight],
[WeightUnitMeasureCode]
)
VALUES
(
@Class,
@Color,
@DaysToManufacture,
@DiscontinuedDate,
@FinishedGoodsFlag,
@ListPrice,
@MakeFlag,
@ModifiedDate,
@Name,
@ProductLine,
@ProductModelId,
@ProductNumber,
@ProductSubcategoryId,
@ReorderPoint,
@SafetyStockLevel,
@SellEndDate,
@SellStartDate,
@Size,
@SizeUnitMeasureCode,
@StandardCost,
@Style,
@Weight,
@WeightUnitMeasureCode
)";
this.ProductId = conn.Query <int>(cmd + "SELECT SCOPE_IDENTITY();", this).Single();
}
}
