public void Test_11_CreateProcedure()
{
DBParam custid = DBParam.Param("cust", DbType.Int32);
DBParam orderid = DBParam.Param("id", DbType.Int32, ParameterDirection.Input);
DBParam name = DBParam.Param("name", DbType.String, 50, ParameterDirection.Input);
DBQuery create = DBQuery.Create.StoredProcedure("dbo", "ChangeOrderItemCustomer")
.WithParams(orderid, name)
.As(
DBQuery.Declare(custid),
DBQuery.Select().TopN(1)
.Field(DBAssign.Set(custid, DBField.Field("customerid")))
.From("Orders")
.WhereFieldEquals("order_id", orderid),
DBQuery.Update("OrderItems")
.Set("customerid", custid)
.Set("customername", name)
.WhereFieldEquals("orderid", orderid)
);
this.OutputAndValidate(create, " Create Procedure ChangeOrderItemCustomer");
}
