Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Public Sub InsertSupplier(ByVal SupplierObject As Supplier) Implements ISupplierRepository.InsertSupplier
- SupplierObject.SupplierID = MyBase.ExecuteNonQueryWithReturnValue("usp_Northwind_InsertSupplier", SupplierObject.CompanyName)
- End Sub
- USE [Northwind]
- GO
- /****** Object: StoredProcedure [dbo].[usp_Northwind_InsertSupplier] Script Date: 1/1/2009 10:59:01 AM ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE PROCEDURE [dbo].[usp_Northwind_InsertSupplier]
- @CompanyName nvarchar(40)
- AS
- INSERT INTO dbo.Suppliers
- VALUES (@CompanyName)
- RETURN @@Identity
- Public Function ExecuteNonQueryWithReturnValue(ByVal storedProcedureName As String, ByVal ParamArray parameterValues() As Object) As Object Implements Interfaces.IRepository(Of T).ExecuteNonQueryWithReturnValue
- Dim Output As Object
- Dim db As Database = DatabaseFactory.CreateDatabase()
- Dim dbCommand As Common.DbCommand = db.GetStoredProcCommand(storedProcedureName, parameterValues)
- db.ExecuteNonQuery(dbCommand)
- Output = CType(db.GetParameterValue(dbCommand, "@RETURN_VALUE"), Object)
- Return Output
- End Function
- CREATE PROCEDURE YourSP
- (@ID int OUTPUT, ...
Add Comment
Please, Sign In to add comment