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(); } }